19 Produkte
  • SÜSSE
      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] => 33 [itemCount] => 33 ) [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] => 38 [itemCount] => 38 ) [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] => 10 [itemCount] => 10 ) [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 ) )
    • Torte
    • Mini Torte
    • Bowl - Portion
    • Toertchen Portion
    • Sirup Sweets
    • Kaffe Desserts
    • Suesse Leckereien
    • Mini Shots
    • Miniatures Suesse
    • Hotel Plate 40x40
  • STEVIA SÜSSE
      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 ) )
    • Torte
    • Toertchen Portion
  • SAISONAL
      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] => Saisonale Kuchen | Christmas Cakes [name] => Saisonale Kuchen | 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] => Saisonale Kuchen | Christmas Sponge Cakes [name] => Saisonale Kuchen | Christmas Sponge 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] => Weihnachts Mini Sweets [name] => Weihnachts 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] => Ostern Torten [name] => Ostern Torten [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] => Saint Valentine Torten [name] => Saint Valentine Torten [2] => frm_entity_9 [entity_id] => frm_entity_9 [3] => Τούρτες Αγ. Βαλεντίνου [defaultName] => Τούρτες Αγ. Βαλεντίνου [4] => 8 [itemCount] => 8 ) )
    • Saisonale Kuchen | Christmas Cakes
    • Saisonale Kuchen | Christmas Sponge Cakes
    • Weihnachts Mini Sweets
    • Ostern Torten
    • Saint Valentine Torten
  • SÜSSE UND HERZHAFTE KÖSTLICHKEITEN
      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 ) )
    • Süße Köstlichkeiten
    • Herzhafte Köstlichkeiten
  • CUPCAKES
      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 = 'CUPCAKES' 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] => 5 [itemCount] => 5 ) )
    • Alle
  • EIS
      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 ) )
    • Eistorten
    • Eistorten Miss Gelo
    • Mini Semifredo Kuchen
    • Mini Eis Rocket-Waffel
    • Mini Eis Stick
    • Eiscreme
  • FEINGEBÄCK
      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