Форум пользователей MySQL

SELECT c.*, a.*, d.name, COUNT(r.product_id) as kol_product
FROM `oc_categoryonpage_list` as c
LEFT JOIN `oc_category` as a ON c.category_id = a.category_id
LEFT JOIN `oc_category_description` as d ON c.category_id = d.category_id and d.language_id = '3'
LEFT JOIN `oc_product_to_category` as r ON c.category_id = r.category_id
ORDER by c.position ASC LIMIT 20

SELECT c.*, a.*, d.name, COUNT(r.product_id) as kol_product
FROM `oc_categoryonpage_list` as c
LEFT JOIN `oc_category` as a ON c.category_id = a.category_id
LEFT JOIN `oc_category_description` as d ON c.category_id = d.category_id and d.language_id = '3'
LEFT JOIN `oc_product_to_category` as r ON c.category_id = r.category_id
group by ...
ORDER by c.position ASC LIMIT 20