Consulta a 3 tablas

[tomas23pe]

Resuelto el LEFT JOIN a 3 tablas :

SELECT COUNT(nc.idn) AS comentarios, n.id_news, n.title_en
FROM (news n LEFT JOIN news_cat nct ON n.category = nct.id_ncat) LEFT JOIN news_comm nc ON n.id_news = nc.idn
WHERE n.status = 1
GROUP BY n.id_news
ORDER BY n.updated DESC