vm_cust85
29
0 | \nSET SESSION sql_mode='' | \n
1 | \nSELECT * FROM vm_1_sys WHERE sys_script_group = '' | \n
2 | \nSELECT * FROM vm_1_customer WHERE custID = 1 | \n
3 | \nSELECT menuset_menuID, menuset_pos FROM vm_1_menusetting WHERE menuset_langID = 1 ORDER BY menuset_pos | \n
4 | \nSELECT t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 160 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 t2.* FROM vm_1_menu t1, vm_1_menu t2 WHERE t1.menuID = 160 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
6 | \nSELECT 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 < 1246 AND t1.menu_lvl = 0 + 1 )OR ( t1.menu_lft > 2 AND t1.menu_rgt < 1207 AND t1.menu_lvl = 1 + 1 )OR ( t1.menu_lft > 237 AND t1.menu_rgt < 826 AND t1.menu_lvl >= 2 + 1 )OR ( t1.menu_lft > 356 AND t1.menu_rgt < 541 AND t1.menu_lvl >= 3 + 1 )OR ( t1.menu_lft > 517 AND t1.menu_rgt < 530 AND t1.menu_lvl >= 4 + 1 )OR ( t1.menu_lft > 518 AND t1.menu_rgt < 519 AND t1.menu_lvl >= 5 + 1 ) ORDER BY t1.menu_lft | \n
7 | \nSELECT menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos | \n
8 | \nSELECT menu_rootID FROM vm_1_menu WHERE menuID = 819 | \n
9 | \nSELECT 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 | \n
10 | \nSELECT menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos | \n
11 | \nSELECT menu_rootID FROM vm_1_menu WHERE menuID = 859 | \n
12 | \nSELECT 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 | \n
13 | \nSELECT menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos | \n
14 | \nSELECT menu_rootID FROM vm_1_menu WHERE menuID = 136 | \n
15 | \nSELECT 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 | \n
16 | \nSELECT menuset_menuID, menuset_pos FROM vm_1_menusetting ORDER BY menuset_pos | \n
17 | \nSELECT menu_rootID FROM vm_1_menu WHERE menuID = 863 | \n
18 | \nSELECT 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 | \n
19 | \nSELECT 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 | \n
20 | \nSELECT 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 < 1246 AND t1.menu_lvl = 0 + 1 )OR ( t1.menu_lft > 1208 AND t1.menu_rgt < 1227 AND t1.menu_lvl = 1 + 1 ) ORDER BY t1.menu_lft | \n
21 | \nSELECT 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 | \n
22 | \nSELECT menu_lft AS LFT, menu_rgt AS RGT, menu_lvl AS LVL FROM vm_1_menu WHERE menuID = 4 AND menu_rootID = 1 | \n
23 | \nSELECT t1.* FROM vm_1_menu AS t1 WHERE t1.menu_lft >= 1228 AND t1.menu_rgt <= 1245 AND t1.menu_rootID = 1 ORDER BY t1.menu_lft | \n
24 | \nSELECT * FROM vm_1_cssfile WHERE cssfile_type > 0 ORDER BY cssfile_name ASC | \n
25 | \nSELECT CEILING(COUNT(picfolderID) /100) AS PAGES, COUNT(picfolderID) AS MAX_DISPLAY FROM vm_1_picfolder WHERE picfolderID IN (60,61,62,63,64,65,66,67,69,70,71) | \n
26 | \nSELECT picfolderID AS galleryID, picfolder_gallerytitle AS HEADER, picfolder_gallerytitle_url AS HEADER_URL, picfolder_galleryteaser AS TEASER, picfolder_gallerywidth AS gallery_width, picfolder_galleryheight AS gallery_height, picfolder_gallerypage AS gallery_page, picfolder_gallerypicID AS gallery_picID FROM vm_1_picfolder WHERE picfolderID IN (60,61,62,63,64,65,66,67,69,70,71) ORDER BY picfolder_lft LIMIT 0, 100 | \n
27 | \nSELECT picfolderID AS galleryID, picfolder_gallerytitle AS HEADER, picfolder_gallerytitle_url AS HEADER_URL, picfolder_galleryteaser AS TEASER, picfolder_gallerywidth AS gallery_width, picfolder_galleryheight AS gallery_height, picfolder_gallerypage AS gallery_page, picfolder_gallerypicID AS gallery_picID FROM vm_1_picfolder WHERE picfolderID = 60 | \n
28 | \nSELECT count(picfolder_gallerytitle_url) AS COUNTER FROM vm_1_picfolder WHERE picfolder_gallerytitle_url = '' AND picfolderID != | \n