5.3.29 eregi Клапаны регулирующие Контрольно-измерительные приборы, газоанализаторы, газосигнализаторы, КИПиА

№ тел.: 8-951-50-15-315
телефон: 8-903-406-25-11
E-mail: priboryplus@yandex.ru

344065, Ростов-на-Дону,
ул. Геологическая, 12, офис 17

КАТАЛОГ ПРОДУКЦИИ

СПЕЦПРЕДЛОЖЕНИЕ

Продажа оборудования по ценам заводов-изготовителей
Система скидок

КОНФИДЕНЦИАЛЬНОСТЬ

Политика конфиденциальности
Каталог arrow Запорно-регулирующая арматура arrow Клапаны регулирующие

Клапаны регулирующие

ESBE 3F Трёхходовой клапан смесительный
ESBE 3F Трёхходовой клапан смесительный
ESBE 3F Клапан регулирующий чугунный трёхходовой – это компактный смесительный клапан из чугуна, предназначен для использования в системах отопления и охлаждения. Клапан снабжен ручкой для ручного управления, но может управляться и автоматически с пом [Подробнее...]


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

Application afterLoad: 0.032 seconds, 0.88 MB
Application afterInitialise: 0.711 seconds, 6.42 MB
Application afterRoute: 0.913 seconds, 8.87 MB
Application afterDispatch: 1.518 seconds, 17.47 MB
Application afterRender: 2.266 seconds, 19.67 MB

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

20747264

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

  1. DELETE
      FROM sh3e_session
      WHERE ( TIME < '1743694450' )
  2. SELECT *
      FROM sh3e_session
      WHERE session_id = 'b7clsioq8s12n6su2ej1tfmv03'
  3. UPDATE `sh3e_session`
      SET `time`='1743701651',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0'
      WHERE session_id='b7clsioq8s12n6su2ej1tfmv03'
  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 '%1090 klapani reguliruuyschie.html%')
      AND (`published` > 0))
  7. SELECT oldurl, newurl
      FROM sh3e_redirection
      WHERE oldurl = '1090-klapani-reguliruuyschie.html'
      LIMIT 1
  8. UPDATE sh3e_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=14&category_id=1090&lang=ru&page=shop.browse'
      AND `oldurl` = '1090-klapani-reguliruuyschie.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 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`);
  15. SELECT module_id, module_name
      FROM sh3e_vm_module
      ORDER BY module_name
  16. SELECT module_perms
      FROM sh3e_vm_module
      WHERE module_name='shop'
  17. SELECT id
      FROM sh3e_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  18. SELECT COUNT(*) AS parentcnt
      FROM sh3e_vm_product
      WHERE product_parent_id>0
  19. 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`=1090
     
      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'
  20. SELECT category_id, category_name, category_thumb_image
      FROM sh3e_vm_category
      WHERE category_id='1090'
  21. SELECT category_id, category_description
      FROM sh3e_vm_category
      WHERE category_id='1090'
  22. 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='1090'
      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
  23. SELECT category_id, category_name,category_parent_id
      FROM sh3e_vm_category, sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_child_id='1090'
      AND sh3e_vm_category.category_id='1090'
  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='56'
      AND sh3e_vm_category.category_id='56'
  25. SELECT id, params
      FROM sh3e_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  26. 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`=1090
     
      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
  27. SELECT vendor_id
      FROM sh3e_vm_product
      WHERE product_id='792'
  28. SELECT shopper_group_id,shopper_group_discount
      FROM sh3e_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  29. SELECT product_id, `sh3e_vm_product`.*
      FROM `sh3e_vm_product`
      WHERE `product_id`=792
  30. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=792
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  31. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=792
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  32. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='792'
      AND (start_date<='1743701652' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
  33. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=792
  34. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1743701652' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
  35. SELECT tax_rate
      FROM sh3e_vm_product, sh3e_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=792
  36. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=792
      AND `file_is_image`=1
      AND `file_published`=1
  37. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=792
  38. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  39. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=792
      AND `file_is_image`=0
      AND `file_published`=1
  40. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id='792'
  41. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  42. 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
  43. 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:34:12' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-03 17:34:12' )
      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
  44. 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
  45. SELECT category_id, category_name,category_parent_id
      FROM sh3e_vm_category, sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_child_id='1090'
      AND sh3e_vm_category.category_id='1090'
  46. SELECT category_id, category_name,category_parent_id
      FROM sh3e_vm_category, sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_child_id='56'
      AND sh3e_vm_category.category_id='56'
  47. 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
  48. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=59
  49. 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
  50. 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
  51. 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
  52. 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
  53. 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
  54. 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
  55. 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
  56. 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
  57. 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
  58. 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
  59. 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
  60. 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
  61. 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
  62. 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
  63. 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
  64. 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
  65. 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
  66. 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
  67. 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
  68. 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
  69. 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
  70. 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
  71. 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
  72. 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
  73. 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
  74. 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
  75. 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
  76. 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
  77. 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
  78. 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
  79. 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
  80. 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
  81. 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
  82. 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
  83. 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
  84. 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
  85. 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
  86. 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
  87. 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
  88. 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
  89. 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
  90. 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
  91. 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
  92. 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
  93. 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
  94. 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
  95. 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
  96. 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
  97. 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
  98. 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
  99. 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
  100. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1039
  101. 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
  102. 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
  103. 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
  104. 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
  105. 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
  106. 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
  107. 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
  108. 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
  109. 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
  110. 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
  111. 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
  112. 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
  113. 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
  114. 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
  115. 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
  116. 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
  117. 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
  118. 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
  119. 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
  120. 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
  121. 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
  122. 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
  123. 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
  124. 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
  125. 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
  126. 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
  127. 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
  128. 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
  129. 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
  130. 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
  131. 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
  132. 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
  133. 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
  134. 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
  135. 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
  136. 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
  137. 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
  138. 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
  139. 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
  140. 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
  141. 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
  142. 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
  143. 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
  144. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1
  145. 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
  146. 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
  147. 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
  148. 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
  149. 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
  150. 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
  151. 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
  152. 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
  153. 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
  154. 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
  155. 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
  156. 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
  157. 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
  158. 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
  159. 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
  160. 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
  161. 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
  162. 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
  163. 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
  164. 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
  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` = '10'
      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` = 11
      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` = '11'
      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` = 12
      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` = '12'
      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` = 13
      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` = '13'
      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` = 14
      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` = '14'
      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` = 15
      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` = '15'
      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` = 16
      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` = '16'
      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` = 1006
      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` = '1006'
      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` = 1007
      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` = '1007'
      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` = 1008
      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` = '1008'
      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` = 1012
      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` = '1012'
      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` = 1011
      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` = '1011'
      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` = 1013
      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` = '1013'
      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` = 1079
      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` = '1079'
      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` = 1123
      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` = '1123'
      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` = 1009
      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` = '1009'
      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` = 1010
      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` = '1010'
      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` = 1120
      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` = '1120'
      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` = 1121
      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` = '1121'
      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` = 1122
      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` = '1122'
      ORDER BY list_order
  204. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1020
  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` = '1020'
      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` = 1021
      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` = '1021'
      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` = 1023
      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` = '1023'
      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` = 1022
      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` = '1022'
      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` = 1109
      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` = '1109'
      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` = 1110
      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` = '1110'
      ORDER BY list_order
  216. 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
  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` = '1111'
      ORDER BY list_order
  218. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1014
  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` = '1014'
      ORDER BY list_order
  220. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1024
  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` = '1024'
      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` = 1025
      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` = '1025'
      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` = 1026
      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` = '1026'
      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` = 1027
      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` = '1027'
      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` = 1028
      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` = '1028'
      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` = 1029
      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` = '1029'
      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` = 1030
      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` = '1030'
      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` = 1031
      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` = '1031'
      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` = 1162
      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` = '1162'
      ORDER BY list_order
  238. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1015
  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` = '1015'
      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` = 1019
      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` = '1019'
      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` = 1016
      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` = '1016'
      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` = 1017
      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` = '1017'
      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` = 1018
      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` = '1018'
      ORDER BY list_order
  248. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=44
  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` = '44'
      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` = 45
      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` = '45'
      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` = 46
      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` = '46'
      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` = 48
      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` = '48'
      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` = 49
      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` = '49'
      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` = 50
      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` = '50'
      ORDER BY list_order
  260. 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
  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` = '51'
      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` = 47
      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` = '47'
      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` = 53
      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` = '53'
      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` = 52
      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` = '52'
      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` = 54
      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` = '54'
      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` = 58
      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` = '58'
      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` = 1128
      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` = '1128'
      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` = 1129
      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` = '1129'
      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` = 1130
      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` = '1130'
      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` = 1047
      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` = '1047'
      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` = 1160
      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` = '1160'
      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` = 1161
      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` = '1161'
      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` = 1143
      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` = '1143'
      ORDER BY list_order
  286. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1048
  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` = '1048'
      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` = 1049
      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` = '1049'
      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` = 1051
      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` = '1051'
      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` = 1052
      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` = '1052'
      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` = 1053
      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` = '1053'
      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` = 1057
      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` = '1057'
      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` = 1080
      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` = '1080'
      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` = 1081
      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` = '1081'
      ORDER BY list_order
  302. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=43
  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` = '43'
      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` = 1032
      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` = '1032'
      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` = 1132
      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` = '1132'
      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` = 1133
      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` = '1133'
      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` = 1134
      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` = '1134'
      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` = 1033
      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` = '1033'
      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` = 1034
      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` = '1034'
      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` = 1035
      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` = '1035'
      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` = 1036
      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` = '1036'
      ORDER BY list_order
  320. 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
  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` = '1037'
      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` = 1041
      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` = '1041'
      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` = 1038
      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` = '1038'
      ORDER BY list_order
  326. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1147
  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` = '1147'
      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` = 1148
      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` = '1148'
      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` = 1149
      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` = '1149'
      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` = 1150
      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` = '1150'
      ORDER BY list_order
  334. 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
  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` = '1151'
      ORDER BY list_order
  336. 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
  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` = '1164'
      ORDER BY list_order
  338. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=56
  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` = '56'
      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` = 71
      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` = '71'
      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` = 86
      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` = '86'
      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` = 73
      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` = '73'
      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` = 1086
      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` = '1086'
      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` = 1087
      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` = '1087'
      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` = 1088
      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` = '1088'
      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` = 1089
      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` = '1089'
      ORDER BY list_order
  354. 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
  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` = '1090'
      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` = 1127
      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` = '1127'
      ORDER BY list_order
  358. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=57
  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` = '57'
      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` = 79
      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` = '79'
      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` = 80
      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` = '80'
      ORDER BY list_order
  364. 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
  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` = '1077'
      ORDER BY list_order
  366. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1058
  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` = '1058'
      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` = 1059
      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` = '1059'
      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` = 1060
      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` = '1060'
      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` = 1062
      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` = '1062'
      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` = 1063
      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` = '1063'
      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` = 1064
      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` = '1064'
      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` = 1065
      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` = '1065'
      ORDER BY list_order
  380. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1082
  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` = '1082'
      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` = 1083
      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` = '1083'
      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` = 1085
      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` = '1085'
      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` = 1084
      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` = '1084'
      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` = 1097
      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` = '1097'
      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` = 1098
      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` = '1098'
      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` = 1107
      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` = '1107'
      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` = 1099
      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` = '1099'
      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` = 1100
      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` = '1100'
      ORDER BY list_order
  398. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1136
  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` = '1136'
      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` = 1137
      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` = '1137'
      ORDER BY list_order
  402. 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
  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` = '1142'
      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` = 1144
      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` = '1144'
      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` = 1145
      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` = '1145'
      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` = 1146
      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` = '1146'
      ORDER BY list_order
  410. SELECT oldurl, dateadd
      FROM sh3e_redirection
      WHERE newurl = 'index.php?option=com_aicontactsafe&Itemid=12&lang=ru&layout=message&pf=3&view=message'
  411. SELECT name, link,id
      FROM sh3e_menu
      WHERE id = '12'
      AND published='1'
  412. SELECT oldurl, dateadd
      FROM sh3e_redirection
      WHERE newurl = 'index.php?option=com_aicontactsafe&Itemid=7&lang=ru&layout=message&pf=2&view=message'
  413. SELECT name, link,id
      FROM sh3e_menu
      WHERE id = '7'
      AND published='1'

•Зарегистрировано запросов старых компонентов: 4•

  1. SELECT `lft`, `rgt`
      FROM `sh3e_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  2. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM sh3e_core_acl_aro_groups AS g1

      INNER JOIN sh3e_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  3. SELECT `lft`, `rgt`
      FROM `sh3e_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  4. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM sh3e_core_acl_aro_groups AS g1

      INNER JOIN sh3e_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft

•Языковые файлы загружены•

•Диагностика непереведённых строк•

•Нет•

•Дизайнер непереведённых строк•

•Нет•