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 = 'ΓΛΥΚΑ' HAVING itemCount > 0 ORDER BY s.cat_order ASC;
Array ( [0] => Array ( [0] => frm_subcat_5 [category_id] => frm_subcat_5 [1] => Torte [name] => Torte [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Τούρτες [defaultName] => Τούρτες [4] => 34 [itemCount] => 34 ) [1] => Array ( [0] => frm_subcat_16 [category_id] => frm_subcat_16 [1] => Mini Torte [name] => Mini Torte [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Τούρτες Μίνι [defaultName] => Τούρτες Μίνι [4] => 11 [itemCount] => 11 ) [2] => Array ( [0] => frm_subcat_13 [category_id] => frm_subcat_13 [1] => Bowl - Portion [name] => Bowl - Portion [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Μπολ Ατομικά [defaultName] => Μπολ Ατομικά [4] => 8 [itemCount] => 8 ) [3] => Array ( [0] => frm_subcat_15 [category_id] => frm_subcat_15 [1] => Toertchen Portion [name] => Toertchen Portion [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Πάστες [defaultName] => Πάστες [4] => 40 [itemCount] => 40 ) [4] => Array ( [0] => frm_subcat_7 [category_id] => frm_subcat_7 [1] => Sirup Sweets [name] => Sirup Sweets [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Σιροπιαστά [defaultName] => Σιροπιαστά [4] => 17 [itemCount] => 17 ) [5] => Array ( [0] => frm_subcat_6 [category_id] => frm_subcat_6 [1] => Kaffe Desserts [name] => Kaffe Desserts [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Γλυκά - Καφέ [defaultName] => Γλυκά - Καφέ [4] => 13 [itemCount] => 13 ) [6] => Array ( [0] => frm_subcat_11 [category_id] => frm_subcat_11 [1] => Suesse Leckereien [name] => Suesse Leckereien [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Κεράσματα [defaultName] => Κεράσματα [4] => 13 [itemCount] => 13 ) [7] => Array ( [0] => frm_subcat_9 [category_id] => frm_subcat_9 [1] => Mini Shots [name] => Mini Shots [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Σφηνάκια [defaultName] => Σφηνάκια [4] => 8 [itemCount] => 8 ) [8] => Array ( [0] => frm_subcat_8 [category_id] => frm_subcat_8 [1] => Miniatures Suesse [name] => Miniatures Suesse [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Μινιατούρες [defaultName] => Μινιατούρες [4] => 25 [itemCount] => 25 ) [9] => Array ( [0] => frm_subcat_14 [category_id] => frm_subcat_14 [1] => Hotel Plate 40x40 [name] => Hotel Plate 40x40 [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Πλάκες Ξενοδοχείου [defaultName] => Πλάκες Ξενοδοχείου [4] => 5 [itemCount] => 5 ) )

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 = 'ΓΛΥΚΑ ΣΤΕΒΙΑ' HAVING itemCount > 0 ORDER BY s.cat_order ASC;
Array ( [0] => Array ( [0] => frm_subcat_2 [category_id] => frm_subcat_2 [1] => Torte [name] => Torte [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] => Toertchen Portion [name] => Toertchen Portion [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Πάστες [defaultName] => Πάστες [4] => 4 [itemCount] => 4 ) )

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 = 'ΑΛΜΥΡΕΣ ΚΑΙ ΓΛΥΚΕΣ ΝΟΣΤΙΜΙΕΣ' HAVING itemCount > 0 ORDER BY s.cat_order ASC;
Array ( [0] => Array ( [0] => frm_subcat_1 [category_id] => frm_subcat_1 [1] => Süße Köstlichkeiten [name] => Süße Köstlichkeiten [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Γλυκές λιχουδιές [defaultName] => Γλυκές λιχουδιές [4] => 5 [itemCount] => 5 ) [1] => Array ( [0] => frm_subcat_2 [category_id] => frm_subcat_2 [1] => Herzhafte Köstlichkeiten [name] => Herzhafte Köstlichkeiten [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Αλμυρές λιχουδιές [defaultName] => Αλμυρές λιχουδιές [4] => 19 [itemCount] => 19 ) )

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 = 'ΠΑΓΩΤΑ' HAVING itemCount > 0 ORDER BY s.cat_order ASC;
Array ( [0] => Array ( [0] => frm_subcat_6 [category_id] => frm_subcat_6 [1] => Eistorten [name] => Eistorten [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Τούρτα - Παγωτό [defaultName] => Τούρτα - Παγωτό [4] => 19 [itemCount] => 19 ) [1] => Array ( [0] => frm_subcat_10 [category_id] => frm_subcat_10 [1] => Eistorten Miss Gelo [name] => Eistorten Miss Gelo [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Τούρτα - Παγωτό Miss Gelo [defaultName] => Τούρτα - Παγωτό Miss Gelo [4] => 12 [itemCount] => 12 ) [2] => Array ( [0] => frm_subcat_9 [category_id] => frm_subcat_9 [1] => Mini Semifredo Kuchen [name] => Mini Semifredo Kuchen [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Παγωτίνια Χειροποίητα [defaultName] => Παγωτίνια Χειροποίητα [4] => 9 [itemCount] => 9 ) [3] => Array ( [0] => frm_subcat_7 [category_id] => frm_subcat_7 [1] => Mini Eis Rocket-Waffel [name] => Mini Eis Rocket-Waffel [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Παγωτίνια Χωνάκι [defaultName] => Παγωτίνια Χωνάκι [4] => 5 [itemCount] => 5 ) [4] => Array ( [0] => frm_subcat_8 [category_id] => frm_subcat_8 [1] => Mini Eis Stick [name] => Mini Eis Stick [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Παγωτίνια Ξυλάκι [defaultName] => Παγωτίνια Ξυλάκι [4] => 13 [itemCount] => 13 ) [5] => Array ( [0] => frm_subcat_11 [category_id] => frm_subcat_11 [1] => Eiscreme [name] => Eiscreme [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Σπιτικό Παγωτό [defaultName] => Σπιτικό Παγωτό [4] => 15 [itemCount] => 15 ) )