vm_cust75 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` = 'b09fc89744e1fbb298873a459bf72d61', `Client_IP` = '44.222.134.250', `Client_Proxy` = '', `Client_Browser` = 'Unknown', `Client_Version` = 'Unknown', `Client_System` = 'Unknown', `start_time` = '1727987634', `Last_Action` = '1727987634'
3SELECT style.*, tplpack.tplpack_folder FROM vm_1_style AS style LEFT JOIN vm_1_tplpack AS tplpack ON (style_tplpackID = tplpackID) WHERE styleID = 1
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 ( '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')
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 = 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
8SELECT 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
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 = 'clubraumterrassekueche' GROUP BY datecatvalue_datecatID
10SELECT datecatvalueID AS ELEMENTID, datecatvalue_name AS ELEMENT_NAME FROM vm_1_datecatvalue WHERE datecatvalue_url = 'clubraumterrassekueche'
11SELECT 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
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 <= 117 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 = 8
16SELECT 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
17SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos
18SELECT menu_rootID FROM vm_1_menu WHERE menuID = 266
19SELECT 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
20SELECT 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
21SELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 3 AND menu_rootID = 1
22SELECT 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
23SELECT 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
24SELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 4 AND menu_rootID = 1
25SELECT 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
26SELECT * FROM vm_1_bannerimg WHERE bannerimgID = 2
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 = 2 ORDER BY RAND()
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 (55,57,61,51,64,62,58,59,60,53) 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 >= 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