SELECT n.*, COUNT(c.pid) AS ile FROM tabela1 AS n, tabela2 AS c WHERE (n.id = c.pid) GROUP BY n.id DESC';
SELECT n.*, COUNT(c.pid) AS ile FROM tabela1 AS n, tabela2 AS c WHERE (n.id = c.pid) GROUP BY n.id DESC';
SELECT n.id, n.news, COUNT(c.pid) AS ile FROM tabela1 n, tabela2 c WHERE n.id = c.pid GROUP BY n.id, n.news';
SELECT n.*, COUNT(c.pid) AS ile FROM news AS n LEFT JOIN comment AS c ON c.pid = n.id GROUP BY n.id DESC