Ver originalSELECT Sbc.id_noticia, Sbc.contenido, SUM(Sbc.votos_) as NVotos, SUM(Sbc.comentarios_) as NComentariosFROM ( SELECT n.id_noticia, n.contenido, COUNT(*) AS votos_, 0 AS comentarios_ FROM noticias AS n LEFT JOIN votos AS v ON n.id_noticia = v.id_noticia GROUP BY n.id_noticiaUNION ALL SELECT n1.id_noticia, n1.contenido, 0 AS votos_, COUNT(*) AS comentarios_ FROM noticias AS n1 LEFT JOIN comentarios AS c ON n1.id_noticia = c.id_noticia GROUP BY n.id_noticia ) as SbcGROUP BY Sbc.id_noticia;