vm_cust251
31
0 | \nSET SESSION sql_mode='' | \n
1 | \nSELECT * FROM vm_1_sys WHERE sys_script_group = '' | \n
2 | \nINSERT 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' | \n
3 | \nSELECT style.*, tplpack.tplpack_folder FROM vm_1_style AS style LEFT JOIN vm_1_tplpack AS tplpack ON (style_tplpackID = tplpackID) WHERE styleID = 2 | \n
4 | \nSELECT * FROM vm_1_customer WHERE custID = 1 | \n
5 | \nREPLACE 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') | \n
6 | \nSELECT menuset_menuID, menuset_pos FROM vm_1_menusetting WHERE menuset_langID = 1 ORDER BY menuset_pos | \n
7 | \nSELECT 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 | \n
8 | \nSELECT 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 | \n
9 | \nSELECT 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 | \n
10 | \nSELECT datecatvalueID AS ELEMENTID, datecatvalue_name AS ELEMENT_NAME FROM vm_1_datecatvalue WHERE datecatvalue_url = 'allessuche' | \n
11 | \nSELECT 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 | \n
12 | \nSELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 2 AND menu_rootID = 1 | \n
13 | \nSELECT 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 | \n
14 | \nSELECT menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos | \n
15 | \nSELECT menu_rootID FROM vm_1_menu WHERE menuID = 175 | \n
16 | \nSELECT 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 | \n
17 | \nSELECT 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 | \n
18 | \nSELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 48 AND menu_rootID = 1 | \n
19 | \nSELECT 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 | \n
20 | \nSELECT menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos | \n
21 | \nSELECT menu_rootID FROM vm_1_menu WHERE menuID = 142 | \n
22 | \nSELECT 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 | \n
23 | \nSELECT 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 | \n
24 | \nSELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 49 AND menu_rootID = 1 | \n
25 | \nSELECT 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 | \n
26 | \nSELECT * FROM vm_1_bannerimg WHERE bannerimgID = 1 | \n
27 | \nSELECT 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 | \n
28 | \nSELECT * FROM vm_1_cssfile WHERE cssfile_type > 0 ORDER BY cssfile_name ASC | \n
29 | \nSELECT 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 | \n
30 | \nSELECT * 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 | \n