vm_cust75
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` = 'b09fc89744e1fbb298873a459bf72d61', `Client_IP` = '44.222.134.250', `Client_Proxy` = '', `Client_Browser` = 'Unknown', `Client_Version` = 'Unknown', `Client_System` = 'Unknown', `start_time` = '1727987634', `Last_Action` = '1727987634' | \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 = 1 | \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 ( 'b09fc89744e1fbb298873a459bf72d61', '0', '0', '', '1727987634', '1', '1', '1', '1', 'files/tpl/set1/', '0', 'DB', 'de/interne-infos/platzeinteilung-kalender/datecal-2024-09---clubraumterrassekueche', '44.222.134.250', '', '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 = 274 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_cust75`.vm_1_menu AS MENU, `vm_cms_master`.vm_confunc AS FUNC WHERE menu_rootID = 1 AND menu_funcID = funcID AND menu_url = 'platzeinteilung-kalender' 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 = 'clubraumterrassekueche' GROUP BY datecatvalue_datecatID | \n
10 | \nSELECT datecatvalueID AS ELEMENTID, datecatvalue_name AS ELEMENT_NAME FROM vm_1_datecatvalue WHERE datecatvalue_url = 'clubraumterrassekueche' | \n
11 | \nSELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 274 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 <= 117 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 = 8 | \n
16 | \nSELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 8 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 menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos | \n
18 | \nSELECT menu_rootID FROM vm_1_menu WHERE menuID = 266 | \n
19 | \nSELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 266 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
20 | \nSELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 3 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
21 | \nSELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 3 AND menu_rootID = 1 | \n
22 | \nSELECT t1.* FROM vm_1_menu AS t1 WHERE t1.menu_lft >= 118 AND t1.menu_rgt <= 257 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft | \n
23 | \nSELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 4 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 = 4 AND menu_rootID = 1 | \n
25 | \nSELECT t1.* FROM vm_1_menu AS t1 WHERE t1.menu_lft >= 258 AND t1.menu_rgt <= 271 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft | \n
26 | \nSELECT * FROM vm_1_bannerimg WHERE bannerimgID = 2 | \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 = 2 ORDER BY RAND() | \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 (55,57,61,51,64,62,58,59,60,53) 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 >= 1725141599 AND ( (date_date_stop <= 1727733600 AND date_date_stop > 0 ) OR ( date_date_start < 1727733600 AND date_date_stop = 0 ) ) ) OR ( date_date_start <= 1725141599 AND date_date_stop >= 1727733600 ) OR ( date_date_start <= 1725141599 AND date_date_stop <= 1727733600 AND date_date_stop > 1725141599 ) OR ( date_date_start >= 1725141599 AND date_date_stop >= 1727733600 AND date_date_start < 1727733600 ) ) ORDER BY date_date_start, dateID | \n