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_5 [category_id] => frm_subcat_5 [1] => Cakes [name] => Cakes [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 Cakes [name] => Mini Cakes [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] => Individual Bowls [name] => Individual Bowls [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] => Individual Cakes [name] => Individual Cakes [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] => Syrup Sweets [name] => Syrup 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] => Coffee Desserts [name] => Coffee 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] => Sweet Treats [name] => Sweet Treats [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] => Miniature Sweets [name] => Miniature Sweets [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 Plates [name] => Hotel Plates [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Πλάκες Ξενοδοχείου [defaultName] => Πλάκες Ξενοδοχείου [4] => 5 [itemCount] => 5 ) )

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 ) )

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_1 [category_id] => frm_subcat_1 [1] => Christmas Cakes [name] => Christmas Cakes [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Χριστουγενιάτικες Τούρτες [defaultName] => Χριστουγενιάτικες Τούρτες [4] => 18 [itemCount] => 18 ) [1] => Array ( [0] => frm_subcat_2 [category_id] => frm_subcat_2 [1] => Seasonal Cakes [name] => Seasonal Cakes [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Χριστουγενιάτικα Εποχιακά Κείκ [defaultName] => Χριστουγενιάτικα Εποχιακά Κείκ [4] => 9 [itemCount] => 9 ) [2] => Array ( [0] => frm_subcat_3 [category_id] => frm_subcat_3 [1] => Seasonal Mini Sweets [name] => Seasonal Mini Sweets [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Χριστουγενιάτικα Μίνι Γλυκά [defaultName] => Χριστουγενιάτικα Μίνι Γλυκά [4] => 13 [itemCount] => 13 ) [3] => Array ( [0] => frm_subcat_4 [category_id] => frm_subcat_4 [1] => Easter Cakes [name] => Easter Cakes [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Πασχαλινές Τούρτες [defaultName] => Πασχαλινές Τούρτες [4] => 2 [itemCount] => 2 ) [4] => Array ( [0] => frm_subcat_5 [category_id] => frm_subcat_5 [1] => Valentines Cakes [name] => Valentines Cakes [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Τούρτες Αγ. Βαλεντίνου [defaultName] => Τούρτες Αγ. Βαλεντίνου [4] => 8 [itemCount] => 8 ) )

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_6 [category_id] => frm_subcat_6 [1] => Ice Cream Cakes [name] => Ice Cream Cakes [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] => Ice Cream Cakes Miss Gelo [name] => Ice Cream Cakes 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 Ice Cream Cakes [name] => Mini Ice Cream Cakes [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] => Ice Cream Cones [name] => Ice Cream Cones [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] => Ice Cream Sticks [name] => Ice Cream Sticks [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] => Ice Cream Βulk [name] => Ice Cream Βulk [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Σπιτικό Παγωτό [defaultName] => Σπιτικό Παγωτό [4] => 15 [itemCount] => 15 ) )