Consulta multitabla y count()

[quimfv]

Código MySQL:

SELECT Sbc.id_noticia, 
             Sbc.contenido, 
             SUM(Sbc.votos_) as NVotos,
             SUM(Sbc.comentarios_) as NComentarios
FROM (
     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_noticia
UNION 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 Sbc
GROUP BY Sbc.id_noticia;
 

Esto servirá....