•Информация о профиле•

•Использование памяти•

•Зарегистрировано запросов: 529•

1. DELETE
     FROM sh3e_session
     WHERE ( TIME < '1743695179' )
2. SELECT *
     FROM sh3e_session
     WHERE session_id = 'uk1n7o4oq781j8u1d8d3te9tf6'
3. INSERT INTO `sh3e_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'uk1n7o4oq781j8u1d8d3te9tf6','1743702379','','0','1','0' )
4. SELECT *
     FROM sh3e_components
     WHERE parent = 0
5. SELECT folder AS TYPE, element AS name, params
     FROM sh3e_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
6. SELECT `id`,`link`
     FROM sh3e_menu  
     WHERE ((`name` LIKE '%63 signalizatori zagazovannosti.html%')
     AND (`published` > 0))
7. SELECT oldurl, newurl
     FROM sh3e_redirection
     WHERE oldurl = '63-signalizatori-zagazovannosti.html'
     LIMIT 1
8. UPDATE sh3e_redirection
     SET cpt=(cpt+1)
     WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=14&category_id=63&lang=ru&page=shop.browse'
     AND `oldurl` = '63-signalizatori-zagazovannosti.html'
9. SELECT m.*, c.`option` AS component
     FROM sh3e_menu AS m
     LEFT JOIN sh3e_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
10. SELECT template
      FROM sh3e_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 14)
      ORDER BY menuid DESC
      LIMIT 0, 1
11. SELECT VALUE
      FROM sh3e_sef_sm_settings
      WHERE variable='ping_timeout'
12. SELECT group_id,group_name,group_level
      FROM `sh3e_vm_auth_group`
      ORDER BY group_level
13. SELECT sh3e_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `sh3e_vm_shopper_group`
      WHERE sh3e_vm_shopper_group.vendor_id='1'
      AND `default`='1'
14. SELECT `name`
      FROM `sh3e_core_acl_aro_groups`
      WHERE `id` =29
15. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`sh3e_vm_vendor` v, `sh3e_vm_country` c)
                                   
      LEFT JOIN sh3e_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
16. SELECT module_id, module_name
      FROM sh3e_vm_module
      ORDER BY module_name
17. SELECT module_perms
      FROM sh3e_vm_module
      WHERE module_name='shop'
18. SELECT id
      FROM sh3e_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
19. SELECT COUNT(*) AS parentcnt
      FROM sh3e_vm_product
      WHERE product_parent_id>0
20. SELECT COUNT(DISTINCT `sh3e_vm_product`.`product_sku`) AS num_rows
      FROM (`sh3e_vm_product`, `sh3e_vm_category`, `sh3e_vm_product_category_xref`,`sh3e_vm_shopper_group`)
      LEFT JOIN `sh3e_vm_product_price`
      ON `sh3e_vm_product`.`product_id` = `sh3e_vm_product_price`.`product_id`
      WHERE `sh3e_vm_product_category_xref`.`product_id`=`sh3e_vm_product`.`product_id`
     
      AND `sh3e_vm_product_category_xref`.`category_id`=`sh3e_vm_category`.`category_id`
     
      AND `sh3e_vm_product_category_xref`.`category_id`=63
     
      AND ((`sh3e_vm_product`.`product_id`=`sh3e_vm_product_price`.`product_id`
      AND `sh3e_vm_shopper_group`.`shopper_group_id`=`sh3e_vm_product_price`.`shopper_group_id`) OR `sh3e_vm_product_price`.`product_id` IS NULL)
     
      AND `sh3e_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
21. SELECT category_id, category_name, category_thumb_image
      FROM sh3e_vm_category
      WHERE category_id='63'
22. SELECT category_id, category_description
      FROM sh3e_vm_category
      WHERE category_id='63'
23. SELECT category_id, category_thumb_image, category_full_image,category_child_id,category_name
      FROM sh3e_vm_category,sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_parent_id='63'
      AND sh3e_vm_category.category_id=sh3e_vm_category_xref.category_child_id
      AND sh3e_vm_category.vendor_id='1'
      AND sh3e_vm_category.category_publish='Y'
      ORDER BY sh3e_vm_category.list_order, sh3e_vm_category.category_name ASC
24. SELECT category_id, category_name,category_parent_id
      FROM sh3e_vm_category, sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_child_id='63'
      AND sh3e_vm_category.category_id='63'
25. SELECT category_id, category_name,category_parent_id
      FROM sh3e_vm_category, sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_child_id='61'
      AND sh3e_vm_category.category_id='61'
26. SELECT category_id, category_name,category_parent_id
      FROM sh3e_vm_category, sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_child_id='59'
      AND sh3e_vm_category.category_id='59'
27. SELECT id, params
      FROM sh3e_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
28. SELECT DISTINCT `sh3e_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `sh3e_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `sh3e_vm_product`.`mdate`, `sh3e_vm_product`.`cdate`
      FROM (`sh3e_vm_product`, `sh3e_vm_category`, `sh3e_vm_product_category_xref`,`sh3e_vm_shopper_group`)
      LEFT JOIN `sh3e_vm_product_price`
      ON `sh3e_vm_product`.`product_id` = `sh3e_vm_product_price`.`product_id`
      WHERE `sh3e_vm_product_category_xref`.`product_id`=`sh3e_vm_product`.`product_id`
     
      AND `sh3e_vm_product_category_xref`.`category_id`=`sh3e_vm_category`.`category_id`
     
      AND `sh3e_vm_product_category_xref`.`category_id`=63
     
      AND ((`sh3e_vm_product`.`product_id`=`sh3e_vm_product_price`.`product_id`
      AND `sh3e_vm_shopper_group`.`shopper_group_id`=`sh3e_vm_product_price`.`shopper_group_id`) OR `sh3e_vm_product_price`.`product_id` IS NULL)
     
      AND `sh3e_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `sh3e_vm_product`.`product_sku`
     
      ORDER BY `sh3e_vm_product_category_xref`.`product_list` ASC
      LIMIT 0, 10
29. SELECT vendor_id
      FROM sh3e_vm_product
      WHERE product_id='206'
30. SELECT shopper_group_id,shopper_group_discount
      FROM sh3e_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
31. SELECT product_id, `sh3e_vm_product`.*
      FROM `sh3e_vm_product`
      WHERE `product_id`=206
32. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=206
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
33. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=206
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
34. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='206'
      AND (start_date<='1743702380' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
35. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=206
36. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1743702380' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
37. SELECT tax_rate
      FROM sh3e_vm_product, sh3e_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=206
38. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=206
      AND `file_is_image`=1
      AND `file_published`=1
39. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=206
40. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
41. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=206
      AND `file_is_image`=0
      AND `file_published`=1
42. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id='206'
43. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
44. SELECT vendor_id
      FROM sh3e_vm_product
      WHERE product_id='1058'
45. SELECT product_id, `sh3e_vm_product`.*
      FROM `sh3e_vm_product`
      WHERE `product_id`=1058
46. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=1058
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
47. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=1058
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
48. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='1058'
      AND (start_date<='1743702380' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
49. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=1058
50. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1743702380' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
51. SELECT tax_rate
      FROM sh3e_vm_product, sh3e_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1058
52. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=1058
      AND `file_is_image`=1
      AND `file_published`=1
53. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=1058
54. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
55. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=1058
      AND `file_is_image`=0
      AND `file_published`=1
56. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id='1058'
57. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
58. SELECT vendor_id
      FROM sh3e_vm_product
      WHERE product_id='205'
59. SELECT product_id, `sh3e_vm_product`.*
      FROM `sh3e_vm_product`
      WHERE `product_id`=205
60. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=205
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=205
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
62. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='205'
      AND (start_date<='1743702380' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
63. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=205
64. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1743702380' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
65. SELECT tax_rate
      FROM sh3e_vm_product, sh3e_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=205
66. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=205
      AND `file_is_image`=1
      AND `file_published`=1
67. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=205
68. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
69. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=205
      AND `file_is_image`=0
      AND `file_published`=1
70. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id='205'
71. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
72. SELECT vendor_id
      FROM sh3e_vm_product
      WHERE product_id='203'
73. SELECT product_id, `sh3e_vm_product`.*
      FROM `sh3e_vm_product`
      WHERE `product_id`=203
74. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=203
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
75. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=203
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
76. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='203'
      AND (start_date<='1743702380' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
77. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=203
78. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1743702380' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
79. SELECT tax_rate
      FROM sh3e_vm_product, sh3e_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=203
80. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=203
      AND `file_is_image`=1
      AND `file_published`=1
81. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=203
82. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
83. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=203
      AND `file_is_image`=0
      AND `file_published`=1
84. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id='203'
85. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
86. SELECT vendor_id
      FROM sh3e_vm_product
      WHERE product_id='916'
87. SELECT product_id, `sh3e_vm_product`.*
      FROM `sh3e_vm_product`
      WHERE `product_id`=916
88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=916
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
89. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=916
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
90. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='916'
      AND (start_date<='1743702380' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
91. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=916
92. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1743702380' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
93. SELECT tax_rate
      FROM sh3e_vm_product, sh3e_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=916
94. SELECT `tax_rate`
      FROM sh3e_vm_vendor, sh3e_vm_tax_rate
      WHERE tax_country=vendor_country
      AND sh3e_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
95. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=916
      AND `file_is_image`=1
      AND `file_published`=1
96. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=916
97. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
98. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=916
      AND `file_is_image`=0
      AND `file_published`=1
99. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id='916'
100. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=0
       AND `file_published`=1
101. SELECT vendor_id
       FROM sh3e_vm_product
       WHERE product_id='917'
102. SELECT product_id, `sh3e_vm_product`.*
       FROM `sh3e_vm_product`
       WHERE `product_id`=917
103. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `sh3e_vm_product_price`
       WHERE product_id=917
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
104. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `sh3e_vm_product_price`
       WHERE product_id=917
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
105. SELECT amount,is_percent
       FROM sh3e_vm_product,sh3e_vm_product_discount
       WHERE product_id='917'
       AND (start_date<='1743702380' OR start_date=0)
       AND (end_date>='1743636960' OR end_date=0)
       AND product_discount_id=discount_id
106. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id=917
107. SELECT amount,is_percent
       FROM sh3e_vm_product,sh3e_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1743702380' OR start_date=0)
       AND (end_date>='1743636960' OR end_date=0)
       AND product_discount_id=discount_id
108. SELECT tax_rate
       FROM sh3e_vm_product, sh3e_vm_tax_rate
       WHERE product_tax_id=tax_rate_id
       AND product_id=917
109. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=917
       AND `file_is_image`=1
       AND `file_published`=1
110. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id=917
111. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=1
       AND `file_published`=1
112. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=917
       AND `file_is_image`=0
       AND `file_published`=1
113. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id='917'
114. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=0
       AND `file_published`=1
115. SELECT vendor_id
       FROM sh3e_vm_product
       WHERE product_id='918'
116. SELECT product_id, `sh3e_vm_product`.*
       FROM `sh3e_vm_product`
       WHERE `product_id`=918
117. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `sh3e_vm_product_price`
       WHERE product_id=918
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
118. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `sh3e_vm_product_price`
       WHERE product_id=918
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
119. SELECT amount,is_percent
       FROM sh3e_vm_product,sh3e_vm_product_discount
       WHERE product_id='918'
       AND (start_date<='1743702380' OR start_date=0)
       AND (end_date>='1743636960' OR end_date=0)
       AND product_discount_id=discount_id
120. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id=918
121. SELECT amount,is_percent
       FROM sh3e_vm_product,sh3e_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1743702380' OR start_date=0)
       AND (end_date>='1743636960' OR end_date=0)
       AND product_discount_id=discount_id
122. SELECT tax_rate
       FROM sh3e_vm_product, sh3e_vm_tax_rate
       WHERE product_tax_id=tax_rate_id
       AND product_id=918
123. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=918
       AND `file_is_image`=1
       AND `file_published`=1
124. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id=918
125. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=1
       AND `file_published`=1
126. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=918
       AND `file_is_image`=0
       AND `file_published`=1
127. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id='918'
128. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=0
       AND `file_published`=1
129. SELECT vendor_id
       FROM sh3e_vm_product
       WHERE product_id='919'
130. SELECT product_id, `sh3e_vm_product`.*
       FROM `sh3e_vm_product`
       WHERE `product_id`=919
131. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `sh3e_vm_product_price`
       WHERE product_id=919
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
132. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `sh3e_vm_product_price`
       WHERE product_id=919
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
133. SELECT amount,is_percent
       FROM sh3e_vm_product,sh3e_vm_product_discount
       WHERE product_id='919'
       AND (start_date<='1743702380' OR start_date=0)
       AND (end_date>='1743636960' OR end_date=0)
       AND product_discount_id=discount_id
134. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id=919
135. SELECT amount,is_percent
       FROM sh3e_vm_product,sh3e_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1743702380' OR start_date=0)
       AND (end_date>='1743636960' OR end_date=0)
       AND product_discount_id=discount_id
136. SELECT tax_rate
       FROM sh3e_vm_product, sh3e_vm_tax_rate
       WHERE product_tax_id=tax_rate_id
       AND product_id=919
137. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=919
       AND `file_is_image`=1
       AND `file_published`=1
138. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id=919
139. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=1
       AND `file_published`=1
140. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=919
       AND `file_is_image`=0
       AND `file_published`=1
141. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id='919'
142. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=0
       AND `file_published`=1
143. SELECT vendor_id
       FROM sh3e_vm_product
       WHERE product_id='920'
144. SELECT product_id, `sh3e_vm_product`.*
       FROM `sh3e_vm_product`
       WHERE `product_id`=920
145. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `sh3e_vm_product_price`
       WHERE product_id=920
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
146. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `sh3e_vm_product_price`
       WHERE product_id=920
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
147. SELECT amount,is_percent
       FROM sh3e_vm_product,sh3e_vm_product_discount
       WHERE product_id='920'
       AND (start_date<='1743702380' OR start_date=0)
       AND (end_date>='1743636960' OR end_date=0)
       AND product_discount_id=discount_id
148. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id=920
149. SELECT amount,is_percent
       FROM sh3e_vm_product,sh3e_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1743702380' OR start_date=0)
       AND (end_date>='1743636960' OR end_date=0)
       AND product_discount_id=discount_id
150. SELECT tax_rate
       FROM sh3e_vm_product, sh3e_vm_tax_rate
       WHERE product_tax_id=tax_rate_id
       AND product_id=920
151. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=920
       AND `file_is_image`=1
       AND `file_published`=1
152. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id=920
153. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=1
       AND `file_published`=1
154. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=920
       AND `file_is_image`=0
       AND `file_published`=1
155. SELECT product_parent_id
       FROM sh3e_vm_product
       WHERE product_id='920'
156. SELECT *
       FROM `sh3e_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=0
       AND `file_published`=1
157. SELECT id, title, module, POSITION, content, showtitle, control, params
       FROM sh3e_modules AS m
       LEFT JOIN sh3e_modules_menu AS mm
       ON mm.moduleid = m.id
       WHERE m.published = 1
       AND m.access <= 0
       AND m.client_id = 0
       AND ( mm.menuid = 14 OR mm.menuid = 0 )
       ORDER BY POSITION, ordering
158. SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
       FROM sh3e_content AS a
       INNER JOIN sh3e_categories AS cc
       ON cc.id = a.catid
       INNER JOIN sh3e_sections AS s
       ON s.id = a.sectionid
       WHERE a.state = 1
       AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-03 17:46:21' )
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-03 17:46:21' )
       AND s.id > 0
       AND (cc.id=1)
       AND (s.id=1)
       AND s.published = 1
       AND cc.published = 1
       ORDER BY a.created DESC
       LIMIT 0, 7
159. SELECT m.*, c.`option` AS component
       FROM sh3e_menu AS m
       LEFT JOIN sh3e_components AS c
       ON m.componentid = c.id
       WHERE m.published = 1
       ORDER BY m.sublevel, m.parent, m.ordering
160. SELECT category_id, category_name,category_parent_id
       FROM sh3e_vm_category, sh3e_vm_category_xref
       WHERE sh3e_vm_category_xref.category_child_id='63'
       AND sh3e_vm_category.category_id='63'
161. SELECT category_id, category_name,category_parent_id
       FROM sh3e_vm_category, sh3e_vm_category_xref
       WHERE sh3e_vm_category_xref.category_child_id='61'
       AND sh3e_vm_category.category_id='61'
162. SELECT category_id, category_name,category_parent_id
       FROM sh3e_vm_category, sh3e_vm_category_xref
       WHERE sh3e_vm_category_xref.category_child_id='59'
       AND sh3e_vm_category.category_id='59'
163. SELECT category_id, category_name, n. *  
       FROM `sh3e_vm_category`  
       LEFT JOIN `sh3e_vm_category_xref`    AS m
       ON m.`category_child_id` = `sh3e_vm_category`.`category_id`  
       LEFT JOIN `sh3e_vm_category_xref` AS n
       ON n.`category_parent_id` = m.`category_child_id`  
       WHERE m.`category_parent_id` =0  
       GROUP BY category_id  
       ORDER BY list_order
164. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=59
165. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '59'
       ORDER BY list_order
166. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 61
       LIMIT 1
167. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '61'
       ORDER BY list_order
168. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 62
       LIMIT 1
169. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '62'
       ORDER BY list_order
170. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 63
       LIMIT 1
171. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '63'
       ORDER BY list_order
172. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 64
       LIMIT 1
173. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '64'
       ORDER BY list_order
174. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 65
       LIMIT 1
175. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '65'
       ORDER BY list_order
176. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 67
       LIMIT 1
177. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '67'
       ORDER BY list_order
178. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 68
       LIMIT 1
179. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '68'
       ORDER BY list_order
180. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1140
       LIMIT 1
181. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1140'
       ORDER BY list_order
182. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1141
       LIMIT 1
183. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1141'
       ORDER BY list_order
184. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1138
       LIMIT 1
185. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1138'
       ORDER BY list_order
186. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1139
       LIMIT 1
187. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1139'
       ORDER BY list_order
188. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1040
       LIMIT 1
189. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1040'
       ORDER BY list_order
190. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1076
       LIMIT 1
191. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1076'
       ORDER BY list_order
192. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1118
       LIMIT 1
193. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1118'
       ORDER BY list_order
194. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1125
       LIMIT 1
195. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1125'
       ORDER BY list_order
196. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1078
       LIMIT 1
197. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1078'
       ORDER BY list_order
198. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1124
       LIMIT 1
199. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1124'
       ORDER BY list_order
200. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1152
       LIMIT 1
201. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1152'
       ORDER BY list_order
202. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1153
       LIMIT 1
203. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1153'
       ORDER BY list_order
204. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1155
       LIMIT 1
205. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1155'
       ORDER BY list_order
206. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1157
       LIMIT 1
207. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1157'
       ORDER BY list_order
208. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1156
       LIMIT 1
209. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1156'
       ORDER BY list_order
210. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1158
       LIMIT 1
211. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1158'
       ORDER BY list_order
212. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1159
       LIMIT 1
213. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1159'
       ORDER BY list_order
214. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1163
       LIMIT 1
215. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1163'
       ORDER BY list_order
216. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1039
217. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1039'
       ORDER BY list_order
218. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1042
       LIMIT 1
219. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1042'
       ORDER BY list_order
220. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1043
       LIMIT 1
221. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1043'
       ORDER BY list_order
222. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1044
       LIMIT 1
223. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1044'
       ORDER BY list_order
224. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1045
       LIMIT 1
225. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1045'
       ORDER BY list_order
226. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1066
       LIMIT 1
227. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1066'
       ORDER BY list_order
228. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1069
       LIMIT 1
229. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1069'
       ORDER BY list_order
230. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1070
       LIMIT 1
231. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1070'
       ORDER BY list_order
232. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1071
       LIMIT 1
233. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1071'
       ORDER BY list_order
234. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1073
       LIMIT 1
235. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1073'
       ORDER BY list_order
236. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1074
       LIMIT 1
237. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1074'
       ORDER BY list_order
238. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1075
       LIMIT 1
239. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1075'
       ORDER BY list_order
240. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1114
       LIMIT 1
241. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1114'
       ORDER BY list_order
242. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1108
       LIMIT 1
243. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1108'
       ORDER BY list_order
244. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1101
       LIMIT 1
245. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1101'
       ORDER BY list_order
246. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1102
       LIMIT 1
247. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1102'
       ORDER BY list_order
248. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1106
       LIMIT 1
249. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1106'
       ORDER BY list_order
250. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1104
       LIMIT 1
251. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1104'
       ORDER BY list_order
252. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1105
       LIMIT 1
253. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1105'
       ORDER BY list_order
254. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1112
       LIMIT 1
255. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1112'
       ORDER BY list_order
256. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1113
       LIMIT 1
257. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1113'
       ORDER BY list_order
258. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1115
       LIMIT 1
259. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1115'
       ORDER BY list_order
260. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1
261. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1'
       ORDER BY list_order
262. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 2
       LIMIT 1
263. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '2'
       ORDER BY list_order
264. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 42
       LIMIT 1
265. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '42'
       ORDER BY list_order
266. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 3
       LIMIT 1
267. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '3'
       ORDER BY list_order
268. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 4
       LIMIT 1
269. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '4'
       ORDER BY list_order
270. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 5
       LIMIT 1
271. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '5'
       ORDER BY list_order
272. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 6
       LIMIT 1
273. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '6'
       ORDER BY list_order
274. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 7
       LIMIT 1
275. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '7'
       ORDER BY list_order
276. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 8
       LIMIT 1
277. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '8'
       ORDER BY list_order
278. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 9
       LIMIT 1
279. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '9'
       ORDER BY list_order
280. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 10
       LIMIT 1
281. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '10'
       ORDER BY list_order
282. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 11
       LIMIT 1
283. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '11'
       ORDER BY list_order
284. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 12
       LIMIT 1
285. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '12'
       ORDER BY list_order
286. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 13
       LIMIT 1
287. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '13'
       ORDER BY list_order
288. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 14
       LIMIT 1
289. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '14'
       ORDER BY list_order
290. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 15
       LIMIT 1
291. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '15'
       ORDER BY list_order
292. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 16
       LIMIT 1
293. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '16'
       ORDER BY list_order
294. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1006
       LIMIT 1
295. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1006'
       ORDER BY list_order
296. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1007
       LIMIT 1
297. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1007'
       ORDER BY list_order
298. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1008
       LIMIT 1
299. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1008'
       ORDER BY list_order
300. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1012
       LIMIT 1
301. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1012'
       ORDER BY list_order
302. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1011
       LIMIT 1
303. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1011'
       ORDER BY list_order
304. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1013
       LIMIT 1
305. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1013'
       ORDER BY list_order
306. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1079
       LIMIT 1
307. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1079'
       ORDER BY list_order
308. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1123
       LIMIT 1
309. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1123'
       ORDER BY list_order
310. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1009
       LIMIT 1
311. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1009'
       ORDER BY list_order
312. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1010
       LIMIT 1
313. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1010'
       ORDER BY list_order
314. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1120
       LIMIT 1
315. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1120'
       ORDER BY list_order
316. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1121
       LIMIT 1
317. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1121'
       ORDER BY list_order
318. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1122
       LIMIT 1
319. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1122'
       ORDER BY list_order
320. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1020
321. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1020'
       ORDER BY list_order
322. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1021
       LIMIT 1
323. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1021'
       ORDER BY list_order
324. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1023
       LIMIT 1
325. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1023'
       ORDER BY list_order
326. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1022
       LIMIT 1
327. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1022'
       ORDER BY list_order
328. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1109
       LIMIT 1
329. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1109'
       ORDER BY list_order
330. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1110
       LIMIT 1
331. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1110'
       ORDER BY list_order
332. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1111
       LIMIT 1
333. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1111'
       ORDER BY list_order
334. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1014
335. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1014'
       ORDER BY list_order
336. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1024
337. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1024'
       ORDER BY list_order
338. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1025
       LIMIT 1
339. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1025'
       ORDER BY list_order
340. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1026
       LIMIT 1
341. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1026'
       ORDER BY list_order
342. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1027
       LIMIT 1
343. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1027'
       ORDER BY list_order
344. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1028
       LIMIT 1
345. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1028'
       ORDER BY list_order
346. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1029
       LIMIT 1
347. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1029'
       ORDER BY list_order
348. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1030
       LIMIT 1
349. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1030'
       ORDER BY list_order
350. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1031
       LIMIT 1
351. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1031'
       ORDER BY list_order
352. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1162
       LIMIT 1
353. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1162'
       ORDER BY list_order
354. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1015
355. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1015'
       ORDER BY list_order
356. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1019
       LIMIT 1
357. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1019'
       ORDER BY list_order
358. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1016
       LIMIT 1
359. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1016'
       ORDER BY list_order
360. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1017
       LIMIT 1
361. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1017'
       ORDER BY list_order
362. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1018
       LIMIT 1
363. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1018'
       ORDER BY list_order
364. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=44
365. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '44'
       ORDER BY list_order
366. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 45
       LIMIT 1
367. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '45'
       ORDER BY list_order
368. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 46
       LIMIT 1
369. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '46'
       ORDER BY list_order
370. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 48
       LIMIT 1
371. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '48'
       ORDER BY list_order
372. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 49
       LIMIT 1
373. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '49'
       ORDER BY list_order
374. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 50
       LIMIT 1
375. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '50'
       ORDER BY list_order
376. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 51
       LIMIT 1
377. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '51'
       ORDER BY list_order
378. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 47
       LIMIT 1
379. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '47'
       ORDER BY list_order
380. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 53
       LIMIT 1
381. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '53'
       ORDER BY list_order
382. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 52
       LIMIT 1
383. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '52'
       ORDER BY list_order
384. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 54
       LIMIT 1
385. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '54'
       ORDER BY list_order
386. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 58
       LIMIT 1
387. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '58'
       ORDER BY list_order
388. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1128
       LIMIT 1
389. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1128'
       ORDER BY list_order
390. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1129
       LIMIT 1
391. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1129'
       ORDER BY list_order
392. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1130
       LIMIT 1
393. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1130'
       ORDER BY list_order
394. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1047
       LIMIT 1
395. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1047'
       ORDER BY list_order
396. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1160
       LIMIT 1
397. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1160'
       ORDER BY list_order
398. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1161
       LIMIT 1
399. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1161'
       ORDER BY list_order
400. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1143
       LIMIT 1
401. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1143'
       ORDER BY list_order
402. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1048
403. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1048'
       ORDER BY list_order
404. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1049
       LIMIT 1
405. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1049'
       ORDER BY list_order
406. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1051
       LIMIT 1
407. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1051'
       ORDER BY list_order
408. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1052
       LIMIT 1
409. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1052'
       ORDER BY list_order
410. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1053
       LIMIT 1
411. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1053'
       ORDER BY list_order
412. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1057
       LIMIT 1
413. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1057'
       ORDER BY list_order
414. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1080
       LIMIT 1
415. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1080'
       ORDER BY list_order
416. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1081
       LIMIT 1
417. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1081'
       ORDER BY list_order
418. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=43
419. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '43'
       ORDER BY list_order
420. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1032
       LIMIT 1
421. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1032'
       ORDER BY list_order
422. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1132
       LIMIT 1
423. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1132'
       ORDER BY list_order
424. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1133
       LIMIT 1
425. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1133'
       ORDER BY list_order
426. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1134
       LIMIT 1
427. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1134'
       ORDER BY list_order
428. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1033
       LIMIT 1
429. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1033'
       ORDER BY list_order
430. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1034
       LIMIT 1
431. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1034'
       ORDER BY list_order
432. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1035
       LIMIT 1
433. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1035'
       ORDER BY list_order
434. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1036
       LIMIT 1
435. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1036'
       ORDER BY list_order
436. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1037
       LIMIT 1
437. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1037'
       ORDER BY list_order
438. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1041
       LIMIT 1
439. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1041'
       ORDER BY list_order
440. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1038
       LIMIT 1
441. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1038'
       ORDER BY list_order
442. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1147
443. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1147'
       ORDER BY list_order
444. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1148
       LIMIT 1
445. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1148'
       ORDER BY list_order
446. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1149
       LIMIT 1
447. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1149'
       ORDER BY list_order
448. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1150
       LIMIT 1
449. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1150'
       ORDER BY list_order
450. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1151
       LIMIT 1
451. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1151'
       ORDER BY list_order
452. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1164
       LIMIT 1
453. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1164'
       ORDER BY list_order
454. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=56
455. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '56'
       ORDER BY list_order
456. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 71
       LIMIT 1
457. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '71'
       ORDER BY list_order
458. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 86
       LIMIT 1
459. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '86'
       ORDER BY list_order
460. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 73
       LIMIT 1
461. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '73'
       ORDER BY list_order
462. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1086
       LIMIT 1
463. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1086'
       ORDER BY list_order
464. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1087
       LIMIT 1
465. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1087'
       ORDER BY list_order
466. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1088
       LIMIT 1
467. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1088'
       ORDER BY list_order
468. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1089
       LIMIT 1
469. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1089'
       ORDER BY list_order
470. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1090
       LIMIT 1
471. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1090'
       ORDER BY list_order
472. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1127
       LIMIT 1
473. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1127'
       ORDER BY list_order
474. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=57
475. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '57'
       ORDER BY list_order
476. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 79
       LIMIT 1
477. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '79'
       ORDER BY list_order
478. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 80
       LIMIT 1
479. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '80'
       ORDER BY list_order
480. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1077
       LIMIT 1
481. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1077'
       ORDER BY list_order
482. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1058
483. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1058'
       ORDER BY list_order
484. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1059
       LIMIT 1
485. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1059'
       ORDER BY list_order
486. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1060
       LIMIT 1
487. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1060'
       ORDER BY list_order
488. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1062
       LIMIT 1
489. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1062'
       ORDER BY list_order
490. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1063
       LIMIT 1
491. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1063'
       ORDER BY list_order
492. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1064
       LIMIT 1
493. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1064'
       ORDER BY list_order
494. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1065
       LIMIT 1
495. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1065'
       ORDER BY list_order
496. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1082
497. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1082'
       ORDER BY list_order
498. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1083
       LIMIT 1
499. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1083'
       ORDER BY list_order
500. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1085
       LIMIT 1
501. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1085'
       ORDER BY list_order
502. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1084
       LIMIT 1
503. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1084'
       ORDER BY list_order
504. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1097
       LIMIT 1
505. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1097'
       ORDER BY list_order
506. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1098
       LIMIT 1
507. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1098'
       ORDER BY list_order
508. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1107
       LIMIT 1
509. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1107'
       ORDER BY list_order
510. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1099
       LIMIT 1
511. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1099'
       ORDER BY list_order
512. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1100
       LIMIT 1
513. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1100'
       ORDER BY list_order
514. SELECT category_id, category_name
       FROM sh3e_vm_category
       WHERE `category_id`=1136
515. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1136'
       ORDER BY list_order
516. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1137
       LIMIT 1
517. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1137'
       ORDER BY list_order
518. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1142
       LIMIT 1
519. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1142'
       ORDER BY list_order
520. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1144
       LIMIT 1
521. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1144'
       ORDER BY list_order
522. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1145
       LIMIT 1
523. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1145'
       ORDER BY list_order
524. SELECT category_id,category_child_id,category_name  
       FROM `sh3e_vm_category`
       LEFT JOIN `sh3e_vm_category_xref`
       ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
       WHERE `sh3e_vm_category`.`category_id` = 1146
       LIMIT 1
525. SELECT category_child_id, list_order
       FROM `sh3e_vm_category_xref`  
       LEFT JOIN `sh3e_vm_category`
       ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
       WHERE `category_parent_id` = '1146'
       ORDER BY list_order
526. SELECT oldurl, dateadd
       FROM sh3e_redirection
       WHERE newurl = 'index.php?option=com_aicontactsafe&Itemid=12&lang=ru&layout=message&pf=3&view=message'
527. SELECT name, link,id
       FROM sh3e_menu
       WHERE id = '12'
       AND published='1'
528. SELECT oldurl, dateadd
       FROM sh3e_redirection
       WHERE newurl = 'index.php?option=com_aicontactsafe&Itemid=7&lang=ru&layout=message&pf=2&view=message'
529. SELECT name, link,id
       FROM sh3e_menu
       WHERE id = '7'
       AND published='1'