clsDB - error 1226: User 'hemmler' has exceeded the 'max_queries_per_hour' resource (current value: 500000)Stack trace:
file line function args
/var/www/customers/hemmler/dp.hemmler.de/cms/framework/ustlib/clsDB.inc.php 480 get_stacktrace array ( )
/var/www/customers/hemmler/dp.hemmler.de/cms/inc/cms_utils.inc.php 901 query clsDB [object] -> array ( 0 => 'select ID, case when PAGE_LINK_IN_MENU = \'Y\' then \'Y\' else \'N\' end as PAGE_LINK_IN_MENU, case when IS_VALID = \'Y\' then \'Y\' else \'N\' end as IS_VALID, case when VALID_FROM is null or VALID_FROM <= now() then \'OK\' else \'N\' end as VALID_FROM, case when VALID_UNTIL is null or now() <= VALID_UNTIL then \'OK\' else \'N\' end as VALID_UNTIL from CMS_PAGE where FILENAME = \'sortiment\'', )
/var/www/customers/hemmler/dp.hemmler.de/cms/inc/cms_utils.inc.php 925 cmsInternalPrepareMenuDef array ( 0 => array ( 'sortiment-22164' => array ( 'key' => 'sortiment-22164', 'title' => 'Haustüren', 'hint' => 'Haustüren', 'url' => 'sortiment.php?id=22164', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-6472' => array ( 'key' => 'sortiment-6472', 'title' => 'Fenster', 'hint' => '', 'url' => 'sortiment.php?id=6472', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-6489' => array ( 'key' => 'sortiment-6489', 'title' => 'Sonnenschutz', 'hint' => '', 'url' => 'sortiment.php?id=6489', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-16624' => array ( 'key' => 'sortiment-16624', 'title' => 'Lamellendächer', 'hint' => '', 'url' => 'sortiment.php?id=16624', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-14266' => array ( 'key' => 'sortiment-14266', 'title' => 'Terrassendächer', 'hint' => '', 'url' => 'sortiment.php?id=14266', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-7034' => array ( 'key' => 'sortiment-7034', 'title' => 'Rollläden', 'hint' => '', 'url' => 'sortiment.php?id=7034', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-15545' => array ( 'key' => 'sortiment-15545', 'title' => 'Raffstoren', 'hint' => '', 'url' => 'sortiment.php?id=15545', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-16378' => array ( 'key' => 'sortiment-16378', 'title' => 'Klappläden- / Fensterläden aus Aluminium', 'hint' => 'Klappläden- / Fensterläden aus Aluminium', 'url' => 'sortiment.php?id=16378', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-14412' => array ( 'key' => 'sortiment-14412', 'title' => 'Insektenschutz', 'hint' => '', 'url' => 'sortiment.php?id=14412', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-14004' => array ( 'key' => 'sortiment-14004', 'title' => 'Motorisierung und Smarthome', 'hint' => '', 'url' => 'sortiment.php?id=14004', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-16727' => array ( 'key' => 'sortiment-16727', 'title' => 'Abverkauf / Restposten / Angebote', 'hint' => 'Abverkauf / Restposten / Angebote', 'url' => 'sortiment.php?id=16727', 'useSession' => true, 'login' => false, 'logout' => false, ), ), )
/var/www/customers/hemmler/dp.hemmler.de/index.php 108 cmsInternalPrepareMenuDef array ( 0 => array ( 'MENU_ENTRY_7' => array ( 'key' => 'MENU_ENTRY_7', 'id' => 'menu_item_7', 'title' => 'Aktionen', 'title_tag' => 'Aktionen @Liste_Oberzentren', 'url' => 'news-aktionen.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'liclass' => 'level-0-red', 'submenu' => array ( 'MENU_ENTRY_94' => array ( 'key' => 'MENU_ENTRY_94', 'id' => 'menu_item_94', 'title' => 'Haustür-Aktion mit WERU-Haustür', 'title_tag' => 'Haustür-Aktion mit WERU-Haustür @Liste_Oberzentren', 'url' => 'lp-haustueren-atris-aktion.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_95' => array ( 'key' => 'MENU_ENTRY_95', 'id' => 'menu_item_95', 'title' => 'Neuer Haustüren-Konfigurator von WERU', 'title_tag' => 'Neuer Haustüren-Konfigurator von WERU @Liste_Oberzentren', 'url' => 'redaktion-weru-haustueren-konfigurator.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_20' => array ( 'key' => 'MENU_ENTRY_20', 'id' => 'menu_item_20', 'title' => 'Termine', 'title_tag' => '', 'url' => 'news-termine.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_70' => array ( 'key' => 'MENU_ENTRY_70', 'id' => 'menu_item_70', 'title' => 'News', 'title_tag' => 'Neuigkeiten von Hemmler', 'url' => 'news-news.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_96' => array ( 'key' => 'MENU_ENTRY_96', 'id' => 'menu_item_96', 'title' => 'Unsere Partner', 'title_tag' => 'Unsere Partner für Outdoor-Living, Bau- und Sanierungs-Vorhaben', 'url' => 'redaktion-partner-netzwerk.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), ), ), 'MENU_ENTRY_83' => array ( 'key' => 'MENU_ENTRY_83', 'id' => 'menu_item_83', 'title' => 'Referenzen', 'title_tag' => 'Beschattungs-Lösungen für Fenster und Terrassen privater und gewerblicher Gebäude @Liste_Oberzentren', 'url' => 'referenzen_lamellendach.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'submenu' => array ( 'MENU_ENTRY_85' => array ( 'key' => 'MENU_ENTRY_85', 'id' => 'menu_item_85', 'title' => 'Rollladen, Raffstoren, Textilscreens', 'title_tag' => 'Rollladen, Raffstoren, Textilscreen-Lösungen für @Liste_Oberzentren_TOP', 'url' => 'referenzen_rollladen-raffstoren-textilscreens.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_101' => array ( 'key' => 'MENU_ENTRY_101', 'id' => 'menu_item_101', 'title' => 'Indoor meets Outdoor', 'title_tag' => 'Bauelemente und Lösungen für die Gestaltung von Innen- und Außen-Räumen', 'url' => 'referenzen_outdoor-living-indoor-living.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), ), ), 'MENU_ENTRY_1' => array ( 'key' => 'MENU_ENTRY_1', 'id' => 'menu_item_1', 'title' => 'Sortiment', 'title_tag' => 'Sortiment @Liste_Oberzentren', 'url' => 'sortiment.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'submenu' => array ( 'sortiment-22164' => array ( 'key' => 'sortiment-22164', 'title' => 'Haustüren', 'hint' => 'Haustüren', 'url' => 'sortiment.php?id=22164', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-6472' => array ( 'key' => 'sortiment-6472', 'title' => 'Fenster', 'hint' => '', 'url' => 'sortiment.php?id=6472', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-6489' => array ( 'key' => 'sortiment-6489', 'title' => 'Sonnenschutz', 'hint' => '', 'url' => 'sortiment.php?id=6489', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-16624' => array ( 'key' => 'sortiment-16624', 'title' => 'Lamellendächer', 'hint' => '', 'url' => 'sortiment.php?id=16624', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-14266' => array ( 'key' => 'sortiment-14266', 'title' => 'Terrassendächer', 'hint' => '', 'url' => 'sortiment.php?id=14266', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-7034' => array ( 'key' => 'sortiment-7034', 'title' => 'Rollläden', 'hint' => '', 'url' => 'sortiment.php?id=7034', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-15545' => array ( 'key' => 'sortiment-15545', 'title' => 'Raffstoren', 'hint' => '', 'url' => 'sortiment.php?id=15545', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-16378' => array ( 'key' => 'sortiment-16378', 'title' => 'Klappläden- / Fensterläden aus Aluminium', 'hint' => 'Klappläden- / Fensterläden aus Aluminium', 'url' => 'sortiment.php?id=16378', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-14412' => array ( 'key' => 'sortiment-14412', 'title' => 'Insektenschutz', 'hint' => '', 'url' => 'sortiment.php?id=14412', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-14004' => array ( 'key' => 'sortiment-14004', 'title' => 'Motorisierung und Smarthome', 'hint' => '', 'url' => 'sortiment.php?id=14004', 'useSession' => true, 'login' => false, 'logout' => false, ), 'sortiment-16727' => array ( 'key' => 'sortiment-16727', 'title' => 'Abverkauf / Restposten / Angebote', 'hint' => 'Abverkauf / Restposten / Angebote', 'url' => 'sortiment.php?id=16727', 'useSession' => true, 'login' => false, 'logout' => false, ), ), ), 'MENU_ENTRY_39' => array ( 'key' => 'MENU_ENTRY_39', 'id' => 'menu_item_39', 'title' => 'Lamellendach', 'title_tag' => 'Lamellendach als Terrassenüberdachung / Pergola @Liste_Oberzentren', 'url' => 'lp-lamellendach-lp-start.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'submenu' => array ( ), ), 'MENU_ENTRY_60' => array ( 'key' => 'MENU_ENTRY_60', 'id' => 'menu_item_60', 'title' => 'Fachthemen', 'title_tag' => 'Fachthemen rund um Fenster, Haustüren, Rollläden, Sonnenschutz, Insektenschutz, Klappläden', 'url' => '', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'submenu' => array ( 'MENU_ENTRY_81' => array ( 'key' => 'MENU_ENTRY_81', 'id' => 'menu_item_81', 'title' => 'Rahmenloses revo-Fenster', 'title_tag' => 'Rahmenloses revo®-Fenster für mehr Lichteinfall, Sicherheit, Wärmedämmung und Schallschutz', 'url' => 'redaktion-revo-fenster.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_111' => array ( 'key' => 'MENU_ENTRY_111', 'id' => 'menu_item_111', 'title' => '3D Konfigurator Terrassenüberdachung von Brustor', 'title_tag' => '3D Konfigurator Terrassenüberdachung von Brustor', 'url' => 'redaktion-3D-lamellendach-brustor.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_79' => array ( 'key' => 'MENU_ENTRY_79', 'id' => 'menu_item_79', 'title' => 'Sonnenschutz mit Markisen, Sonnenschirmen, Terrassendächern', 'title_tag' => 'Sonnenschutz mit Markisen, Sonnenschirmen, Terrassendächern @Liste_Oberzentren_Top', 'url' => 'redaktion-sonnenschutz-201802.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_76' => array ( 'key' => 'MENU_ENTRY_76', 'id' => 'menu_item_76', 'title' => 'Einbruchhemmende und förderfähige Bauelemente', 'title_tag' => 'Einbruchhemmende und förderfähige Bauelemente', 'url' => 'redaktion-sichere-foerderfaehige-bauelemente.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_61' => array ( 'key' => 'MENU_ENTRY_61', 'id' => 'menu_item_61', 'title' => 'Insektenschutz für Fenster, Balkon- und Terrassentüren', 'title_tag' => 'Neher-Insektenschutzgitter für Fenster, Balkon- und Terrassentüren für fast jede Anforderung', 'url' => 'redaktion-insektenschutz-2016.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_63' => array ( 'key' => 'MENU_ENTRY_63', 'id' => 'menu_item_63', 'title' => 'Anzahl Wohnungseinbrüche steigt 2015 um 9,9%', 'title_tag' => 'Die Anzahl der Wohnungseinbrüche ist 2015 erneut gestiegen und zwar um 9,9%', 'url' => 'redaktion-einbruchhemmung-wohnungseinbrueche-steigt-2015.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_64' => array ( 'key' => 'MENU_ENTRY_64', 'id' => 'menu_item_64', 'title' => 'Terrassentüren, Fenster, Rollläden, Haustüren RC1- und RC2-zertifiziert', 'title_tag' => 'Terrassentüren, Fenster, Rollläden, Haustüren RC1- und RC2-zertifiziert', 'url' => 'redaktion-einbruchhemmung-rc1-rc2-zertifizierung.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_66' => array ( 'key' => 'MENU_ENTRY_66', 'id' => 'menu_item_66', 'title' => 'Tipps & Tricks', 'title_tag' => 'Tipps & Tricks für Fenster, Haustüren, Rollläden, Sonnenschutz und Insektenschutz', 'url' => 'tipps-und-tricks.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'submenu' => array ( 'tipps-und-tricks-14487' => array ( 'key' => 'tipps-und-tricks-14487', 'title' => 'Insektenschutz & Fliegengitter', 'hint' => '', 'url' => 'tipps-und-tricks.php?id=14487', 'useSession' => true, 'login' => false, 'logout' => false, ), 'tipps-und-tricks-16506' => array ( 'key' => 'tipps-und-tricks-16506', 'title' => 'Förderungen', 'hint' => '', 'url' => 'tipps-und-tricks.php?id=16506', 'useSession' => true, 'login' => false, 'logout' => false, ), 'tipps-und-tricks-21066' => array ( 'key' => 'tipps-und-tricks-21066', 'title' => 'Hygiene', 'hint' => '', 'url' => 'tipps-und-tricks.php?id=21066', 'useSession' => true, 'login' => false, 'logout' => false, ), ), ), 'MENU_ENTRY_78' => array ( 'key' => 'MENU_ENTRY_78', 'id' => 'menu_item_78', 'title' => 'Klappläden / Fensterläden aus Aluminium', 'title_tag' => 'Klappläden / Fensterläden aus Aluminium - Sonderformen', 'url' => 'redaktion-klappladen-2017-2018.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), ), ), 'MENU_ENTRY_47' => array ( 'key' => 'MENU_ENTRY_47', 'id' => 'menu_item_47', 'title' => 'Showroom', 'title_tag' => 'Showroom für Fenster, Haustüren, Rolladen und Sonnenschutz', 'url' => 'permanente-weru-fenster-haustueren-ausstellung.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'submenu' => array ( 'MENU_ENTRY_54' => array ( 'key' => 'MENU_ENTRY_54', 'id' => 'menu_item_54', 'title' => 'Permanente WERU Fenster- & Haustüren-Ausstellung', 'title_tag' => 'Permanente WERU Fenster- und Haustüren-Ausstellung', 'url' => 'permanente-weru-fenster-haustueren-ausstellung.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_55' => array ( 'key' => 'MENU_ENTRY_55', 'id' => 'menu_item_55', 'title' => 'Somfy SmartHome-Ausstellung', 'title_tag' => 'Somfy SmartHome-Ausstellung', 'url' => 'somfy-smart-home-ausstellung.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_86' => array ( 'key' => 'MENU_ENTRY_86', 'id' => 'menu_item_86', 'title' => 'Magazin für Bauherren und Architekten', 'title_tag' => 'Magazin für Bauherren und Architekten @Liste_Oberzentren', 'url' => 'redaktion-magazin-licht-und-leben.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), ), ), 'MENU_ENTRY_2' => array ( 'key' => 'MENU_ENTRY_2', 'id' => 'menu_item_2', 'title' => 'Über uns', 'title_tag' => '', 'url' => 'unternehmen-philosophie.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'submenu' => array ( 'MENU_ENTRY_84' => array ( 'key' => 'MENU_ENTRY_84', 'id' => 'menu_item_84', 'title' => 'Referenzen', 'title_tag' => 'Referenzen für Haustüren, Fenster, Rollladen, Sonnenschutz @Liste_Oberzentren', 'url' => 'referenzen.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'submenu' => array ( 'referenzen-16854' => array ( 'key' => 'referenzen-16854', 'title' => 'Haustüren', 'hint' => '', 'url' => 'referenzen.php?id=16854', 'useSession' => true, 'login' => false, 'logout' => false, ), 'referenzen-16855' => array ( 'key' => 'referenzen-16855', 'title' => 'Fenster', 'hint' => '', 'url' => 'referenzen.php?id=16855', 'useSession' => true, 'login' => false, 'logout' => false, ), 'referenzen-16857' => array ( 'key' => 'referenzen-16857', 'title' => 'Innentüren / Ganzglas-Elemente', 'hint' => '', 'url' => 'referenzen.php?id=16857', 'useSession' => true, 'login' => false, 'logout' => false, ), 'referenzen-16856' => array ( 'key' => 'referenzen-16856', 'title' => 'Lamellendächer / Pergolas / Sonnenschutz', 'hint' => '', 'url' => 'referenzen.php?id=16856', 'useSession' => true, 'login' => false, 'logout' => false, ), 'referenzen-16867' => array ( 'key' => 'referenzen-16867', 'title' => 'Rollläden / Raffstoren', 'hint' => '', 'url' => 'referenzen.php?id=16867', 'useSession' => true, 'login' => false, 'logout' => false, ), ), ), 'MENU_ENTRY_16' => array ( 'key' => 'MENU_ENTRY_16', 'id' => 'menu_item_16', 'title' => 'Historie', 'title_tag' => '', 'url' => 'unternehmen-historie.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_12' => array ( 'key' => 'MENU_ENTRY_12', 'id' => 'menu_item_12', 'title' => 'Philosophie', 'title_tag' => '', 'url' => 'unternehmen-philosophie.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_44' => array ( 'key' => 'MENU_ENTRY_44', 'id' => 'menu_item_44', 'title' => 'Jobs bei Hemmler in Schutterwald', 'title_tag' => 'Jobs bei Hemmler in Schutterwald / Ortenau / Baden-Württemberg', 'url' => 'jobs-bei-hemmler-schutterwald.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'submenu' => array ( 'MENU_ENTRY_75' => array ( 'key' => 'MENU_ENTRY_75', 'id' => 'menu_item_75', 'title' => 'Komplett-Abwickler m/w', 'title_tag' => 'Schreiner/-meister / Holztechniker als Komplettabwickler / technischer Kundenberater (m/w)', 'url' => 'job-komplettabwickler.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_74' => array ( 'key' => 'MENU_ENTRY_74', 'id' => 'menu_item_74', 'title' => 'Montageplaner Rollladen und Sonnenschutz m/w', 'title_tag' => 'Montage-Koordinator Rollladen und Sonnenschutz m/w', 'url' => 'job-montageplaner-rollladen-und-sonnenschutz-mw.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_49' => array ( 'key' => 'MENU_ENTRY_49', 'id' => 'menu_item_49', 'title' => 'Disponent Rollladen & Sonnenschutz (m/w)', 'title_tag' => 'Wir suchen einen Disponent Rollladen und Sonnenschutz (m/w)', 'url' => 'job-disponent-rollladen-und-sonnenschutz-mw.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_45' => array ( 'key' => 'MENU_ENTRY_45', 'id' => 'menu_item_45', 'title' => 'Kundendienst-Monteur Rollladen & Sonnenschutz (m/w/d)', 'title_tag' => '', 'url' => 'job-kundendienst-monteur-rollladen-und-sonnenschutz-mw.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_48' => array ( 'key' => 'MENU_ENTRY_48', 'id' => 'menu_item_48', 'title' => 'Auszubildende(r) Rollladen & Sonnenschutzmechatroniker (m/w)', 'title_tag' => 'Wir suchen für 09/2017 eine(n) Auszubildende(r) Rollladen & Sonnenschutzmechatroniker (m/w)', 'url' => 'job-auszubildender-rollladen-und-sonnenschutzmechatroniker-mw.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_107' => array ( 'key' => 'MENU_ENTRY_107', 'id' => 'menu_item_107', 'title' => 'Technischer Verkäufer (m/w/d)', 'title_tag' => 'Technischer Verkäufer (m/w/d) für Schutterwald', 'url' => 'jobs-technischer-verkaeufer.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), ), ), 'MENU_ENTRY_80' => array ( 'key' => 'MENU_ENTRY_80', 'id' => 'menu_item_80', 'title' => 'Hemmler-Akademie', 'title_tag' => 'Hemmler-Akademie für Fort- und Weiterbildung', 'url' => 'job-hemmler-akademie.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_50' => array ( 'key' => 'MENU_ENTRY_50', 'id' => 'menu_item_50', 'title' => 'Meisterhafte Handwerksarbeit', 'title_tag' => 'Meisterhafte Handwerksarbeit für Ihre Fenster, Haustüren, Rollläden und Sonnenschutz', 'url' => 'redaktion-meisterhafte-handwerksarbeit.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_14' => array ( 'key' => 'MENU_ENTRY_14', 'id' => 'menu_item_14', 'title' => 'Standorte', 'title_tag' => '', 'url' => 'unternehmen-standorte.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_15' => array ( 'key' => 'MENU_ENTRY_15', 'id' => 'menu_item_15', 'title' => 'Vertriebspartner', 'title_tag' => '', 'url' => 'unternehmen-vertriebspartner.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_51' => array ( 'key' => 'MENU_ENTRY_51', 'id' => 'menu_item_51', 'title' => 'Umwelt', 'title_tag' => '', 'url' => 'unternehmen-umwelt.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_17' => array ( 'key' => 'MENU_ENTRY_17', 'id' => 'menu_item_17', 'title' => 'Montageteam', 'title_tag' => '', 'url' => 'unternehmen-montageteam.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), ), ), 'MENU_ENTRY_5' => array ( 'key' => 'MENU_ENTRY_5', 'id' => 'menu_item_5', 'title' => 'Kontakt', 'title_tag' => '', 'url' => 'formular-normale-anfrage.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, 'submenu' => array ( 'MENU_ENTRY_87' => array ( 'key' => 'MENU_ENTRY_87', 'id' => 'menu_item_87', 'title' => 'Rollladen-Reparatur anfragen', 'title_tag' => 'Rollladen-Reparatur anfragen', 'url' => 'formular-reparatur-rollladen.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_88' => array ( 'key' => 'MENU_ENTRY_88', 'id' => 'menu_item_88', 'title' => 'Markisen-Reparatur anfragen', 'title_tag' => 'Markisen-Reparatur online anfragen', 'url' => 'formular-reparatur-markisen.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_89' => array ( 'key' => 'MENU_ENTRY_89', 'id' => 'menu_item_89', 'title' => 'Fenster-Reparatur anfragen', 'title_tag' => 'Fenster-Reparatur online anfragen', 'url' => 'formular-reparatur-fenster.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_22' => array ( 'key' => 'MENU_ENTRY_22', 'id' => 'menu_item_22', 'title' => 'Anfahrt', 'title_tag' => '', 'url' => 'kontakt-anfahrt.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_23' => array ( 'key' => 'MENU_ENTRY_23', 'id' => 'menu_item_23', 'title' => 'Ansprechpartner', 'title_tag' => 'Ihre Ansprechpartner bei Hemmler in Schutterwald', 'url' => 'kontakt-ansprechpartner.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_24' => array ( 'key' => 'MENU_ENTRY_24', 'id' => 'menu_item_24', 'title' => 'Impressum', 'title_tag' => '', 'url' => 'impressum.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_29' => array ( 'key' => 'MENU_ENTRY_29', 'id' => 'menu_item_29', 'title' => 'Datenschutz', 'title_tag' => '', 'url' => 'datenschutz.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_109' => array ( 'key' => 'MENU_ENTRY_109', 'id' => 'menu_item_109', 'title' => 'Datenschutzerklärung Facebook', 'title_tag' => 'Datenschutzerklärung Facebook', 'url' => 'datenschutz_fb.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), 'MENU_ENTRY_110' => array ( 'key' => 'MENU_ENTRY_110', 'id' => 'menu_item_110', 'title' => 'Datenschutzerklärung Instagram', 'title_tag' => '', 'url' => 'Datenschutz_insta.php', 'target' => '', 'useSession' => true, 'onClick' => '', 'image' => '', 'image_open' => '', 'sub_vertical' => true, 'login' => false, 'logout' => false, ), ), ), ), )


Dump of SQL statement:
select ID,
                       case when PAGE_LINK_IN_MENU = 'Y' then 'Y'
                            else 'N'
                       end as PAGE_LINK_IN_MENU,
                       case when IS_VALID = 'Y' then 'Y'
                            else 'N'
                       end as IS_VALID,
                       case when VALID_FROM is null or VALID_FROM <= now() then 'OK'
                            else 'N'
                       end as VALID_FROM,
                       case when VALID_UNTIL is null or now() <= VALID_UNTIL then 'OK'
                            else 'N'
                       end as VALID_UNTIL
                from CMS_PAGE
                where FILENAME = 'sortiment'