\n
| 0 | \n
SET SESSION sql_mode='' | \n
\n\n
| 1 | \n
SELECT * FROM inet_1_sys
WHERE sys_script_group = ''
| \n
\n\n
| 2 | \n
SELECT * FROM inet_1_customer
WHERE custID = 1 | \n
\n\n
| 3 | \n
SELECT menuset_menuID, menuset_pos FROM inet_1_menusetting
WHERE menuset_langID = 1
ORDER BY menuset_pos | \n
\n\n
| 4 | \n
SELECT 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
\n\n
| 5 | \n
SELECT 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
\n\n
| 6 | \n
SELECT 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 = 'bildung-beruf'
GROUP BY datecatvalue_datecatID | \n
\n\n
| 7 | \n
SELECT datecatvalueID AS ELEMENTID,
datecatvalue_name AS ELEMENT_NAME
FROM inet_1_datecatvalue
WHERE datecatvalue_url = 'bildung-beruf' | \n
\n\n
| 8 | \n
SELECT 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
\n\n
| 9 | \n
SELECT 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
\n\n
| 10 | \n
SELECT menu_lft AS LFT,
menu_rgt AS RGT,
menu_lvl AS LVL
FROM inet_1_menu
WHERE menuID = 2 AND
menu_rootID = 1 | \n
\n\n
| 11 | \n
SELECT 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
\n\n
| 12 | \n
SELECT menu_lft AS LFT,
menu_rgt AS RGT,
menu_lvl AS LVL
FROM inet_1_menu
WHERE menuID = 3 AND
menu_rootID = 1 | \n
\n\n
| 13 | \n
SELECT 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
\n\n
| 14 | \n
SELECT 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
\n\n
| 15 | \n
SELECT menu_lft AS LFT,
menu_rgt AS RGT,
menu_lvl AS LVL
FROM inet_1_menu
WHERE menuID = 4 AND
menu_rootID = 1 | \n
\n\n
| 16 | \n
SELECT 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
\n\n
| 17 | \n
SELECT * FROM inet_1_cssfile
WHERE cssfile_type > 0
ORDER BY cssfile_name ASC | \n
\n\n
| 18 | \n
SELECT 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
\n\n
| 19 | \n
SELECT * 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
\n