select c.categories_id, cd.categories_name, c.parent_id, count(distinct p.products_id) as total from (categories c, categories_description cd, products_to_categories p2c) left join products p on (p2c.products_id = p.products_id) where p.products_date_available <= '2025-12-07' and p.products_status = 1 and p2c.categories_id = c.categories_id and c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='4' and c.sort_order >= 1 group by c.categories_id order by c.sort_order, cd.categories_name
初めての方へ
