inet_cust174
20
0 | \nSET SESSION sql_mode='' | \n
1 | \nSELECT * FROM inet_1_sys WHERE sys_script_group = '' | \n
2 | \nSELECT * FROM inet_1_customer WHERE custID = 1 | \n
3 | \nSELECT menuset_menuID, menuset_pos FROM inet_1_menusetting WHERE menuset_langID = 1 ORDER BY menuset_pos | \n
4 | \nSELECT t2.* FROM inet_1_menu t1, inet_1_menu t2 WHERE t1.menuID = 37 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
5 | \nSELECT MENU.*, FUNC.func_url FROM `inet_cust174`.inet_1_menu AS MENU, `inet_master`.inet_confunc AS FUNC WHERE menu_rootID = 1 AND menu_funcID = funcID AND menu_url = 'termine' ORDER BY menuID DESC | \n
6 | \nSELECT datecatvalueID AS ELEMENTID, datecatvalue_name AS ELEMENT_NAME, COUNT(dateincat_dateID) AS MAX_ENTRY FROM inet_1_dateincat LEFT JOIN inet_1_datecatvalue ON (datecatvalueID = dateincat_datecatvalueID) WHERE datecatvalue_url = 'supervision-coaching' GROUP BY datecatvalue_datecatID | \n
7 | \nSELECT datecatvalueID AS ELEMENTID, datecatvalue_name AS ELEMENT_NAME FROM inet_1_datecatvalue WHERE datecatvalue_url = 'supervision-coaching' | \n
8 | \nSELECT t2.* FROM inet_1_menu t1, inet_1_menu t2 WHERE t1.menuID = 37 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
9 | \nSELECT t2.* FROM inet_1_menu t1, inet_1_menu t2 WHERE t1.menuID = 2 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
10 | \nSELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM inet_1_menu WHERE menuID = 2 AND menu_rootID = 1 | \n
11 | \nSELECT t1.* FROM inet_1_menu AS t1 WHERE t1.menu_lft >= 2 AND t1.menu_rgt <= 65 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft | \n
12 | \nSELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM inet_1_menu WHERE menuID = 3 AND menu_rootID = 1 | \n
13 | \nSELECT t1.* FROM inet_1_menu AS t1 WHERE t1.menu_lft >= 66 AND t1.menu_rgt <= 91 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft | \n
14 | \nSELECT t2.* FROM inet_1_menu t1, inet_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
15 | \nSELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM inet_1_menu WHERE menuID = 4 AND menu_rootID = 1 | \n
16 | \nSELECT t1.* FROM inet_1_menu AS t1 WHERE t1.menu_lft >= 92 AND t1.menu_rgt <= 99 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft | \n
17 | \nSELECT * FROM inet_1_cssfile WHERE cssfile_type > 0 ORDER BY cssfile_name ASC | \n
18 | \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 inet_1_datecatvalue, inet_1_datecat WHERE datecatID = datecatvalue_datecatID AND datecatvalueID IN (49,30,29,46,48,38,32,44,31,33,34,52,50,14,15,13,45,11,18,17,16,37,35,22,9,19,51,20,21,39,6,42,43,25,5,41,24,23,12,26,28,47,40,27) ORDER BY datecat_name, datecatvalue_name | \n
19 | \nSELECT * FROM inet_1_date LEFT JOIN inet_1_dateincat ON (dateincat_dateID=dateID) WHERE dateincat_datecatvalueID IN () AND ( ( date_date_start >= 1730242800 ) OR ( date_date_start <= 1730242800 AND date_date_stop >= 1730242800 ) ) GROUP BY dateID | \n