vm_cust251 31
\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n\n \n \n \n
0SET SESSION sql_mode=''
1SELECT * FROM vm_1_sys WHERE sys_script_group = ''
2INSERT INTO vm_1_visitors SET `UserHash` = '4e5be2b9ca005d0998515c9858893057', `Client_IP` = '18.97.9.169', `Client_Proxy` = '', `Client_Browser` = 'Unknown', `Client_Version` = 'Unknown', `Client_System` = 'Unknown', `start_time` = '1733340751', `Last_Action` = '1733340751'
3SELECT style.*, tplpack.tplpack_folder FROM vm_1_style AS style LEFT JOIN vm_1_tplpack AS tplpack ON (style_tplpackID = tplpackID) WHERE styleID = 2
4SELECT * FROM vm_1_customer WHERE custID = 1
5REPLACE INTO vm_1_cookie (`UserHash`,`UserID`,`GuestID`,`User_Name`,`Last_Action`,`LangID`,`StyleID`,`TplpackID`,`SubvarpackID`,`Folder_Tpl`,`Use_Tpl_DB`,`Tpl_DB`,`Last_Url`,`Client_IP`,`Client_Proxy`,`Client_Browser`,`Client_Version`,`Client_System`,`SearchID`,`CssID`) VALUES ( '4e5be2b9ca005d0998515c9858893057', '0', '0', '', '1733340751', '1', '2', '6', '1', 'files/tpl/set1/', '0', 'DB', 'de/aktuelles/termineauschreibungen/datecal-2024-10---allessuche', '18.97.9.169', '', 'Unknown', 'Unknown', 'Unknown', '0', '0')
6SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting WHERE menuset_langID = 1 ORDER BY menuset_pos
7SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 134 AND t1.menu_lft >= t2.menu_lft AND t1.menu_rgt <= t2.menu_rgt AND t1.menu_rootID = t2.menu_rootID ORDER BY t2.menu_lft
8SELECT MENU.*, FUNC.func_url FROM `vm_cust251`.vm_1_menu AS MENU, `vm_cms_master`.vm_confunc AS FUNC WHERE menu_rootID = 1 AND menu_funcID = funcID AND menu_url = 'termineauschreibungen' ORDER BY menuID DESC
9SELECT datecatvalueID AS ELEMENTID, datecatvalue_name AS ELEMENT_NAME, COUNT(dateincat_dateID) AS MAX_ENTRY FROM vm_1_dateincat LEFT JOIN vm_1_datecatvalue ON (datecatvalueID = dateincat_datecatvalueID) WHERE datecatvalue_url = 'allessuche' GROUP BY datecatvalue_datecatID
10SELECT datecatvalueID AS ELEMENTID, datecatvalue_name AS ELEMENT_NAME FROM vm_1_datecatvalue WHERE datecatvalue_url = 'allessuche'
11SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 134 AND t1.menu_lft >= t2.menu_lft AND t1.menu_rgt <= t2.menu_rgt AND t1.menu_rootID = t2.menu_rootID ORDER BY t2.menu_lft
12SELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 2 AND menu_rootID = 1
13SELECT t1.* FROM vm_1_menu AS t1 WHERE t1.menu_lft >= 2 AND t1.menu_rgt <= 151 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft
14SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos
15SELECT menu_rootID FROM vm_1_menu WHERE menuID = 175
16SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 175 AND t1.menu_lft >= t2.menu_lft AND t1.menu_rgt <= t2.menu_rgt AND t1.menu_rootID = t2.menu_rootID ORDER BY t2.menu_lft
17SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 48 AND t1.menu_lft >= t2.menu_lft AND t1.menu_rgt <= t2.menu_rgt AND t1.menu_rootID = t2.menu_rootID ORDER BY t2.menu_lft
18SELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 48 AND menu_rootID = 1
19SELECT t1.* FROM vm_1_menu AS t1 WHERE t1.menu_lft >= 152 AND t1.menu_rgt <= 165 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft
20SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos
21SELECT menu_rootID FROM vm_1_menu WHERE menuID = 142
22SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 142 AND t1.menu_lft >= t2.menu_lft AND t1.menu_rgt <= t2.menu_rgt AND t1.menu_rootID = t2.menu_rootID ORDER BY t2.menu_lft
23SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 49 AND t1.menu_lft >= t2.menu_lft AND t1.menu_rgt <= t2.menu_rgt AND t1.menu_rootID = t2.menu_rootID ORDER BY t2.menu_lft
24SELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 49 AND menu_rootID = 1
25SELECT t1.* FROM vm_1_menu AS t1 WHERE t1.menu_lft >= 166 AND t1.menu_rgt <= 167 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft
26SELECT * FROM vm_1_bannerimg WHERE bannerimgID = 1
27SELECT bannerimgentry.*, pic_ext, pic_title FROM vm_1_bannerimgentry AS bannerimgentry LEFT JOIN vm_1_pic AS mypic ON (picID = bannerimgentry_picID) WHERE bannerimgentry_bannerimgID = 1 ORDER BY bannerimgentry_sort ASC
28SELECT * FROM vm_1_cssfile WHERE cssfile_type > 0 ORDER BY cssfile_name ASC
29SELECT datecatID AS CATID, datecat_name AS CAT_NAME, datecatvalueID AS ELEMENTID, datecatvalue_name AS ELEMENT_NAME, datecatvalue_url AS ELEMENT_URL, datecatvalue_color AS ELEMENT_COLOR FROM vm_1_datecatvalue, vm_1_datecat WHERE datecatID = datecatvalue_datecatID AND datecatvalueID IN (8) ORDER BY datecat_name, datecatvalue_name
30SELECT * FROM vm_1_date LEFT JOIN vm_1_dateincat ON (dateincat_dateID=dateID) WHERE dateincat_datecatvalueID IN () AND ( ( date_date_start >= 1727733599 AND ( (date_date_stop <= 1730415600 AND date_date_stop > 0 ) OR ( date_date_start < 1730415600 AND date_date_stop = 0 ) ) ) OR ( date_date_start <= 1727733599 AND date_date_stop >= 1730415600 ) OR ( date_date_start <= 1727733599 AND date_date_stop <= 1730415600 AND date_date_stop > 1727733599 ) OR ( date_date_start >= 1727733599 AND date_date_stop >= 1730415600 AND date_date_start < 1730415600 ) ) ORDER BY date_date_start, dateID