vm_cust85
29<br><table><tr>\n
                            <td>0</td>\n
                            <td>SET SESSION sql_mode=''</td>\n
                          </tr>\n<tr>\n
                            <td>1</td>\n
                            <td>SELECT * FROM vm_1_sys
                WHERE sys_script_group = ''
                      </td>\n
                          </tr>\n<tr>\n
                            <td>2</td>\n
                            <td>SELECT * FROM vm_1_customer
            WHERE custID = 1</td>\n
                          </tr>\n<tr>\n
                            <td>3</td>\n
                            <td>SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting
            WHERE menuset_langID = 1
            ORDER BY menuset_pos</td>\n
                          </tr>\n<tr>\n
                            <td>4</td>\n
                            <td>SELECT 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</td>\n
                          </tr>\n<tr>\n
                            <td>5</td>\n
                            <td>SELECT 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</td>\n
                          </tr>\n<tr>\n
                            <td>6</td>\n
                            <td>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 < 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</td>\n
                          </tr>\n<tr>\n
                            <td>7</td>\n
                            <td>SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting
                ORDER BY menuset_pos</td>\n
                          </tr>\n<tr>\n
                            <td>8</td>\n
                            <td>SELECT menu_rootID FROM vm_1_menu
                WHERE menuID = 819</td>\n
                          </tr>\n<tr>\n
                            <td>9</td>\n
                            <td>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</td>\n
                          </tr>\n<tr>\n
                            <td>10</td>\n
                            <td>SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting
                ORDER BY menuset_pos</td>\n
                          </tr>\n<tr>\n
                            <td>11</td>\n
                            <td>SELECT menu_rootID FROM vm_1_menu
                WHERE menuID = 859</td>\n
                          </tr>\n<tr>\n
                            <td>12</td>\n
                            <td>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</td>\n
                          </tr>\n<tr>\n
                            <td>13</td>\n
                            <td>SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting
                ORDER BY menuset_pos</td>\n
                          </tr>\n<tr>\n
                            <td>14</td>\n
                            <td>SELECT menu_rootID FROM vm_1_menu
                WHERE menuID = 136</td>\n
                          </tr>\n<tr>\n
                            <td>15</td>\n
                            <td>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</td>\n
                          </tr>\n<tr>\n
                            <td>16</td>\n
                            <td>SELECT menuset_menuID, menuset_pos FROM vm_1_menusetting
                ORDER BY menuset_pos</td>\n
                          </tr>\n<tr>\n
                            <td>17</td>\n
                            <td>SELECT menu_rootID FROM vm_1_menu
                WHERE menuID = 863</td>\n
                          </tr>\n<tr>\n
                            <td>18</td>\n
                            <td>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</td>\n
                          </tr>\n<tr>\n
                            <td>19</td>\n
                            <td>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</td>\n
                          </tr>\n<tr>\n
                            <td>20</td>\n
                            <td>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 < 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</td>\n
                          </tr>\n<tr>\n
                            <td>21</td>\n
                            <td>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</td>\n
                          </tr>\n<tr>\n
                            <td>22</td>\n
                            <td>SELECT menu_lft  AS LFT,
                       menu_rgt AS RGT,
                       menu_lvl AS LVL
                    FROM vm_1_menu
                    WHERE menuID     = 4 AND
                          menu_rootID = 1</td>\n
                          </tr>\n<tr>\n
                            <td>23</td>\n
                            <td>SELECT 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</td>\n
                          </tr>\n<tr>\n
                            <td>24</td>\n
                            <td>SELECT * FROM vm_1_cssfile
                WHERE cssfile_type > 0
                ORDER BY cssfile_name ASC</td>\n
                          </tr>\n<tr>\n
                            <td>25</td>\n
                            <td>SELECT 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)</td>\n
                          </tr>\n<tr>\n
                            <td>26</td>\n
                            <td>SELECT 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</td>\n
                          </tr>\n<tr>\n
                            <td>27</td>\n
                            <td>SELECT 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</td>\n
                          </tr>\n<tr>\n
                            <td>28</td>\n
                            <td>SELECT count(picfolder_gallerytitle_url) AS COUNTER
                                    FROM vm_1_picfolder
                                    WHERE picfolder_gallerytitle_url = '' AND
                                          picfolderID != </td>\n
                          </tr>\n</table>