SELECT s.category_id, COALESCE(s.category_value_2,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 = 'ΓΛΥΚΑ ΣΤΕΒΙΑ' HAVING itemCount > 0 ORDER BY s.cat_order ASC;
Array
(
[0] => Array
(
[0] => frm_subcat_2
[category_id] => frm_subcat_2
[1] => Cakes
[name] => Cakes
[2] => frm_entity_9
[entity_id] => frm_entity_9
[3] => Τούρτες
[defaultName] => Τούρτες
[4] => 3
[itemCount] => 3
)
[1] => Array
(
[0] => frm_subcat_1
[category_id] => frm_subcat_1
[1] => Individual Cakes
[name] => Individual Cakes
[2] => frm_entity_9
[entity_id] => frm_entity_9
[3] => Πάστες
[defaultName] => Πάστες
[4] => 4
[itemCount] => 4
)
)
- Cakes
- Individual Cakes