vm_cust140 39
\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\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` = 'e426b86b73f6cffa88d453fac781f78d', `Client_IP` = '18.97.9.175', `Client_Proxy` = '', `Client_Browser` = 'Unknown', `Client_Version` = 'Unknown', `Client_System` = 'Unknown', `start_time` = '1746008561', `Last_Action` = '1746008561'
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 ( 'e426b86b73f6cffa88d453fac781f78d', '0', '0', '', '1746008561', '1', '2', '6', '1', 'files/tpl/set1/', '0', 'DB', 'de/termine/intern:20/termin-archiv/eventdbflat-2025-01---turnen-fuer-alle', '18.97.9.175', '', '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 = 71 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_cust140`.vm_1_menu AS MENU, `vm_cms_master`.vm_confunc AS FUNC WHERE menu_rootID = 1 AND menu_funcID = funcID AND menu_url = 'termin-archiv' ORDER BY menuID DESC
9SHOW TABLES LIKE 'vm_1_eventdb'
10SELECT eventdbcatvalueID FROM vm_1_eventdbcatvalue WHERE eventdbcatvalue_url = 'turnen-fuer-alle'
11SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 71 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 <= 133 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 = 20
16SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 20 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 = 101
19SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 101 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 menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos
21SELECT menu_rootID FROM vm_1_menu WHERE menuID = 72
22SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 72 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 = 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
24SELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 3 AND menu_rootID = 1
25SELECT t1.* FROM vm_1_menu AS t1 WHERE t1.menu_lft >= 134 AND t1.menu_rgt <= 135 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft
26SELECT 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
27SELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 4 AND menu_rootID = 1
28SELECT t1.* FROM vm_1_menu AS t1 WHERE t1.menu_lft >= 136 AND t1.menu_rgt <= 151 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft
29SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos
30SELECT menu_rootID FROM vm_1_menu WHERE menuID = 81
31SELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 81 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
32SELECT * FROM vm_1_bannerimg WHERE bannerimgID = 6
33SELECT 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 = 6 ORDER BY bannerimgentry_sort ASC
34SELECT * FROM vm_1_cssfile WHERE cssfile_type > 0 ORDER BY cssfile_name ASC
35SELECT eventdb_date_start AS date_start, eventdb_date_stop AS date_stop FROM vm_1_eventdb LEFT JOIN vm_1_eventdbincat ON (eventdbincat_eventdbID=eventdbID) WHERE eventdbincat_eventdbcatvalueID IN (68,69,70,81,71,76,66,67,72,73,74) ORDER BY date_start ASC LIMIT 0,1
36SELECT eventdb_date_start AS date_start, eventdb_date_stop AS date_stop FROM vm_1_eventdb LEFT JOIN vm_1_eventdbincat ON (eventdbincat_eventdbID=eventdbID) WHERE eventdbincat_eventdbcatvalueID IN (68,69,70,81,71,76,66,67,72,73,74) ORDER BY date_start DESC LIMIT 0,1
37SELECT eventdbcatID AS CATID, eventdbcat_name AS CAT_NAME, eventdbcatvalueID AS ELEMENTID, eventdbcatvalue_name AS ELEMENT_NAME, eventdbcatvalue_url AS ELEMENT_URL, eventdbcatvalue_color AS ELEMENT_COLOR FROM vm_1_eventdbcatvalue LEFT JOIN vm_1_eventdbcat ON (eventdbcatID = eventdbcatvalue_eventdbcatID) WHERE eventdbcatvalueID IN (68,69,70,81,71,76,66,67,72,73,74) ORDER BY eventdbcat_name, eventdbcatvalue_name
38SELECT * FROM vm_1_eventdb LEFT JOIN vm_1_eventdbincat ON (eventdbincat_eventdbID=eventdbID) WHERE eventdbincat_eventdbcatvalueID IN () AND ( ( eventdb_date_start < 1745964000 AND eventdb_date_stop < 1745964000 ) ) GROUP BY eventdbID