0 | SET SESSION sql_mode='' |
1 | SELECT * FROM vm_1_sys
WHERE sys_script_group = ''
|
2 | INSERT INTO vm_1_visitors
SET `UserHash` = '17e1fe30d206914847990bae67148fa1', `Client_IP` = '3.144.92.57', `Client_Proxy` = '', `Client_Browser` = 'Netscape', `Client_Version` = 'Unknown', `Client_System` = 'Unknown', `start_time` = '1736566137', `Last_Action` = '1736566137' |
3 | SELECT style.*, tplpack.tplpack_folder FROM vm_1_style AS style
LEFT JOIN vm_1_tplpack AS tplpack
ON (style_tplpackID = tplpackID)
WHERE styleID = 1 |
4 | SELECT * FROM vm_1_customer
WHERE custID = 1 |
5 | REPLACE 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 ( '17e1fe30d206914847990bae67148fa1', '0', '0', '', '1736566137', '1', '1', '1', '1', 'files/tpl/set1/', '0', 'DB', 'de/intern:863/halle-2018', '3.144.92.57', '', 'Netscape', 'Unknown', 'Unknown', '0', '0') |
6 | SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting
WHERE menuset_langID = 1
ORDER BY menuset_pos |
7 | SELECT t2.*
FROM vm_1_menu t1, vm_1_menu t2
WHERE
t1.menuID = 614 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 |
8 | SELECT t2.*
FROM vm_1_menu t1, vm_1_menu t2
WHERE
t1.menuID = 614 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 |
9 | SELECT t1.*
FROM vm_1_menu AS t1,
vm_1_menu AS t2
WHERE
t1.menu_lft BETWEEN t2.menu_lft AND t2.menu_rgt
AND
t1.menu_rootID = t2.menu_rootID
AND t1.menu_rootID = 1
GROUP BY t1.menuID
HAVING
(
t1.menu_lft > 1
AND t1.menu_rgt < 1248 AND t1.menu_lvl = 0 + 1 )OR (
t1.menu_lft > 2
AND t1.menu_rgt < 1209 AND t1.menu_lvl = 1 + 1 )OR (
t1.menu_lft > 165
AND t1.menu_rgt < 218 AND t1.menu_lvl >= 2 + 1 )OR (
t1.menu_lft > 188
AND t1.menu_rgt < 189 AND t1.menu_lvl >= 3 + 1 )
ORDER BY t1.menu_lft |
10 | SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting
ORDER BY menuset_pos |
11 | SELECT menu_rootID FROM vm_1_menu
WHERE menuID = 819 |
12 | SELECT t2.*
FROM vm_1_menu t1, vm_1_menu t2
WHERE
t1.menuID = 819 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 |
13 | SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting
ORDER BY menuset_pos |
14 | SELECT menu_rootID FROM vm_1_menu
WHERE menuID = 859 |
15 | SELECT t2.*
FROM vm_1_menu t1, vm_1_menu t2
WHERE
t1.menuID = 859 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 |
16 | SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting
ORDER BY menuset_pos |
17 | SELECT menu_rootID FROM vm_1_menu
WHERE menuID = 136 |
18 | SELECT t2.*
FROM vm_1_menu t1, vm_1_menu t2
WHERE
t1.menuID = 136 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 |
19 | SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting
ORDER BY menuset_pos |
20 | SELECT menu_rootID FROM vm_1_menu
WHERE menuID = 863 |
21 | SELECT t2.*
FROM vm_1_menu t1, vm_1_menu t2
WHERE
t1.menuID = 863 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 |
22 | SELECT 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 |
23 | SELECT t1.*
FROM vm_1_menu AS t1,
vm_1_menu AS t2
WHERE
t1.menu_lft BETWEEN t2.menu_lft AND t2.menu_rgt
AND
t1.menu_rootID = t2.menu_rootID
AND t1.menu_rootID = 1
GROUP BY t1.menuID
HAVING
(
t1.menu_lft > 1
AND t1.menu_rgt < 1248 AND t1.menu_lvl = 0 + 1 )OR (
t1.menu_lft > 1210
AND t1.menu_rgt < 1229 AND t1.menu_lvl = 1 + 1 )
ORDER BY t1.menu_lft |
24 | SELECT 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 |
25 | SELECT menu_lft AS LFT,
menu_rgt AS RGT,
menu_lvl AS LVL
FROM vm_1_menu
WHERE menuID = 4 AND
menu_rootID = 1 |
26 | SELECT t1.*
FROM vm_1_menu AS t1
WHERE
t1.menu_lft >= 1230 AND
t1.menu_rgt <= 1247 AND
t1.menu_rootID = 1
ORDER BY t1.menu_lft |
27 | SELECT * FROM vm_1_cssfile
WHERE cssfile_type > 0
ORDER BY cssfile_name ASC |
28 | SELECT CEILING(COUNT(docfolderID) /100) AS PAGES,
COUNT(docfolderID) AS MAX_DISPLAY FROM vm_1_docfolder
WHERE docfolderID IN (230) |
29 | SELECT docfolderID AS galleryID,
docfolder_gallerytitle AS HEADER,
docfolder_gallerytitle_url AS HEADER_URL,
docfolder_galleryteaser AS TEASER,
docfolder_gallerywidth AS gallery_width,
docfolder_galleryheight AS gallery_height,
docfolder_gallerypage AS gallery_page,
docfolder_gallerypicID AS gallery_picID
FROM vm_1_docfolder
WHERE docfolderID IN (230)
ORDER BY docfolder_lft
LIMIT 0, 100 |
30 | SELECT docfolderID AS galleryID,
docfolder_gallerytitle AS HEADER,
docfolder_gallerytitle_url AS HEADER_URL,
docfolder_galleryteaser AS TEASER,
docfolder_gallerywidth AS gallery_width,
docfolder_galleryheight AS gallery_height,
docfolder_gallerypage AS gallery_page,
docfolder_gallerypicID AS gallery_picID
FROM vm_1_docfolder
WHERE docfolderID = 230 |
31 | SELECT count(docfolder_gallerytitle_url) AS COUNTER
FROM vm_1_docfolder
WHERE docfolder_gallerytitle_url = '' AND
docfolderID != |