ERROR: select c.categories_id, count(p.products_id) as product_count
from categories c
left join categories_description cd on cd.categories_id=c.categories_id
left join products_to_categories p2c on p2c.categories_id=c.categories_id
left join products p on p.products_id=p2c.products_id where (c.categories_id in ( ))
and cd.language_id='1'
and p.products_status=1 group by c.categories_id
order by c.sort_order, cd.categories_name