Query SELECT p.*, t.code as kat_kod, COUNT(rt.id) as couid FROM rendelesek r, `rendeles_tetelek` rt, products p LEFT JOIN tree t ON p.category_id=t.id WHERE r.penznem=1 AND r.datum>DATE_SUB(NOW(), INTERVAL 1 MONTH) AND rt.prod_id=p.id AND rt.rendeles_id=r.id AND p.active=1 GROUP BY rt.prod_id ORDER BY couid DESC LIMIT 10 failed