SELECT s.category_id, COALESCE(s.category_value_3,s.category_value_1) AS name, e.entity_id, s.category_value_1 AS defaultName, (SELECT COUNT(*) FROM item_categories i WHERE i.subcat_id = s.unique_id) AS itemCount FROM categories c JOIN entities e ON c.parent_id = e.entity_id JOIN subcategories s ON s.parent_id = c.unique_id WHERE e.entity_value_1 = 'PRODUCTS' AND c.category_value_1 = 'PETIT FOUR' HAVING itemCount > 0 ORDER BY s.cat_order ASC;
Array
(
[0] => Array
(
[0] => frm_subcat_1
[category_id] => frm_subcat_1
[1] => Alle
[name] => Alle
[2] => frm_entity_9
[entity_id] => frm_entity_9
[3] => Όλα
[defaultName] => Όλα
[4] => 10
[itemCount] => 10
)
)
- Alle