SELECT da.t_visitas,da.t_referencia, sub2.dados_instagram, sub2.Tipo_Reservado, sub.total1 AS Tipo1,
	sub.total_tipo1,sub1.total_tipo2
FROM `probando` da,
(
	SELECT COUNT(t_visitas) AS total1,SUM(custo_pago) total_tipo1
	FROM `probando`
	WHERE t_visitas = 'visitas'  AND rifas_id = 1  AND type = 1
	GROUP BY rifas_id
) AS sub,
(
	SELECT rifas_id, SUM(custo_pago) total_tipo2
	FROM `probando`
	WHERE t_visitas = 'visitas'  AND rifas_id = 1  AND type = 2
	GROUP BY rifas_id
) AS sub1,
(
	SELECT t_referencia, COUNT(t_visitas) AS dados_instagram, COUNT(type) AS Tipo_Reservado

t_visitas | t_referencia | datos_instagram | tipo_Reservado | tipo1 | total_tipo1 | total_tipo2

visitas | 123ax | 1 | 1 | 1 | 60 | 30
visitas | o2t5x | 1 | 1 | 2 | 60 | 30

SELECT  da.t_visitas,
        da.t_referencia,
        COUNT(CASE WHEN da.type = 1 THEN 1 ELSE NULL END)      AS Tipo1,
        SUM(CASE WHEN da.type = 1 THEN custo_pago ELSE 0 END)  AS Total_Tipo1
        FROM `probando` da,
        WHERE da.t_visitas = 'visitas'
              AND da.rifas_id = 1
        GROUP BY da.t_visitas,
                da.t_referencia

WHERE t_visitas = 'visitas'  AND rifas_id = 1  AND type = 2

COUNT(CASE WHEN da.type = 2 THEN 1 ELSE NULL END)      AS Tipo2,
SUM(CASE WHEN da.type = 2 THEN custo_pago ELSE 0 END)  AS Total_Tipo2