5.3.29 ДНК-4Д Контролер насосной станции | Контроллеры Микроникс | Приборы АСУТП НТФ "Микроникс" | Контрольно-измерительные приборы, газоанализаторы, газосигнализаторы, КИПиА

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

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

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

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

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

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

Политика конфиденциальности
Каталог arrow Приборы АСУТП НТФ "Микроникс" arrow Контроллеры Микроникс arrow ДНК-4Д Контролер насосной станции
ДНК-4Д Контролер насосной станции
Увеличить

ДНК-4Д Контролер насосной станции

ДНК-4Д Контролер насосной станции служит для управления работой и защиты от аварий насосов повысительных насосных станций.Основная функция изделия - поддержание заданного давления жидкости (воды). Изделие ДНК-4 предназначено для управления насосами в составе шкафа управления насосной станцией. Максимальное количество управляемых изделием насосов - четыре.

Давление жидкости определяется по датчику с аналоговым выходом 4-20 мА. Рассчитано на монтаж на передней панели шкафа.

Аппаратная реализация изделия аналогична изделию ДНК-4. Отличия только в программном обеспечении, реализующем алгоритмы поддержания заданного давления, назначении входов/выходов изделия и возможности его совместной работы с частотно-регулируемыми приводами.

Функции ДНК-4Д

  • переключение насосов по выбранному алгоритму;
  • совместная работа с преобразователями частоты, устройствами плавного пуска (расширяемый перечень);
  • защита от аварийных ситуаций, таких как:

-перегрев двигателя насоса,
-попадание воды в масляный картер насоса,
-отсутствие перекачиваемой жидкости (работа насосов «на сухую»),
-неисправность датчиков насосов и датчика давления,
-выход напряжения питающей сети за допустимые границы,
-неправильная фазировка питающей сети;
-уменьшение сопротивления изоляции двигателя и питающего кабеля насоса;

  • запоминание произошедших аварийных ситуаций;
  • подсчет моточасов и количества пусков по каждому насосу;
  • напоминание о необходимости обслуживания насосов (по выработке заданного количества моточасов);
  • мониторинг состояния датчиков, облегчающий ремонт в случае возникновения неисправности и предотвращающий аварию насосной станции;
  • удаленный мониторинг состояния изделия и подключенных к нему насосов через последовательный интерфейс;
  • удаленное управление работой насосов и изменение настроек по последовательному интерфейсу
  • ручное управление работой насосов с сохранением всех защит;
  • отключение всех защит при подаче внешнего сигнала (например, по сигналу пожарной тревоги);
  • периодические пробные пуски выключенных насосов.

Основным способом защиты от аварийных ситуаций являются отключение насосов, работе которых угрожает возникшая авария. При этом работа насосной станции в целом поддерживается, пока набор оставшегося исправного оборудования под управлением контроллера это позволяет.

При использовании насосов со встроенными в них датчиками изделие поддерживает кондуктометрические датчики влажности типа СС06 (производства НТФ «Микроникс») и аналогичные, а также резистивные термодатчики с восходящей характеристикой (ptc-типа) и сопротивлением срабатывания около 2 кОм. Возможно использование термодатчиков типа СТ14-2, ТРП10, В59 и аналогичных. Поддерживаются также датчики типа «сухой контакт». Датчики служат для обнаружения влаги в масляном картере насоса и/или обмотках электродвигателя.

Защита от отсутствия перекачиваемой жидкости обеспечивается установкой на насосной станции реле давления с дискретным выходом. В процессе функционирования контроллер выдаёт команды управления насосами как по интерфейсу RS-485, так и в виде дискретных сигналов, тем самым поддерживая заданное давление жидкости на выходе насосной станции. При этом пороги включения и отключения насосов задаются в настройках контроллера.

Изделие обеспечивает ведение протокола работы насосной станции, в котором фиксируется время возникновения и устранения аварийных ситуаций.

Изделие может питаться как от трехфазной сети переменного тока 380 В, так и от однофазной сети 220В.

Изделие представляет собой микропроцессорное устройство с предустановленной программой. В изделии присутствуют:

входы:

  • для датчика давления;
  • для датчиков влажности;
  • для датчиков температуры;
  • для сигналов типа «сухой контакт»;
  • контроля перевода на ручной режим управления;
  • измерения изоляции;
  • питающей сети;

выходы:

  • управления насосами;
  • сигнализации;
  • два интерфейса RS-485.

Питание изделия резервированное, от фаз А, B, C.

Изделие имеет 10 выходов. Все выходы представляет собой контакты реле.

Назначение входов и выходов определяется настройками и может изменяться в зависимости от количества насосов, способа управления ими и используемых датчиков.

Наименование параметра Значение параметра
Напряжение питания изделия, В (фазное) / ток потребления, не более, мА85 - 265 / 80*
Релейные выходы. Максимальный длительный ток нагрузки, Ане более 6
Релейные выходы. Предельно допустимый кратковременный неповторяющийся ток нагрузки, Ане более 15
Релейные выходы. Максимально допустимое напряжение переменного тока, В250
Релейные выходы. Минимально допустимый переменный ток, А0,01
Типы датчиков температуры РТС-термистор, размыкающийся термоконтакт
Типы датчиков влажности «Микроникс» СС06, замыкающийся контакт
Тип датчика давления аналоговый 4-20 мА
Пороговые сопротивления по выводам датчиков температуры (выводы ТД и «┴»), разделяющие состояния замыкание – норма – перегрев (обрыв), кОм0,12 - 2,2
Пороговые сопротивления по выводам датчиков влажности (выводы ДВ и «┴»), разделяющие состояния обрыв – воздух (масло) – вода, кОм100 - 50
Параметры резистора, устанавливаемого в насос для контроля целостности цепи датчика влажности100 кОм ±5% , 1 Вт
Сопротивление между выводами датчика уровня, распознаваемое как сигнал «контакты замкнуты», кОм менее 40
Сопротивление между выводами датчика уровня, распознаваемое как сигнал «контакты разомкнуты», кОм более 60
Сопротивление в цепи измерения изоляции, определяемое как авария, кОм менее 900-1300
Тип и напряжение (В) испытательного сигнала, используемого для дискретных входов Постоянное, +3,3
Напряжение, используемое при измерении сопротивления изоляции, В Пульсирующее, + 270
Тип питающей сети, для которой производится анализ последовательности фаз и уровней напряжений50Гц 380 В, 3 фазы или 220 В
Диапазоны установок напряжений питающей сети, в которых ДНК допускает работу насосов187-242 В, 176-253 В, 165-264 В, 154-275 В
Точность индикации напряжения питающей сети, %±3
Диапазон рабочих температур, °Сминус 20 - плюс 55
Относительная влажность воздуха, %не более 90 без конденсации
Габариты (с учетом съемных клемм), мм144х96х85
Масса, не более, г250
Степень защиты /степень защиты по передней панелиIP20 /IP 54
Вид климатического исполнения УХЛ 3.1
Выходное напряжение источника питания внешних аналоговых датчиков, В24
Порог ограничения тока источника питания внешних аналоговых датчиков, мА100
Протокол связи в качестве ведомого устройства Modbus RTU, Modbus ASCII
Протокол связи в качестве ведущего устройств аModbus RTU
Тип интерфейсов RS-485, гальваническая развязка до 1000 В
Количество интерфейсов-2

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

Application afterLoad: 0.006 seconds, 0.88 MB
Application afterInitialise: 0.362 seconds, 6.43 MB
Application afterRoute: 0.523 seconds, 8.87 MB
Application afterDispatch: 0.945 seconds, 17.38 MB
Application afterRender: 1.632 seconds, 19.69 MB

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

20771264

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

  1. DELETE
      FROM sh3e_session
      WHERE ( TIME < '1743694225' )
  2. SELECT *
      FROM sh3e_session
      WHERE session_id = '9512tli3ndpm190qvj2r9tdng4'
  3. UPDATE `sh3e_session`
      SET `time`='1743701425',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0'
      WHERE session_id='9512tli3ndpm190qvj2r9tdng4'
  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 '%1151 kontrolleri mikroniks%')
      AND (`published` > 0))
  7. SELECT oldurl, newurl
      FROM sh3e_redirection
      WHERE oldurl = '1151-kontrolleri-mikroniks/1054-dnk-4d-kontroler-nasosnoi-stancii.html'
      LIMIT 1
  8. UPDATE sh3e_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=14&category_id=1151&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1054'
      AND `oldurl` = '1151-kontrolleri-mikroniks/1054-dnk-4d-kontroler-nasosnoi-stancii.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 *
      FROM `sh3e_vm_product`
      WHERE `product_id`=1054
      AND `product_publish`='Y'
  19. SELECT product_sku, related_products
      FROM sh3e_vm_product,sh3e_vm_product_relations
      WHERE sh3e_vm_product_relations.product_id='1054'
      AND product_publish='Y'
      AND FIND_IN_SET(sh3e_vm_product.product_id, REPLACE(related_products, '|', ',' ))
      LIMIT 0, 4
  20. SELECT category_id, category_name,category_parent_id
      FROM sh3e_vm_category, sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_child_id='1151'
      AND sh3e_vm_category.category_id='1151'
  21. SELECT category_id, category_name,category_parent_id
      FROM sh3e_vm_category, sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_child_id='1147'
      AND sh3e_vm_category.category_id='1147'
  22. SELECT id, params
      FROM sh3e_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  23. SELECT COUNT(*) AS parentcnt
      FROM sh3e_vm_product
      WHERE product_parent_id>0
  24. 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`=79
     
      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, 2000
  25. SELECT category_child_id
      FROM sh3e_vm_category_xref
      WHERE category_parent_id='1151'
  26. SELECT manufacturer_id
      FROM sh3e_vm_product_mf_xref
      WHERE product_id='1054'
  27. SELECT mf_name,sh3e_vm_manufacturer.manufacturer_id
      FROM sh3e_vm_product_mf_xref,sh3e_vm_manufacturer
      WHERE product_id='1054'
      AND sh3e_vm_manufacturer.manufacturer_id=sh3e_vm_product_mf_xref.manufacturer_id
  28. SELECT vendor_id
      FROM sh3e_vm_product
      WHERE product_id='1054'
  29. SELECT shopper_group_id,shopper_group_discount
      FROM sh3e_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  30. SELECT product_id, `sh3e_vm_product`.*
      FROM `sh3e_vm_product`
      WHERE `product_id`=1054
  31. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=1054
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  32. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=1054
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  33. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='1054'
      AND (start_date<='1743701426' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
  34. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=1054
  35. SELECT amount,is_percent
      FROM sh3e_vm_product,sh3e_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1743701426' OR start_date=0)
      AND (end_date>='1743636960' OR end_date=0)
      AND product_discount_id=discount_id
  36. SELECT tax_rate
      FROM sh3e_vm_product, sh3e_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1054
  37. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=1054
      AND `file_is_image`=1
      AND `file_published`=1
  38. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id=1054
  39. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  40. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=1054
      AND `file_is_image`=0
      AND `file_published`=1
  41. SELECT product_parent_id
      FROM sh3e_vm_product
      WHERE product_id='1054'
  42. SELECT *
      FROM `sh3e_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  43. SELECT attribute_value
      FROM sh3e_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  44. SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `sh3e_vm_product_files`
      WHERE file_product_id = '0'
      AND file_published = '1'
      AND file_is_image = '0'
  45. SELECT COUNT(product_id) AS num_rows
      FROM sh3e_vm_product
      WHERE product_parent_id='1054'
  46. SELECT COUNT(product_id) AS num_rows
      FROM sh3e_vm_product
      WHERE product_parent_id='1054'
  47. SELECT sh3e_vm_vendor.vendor_name
      FROM sh3e_vm_product, sh3e_vm_vendor
      WHERE sh3e_vm_product.product_id='1054'
      AND sh3e_vm_vendor.vendor_id=sh3e_vm_product.vendor_id
  48. SELECT *
      FROM sh3e_vm_product_product_type_xref
      WHERE product_id='1054'
  49. SELECT product_id, `sh3e_vm_product`.*
      FROM `sh3e_vm_product`
      WHERE `product_id`=1054
  50. SELECT product_id, attribute, product_parent_id
      FROM sh3e_vm_product
      WHERE product_id='1054'
  51. SELECT product_id, attribute
      FROM sh3e_vm_product
      WHERE product_id='1054'
  52. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=1054
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  53. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `sh3e_vm_product_price`
      WHERE product_id=1054
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  54. SELECT product_id, custom_attribute, product_parent_id
      FROM sh3e_vm_product
      WHERE product_id='1054'
  55. SELECT product_id, custom_attribute
      FROM sh3e_vm_product
      WHERE product_id='1054'
  56. SELECT product_id,product_name
      FROM sh3e_vm_product
      WHERE product_parent_id='1054'
      AND product_publish='Y'
  57. SELECT `payment_method_id`
      FROM `sh3e_vm_payment_method`
      WHERE `payment_class`='ps_paypal_api'
      AND `payment_enabled`='Y'
  58. 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
  59. 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:30:26' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-03 17:30:26' )
      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
  60. 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
  61. SELECT category_id, category_name,category_parent_id
      FROM sh3e_vm_category, sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_child_id='1151'
      AND sh3e_vm_category.category_id='1151'
  62. SELECT category_id, category_name,category_parent_id
      FROM sh3e_vm_category, sh3e_vm_category_xref
      WHERE sh3e_vm_category_xref.category_child_id='1147'
      AND sh3e_vm_category.category_id='1147'
  63. 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
  64. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=59
  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` = '59'
      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` = 61
      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` = '61'
      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` = 62
      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` = '62'
      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` = 63
      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` = '63'
      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` = 64
      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` = '64'
      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` = 65
      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` = '65'
      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` = 67
      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` = '67'
      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` = 68
      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` = '68'
      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` = 1140
      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` = '1140'
      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` = 1141
      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` = '1141'
      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` = 1138
      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` = '1138'
      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` = 1139
      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` = '1139'
      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` = 1040
      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` = '1040'
      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` = 1076
      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` = '1076'
      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` = 1118
      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` = '1118'
      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` = 1125
      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` = '1125'
      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` = 1078
      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` = '1078'
      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` = 1124
      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` = '1124'
      ORDER BY list_order
  100. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT 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
  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` = '1152'
      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` = 1153
      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` = '1153'
      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` = 1155
      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` = '1155'
      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` = 1157
      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` = '1157'
      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` = 1156
      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` = '1156'
      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` = 1158
      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` = '1158'
      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` = 1159
      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` = '1159'
      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` = 1163
      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` = '1163'
      ORDER BY list_order
  116. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1039
  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` = '1039'
      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` = 1042
      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` = '1042'
      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` = 1043
      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` = '1043'
      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` = 1044
      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` = '1044'
      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` = 1045
      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` = '1045'
      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` = 1066
      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` = '1066'
      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` = 1069
      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` = '1069'
      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` = 1070
      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` = '1070'
      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` = 1071
      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` = '1071'
      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` = 1073
      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` = '1073'
      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` = 1074
      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` = '1074'
      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` = 1075
      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` = '1075'
      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` = 1114
      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` = '1114'
      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` = 1108
      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` = '1108'
      ORDER BY list_order
  144. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT 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
  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` = '1101'
      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` = 1102
      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` = '1102'
      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` = 1106
      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` = '1106'
      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` = 1104
      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` = '1104'
      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` = 1105
      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` = '1105'
      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` = 1112
      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` = '1112'
      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` = 1113
      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` = '1113'
      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` = 1115
      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` = '1115'
      ORDER BY list_order
  160. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=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` = '1'
      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` = 2
      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` = '2'
      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` = 42
      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` = '42'
      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` = 3
      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` = '3'
      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` = 4
      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` = '4'
      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` = 5
      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` = '5'
      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` = 6
      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` = '6'
      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` = 7
      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` = '7'
      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` = 8
      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` = '8'
      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` = 9
      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` = '9'
      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` = 10
      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` = '10'
      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` = 11
      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` = '11'
      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` = 12
      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` = '12'
      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` = 13
      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` = '13'
      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` = 14
      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` = '14'
      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` = 15
      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` = '15'
      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` = 16
      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` = '16'
      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` = 1006
      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` = '1006'
      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` = 1007
      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` = '1007'
      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` = 1008
      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` = '1008'
      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` = 1012
      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` = '1012'
      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` = 1011
      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` = '1011'
      ORDER BY list_order
  204. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1013
      LIMIT 1
  205. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1013'
      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` = 1079
      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` = '1079'
      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` = 1123
      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` = '1123'
      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` = 1009
      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` = '1009'
      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` = 1010
      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` = '1010'
      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` = 1120
      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` = '1120'
      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` = 1121
      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` = '1121'
      ORDER BY list_order
  218. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1122
      LIMIT 1
  219. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1122'
      ORDER BY list_order
  220. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1020
  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` = '1020'
      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` = 1021
      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` = '1021'
      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` = 1023
      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` = '1023'
      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` = 1022
      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` = '1022'
      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` = 1109
      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` = '1109'
      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` = 1110
      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` = '1110'
      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` = 1111
      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` = '1111'
      ORDER BY list_order
  234. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1014
  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` = '1014'
      ORDER BY list_order
  236. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1024
  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` = '1024'
      ORDER BY list_order
  238. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1025
      LIMIT 1
  239. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1025'
      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` = 1026
      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` = '1026'
      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` = 1027
      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` = '1027'
      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` = 1028
      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` = '1028'
      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` = 1029
      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` = '1029'
      ORDER BY list_order
  248. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1030
      LIMIT 1
  249. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1030'
      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` = 1031
      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` = '1031'
      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` = 1162
      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` = '1162'
      ORDER BY list_order
  254. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1015
  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` = '1015'
      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` = 1019
      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` = '1019'
      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` = 1016
      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` = '1016'
      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` = 1017
      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` = '1017'
      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` = 1018
      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` = '1018'
      ORDER BY list_order
  264. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=44
  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` = '44'
      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` = 45
      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` = '45'
      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` = 46
      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` = '46'
      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` = 48
      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` = '48'
      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` = 49
      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` = '49'
      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` = 50
      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` = '50'
      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` = 51
      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` = '51'
      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` = 47
      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` = '47'
      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` = 53
      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` = '53'
      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` = 52
      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` = '52'
      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` = 54
      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` = '54'
      ORDER BY list_order
  286. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 58
      LIMIT 1
  287. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '58'
      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` = 1128
      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` = '1128'
      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` = 1129
      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` = '1129'
      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` = 1130
      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` = '1130'
      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` = 1047
      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` = '1047'
      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` = 1160
      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` = '1160'
      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` = 1161
      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` = '1161'
      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` = 1143
      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` = '1143'
      ORDER BY list_order
  302. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1048
  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` = '1048'
      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` = 1049
      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` = '1049'
      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` = 1051
      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` = '1051'
      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` = 1052
      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` = '1052'
      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` = 1053
      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` = '1053'
      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` = 1057
      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` = '1057'
      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` = 1080
      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` = '1080'
      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` = 1081
      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` = '1081'
      ORDER BY list_order
  318. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=43
  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` = '43'
      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` = 1032
      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` = '1032'
      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` = 1132
      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` = '1132'
      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` = 1133
      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` = '1133'
      ORDER BY list_order
  326. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1134
      LIMIT 1
  327. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1134'
      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` = 1033
      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` = '1033'
      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` = 1034
      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` = '1034'
      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` = 1035
      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` = '1035'
      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` = 1036
      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` = '1036'
      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` = 1037
      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` = '1037'
      ORDER BY list_order
  338. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1041
      LIMIT 1
  339. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1041'
      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` = 1038
      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` = '1038'
      ORDER BY list_order
  342. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1147
  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` = '1147'
      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` = 1148
      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` = '1148'
      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` = 1149
      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` = '1149'
      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` = 1150
      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` = '1150'
      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` = 1151
      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` = '1151'
      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` = 1164
      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` = '1164'
      ORDER BY list_order
  354. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=56
  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` = '56'
      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` = 71
      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` = '71'
      ORDER BY list_order
  358. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 86
      LIMIT 1
  359. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '86'
      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` = 73
      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` = '73'
      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` = 1086
      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` = '1086'
      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` = 1087
      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` = '1087'
      ORDER BY list_order
  366. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1088
      LIMIT 1
  367. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1088'
      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` = 1089
      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` = '1089'
      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` = 1090
      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` = '1090'
      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` = 1127
      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` = '1127'
      ORDER BY list_order
  374. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=57
  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` = '57'
      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` = 79
      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` = '79'
      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` = 80
      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` = '80'
      ORDER BY list_order
  380. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1077
      LIMIT 1
  381. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1077'
      ORDER BY list_order
  382. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1058
  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` = '1058'
      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` = 1059
      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` = '1059'
      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` = 1060
      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` = '1060'
      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` = 1062
      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` = '1062'
      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` = 1063
      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` = '1063'
      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` = 1064
      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` = '1064'
      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` = 1065
      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` = '1065'
      ORDER BY list_order
  396. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1082
  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` = '1082'
      ORDER BY list_order
  398. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1083
      LIMIT 1
  399. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1083'
      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` = 1085
      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` = '1085'
      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` = 1084
      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` = '1084'
      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` = 1097
      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` = '1097'
      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` = 1098
      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` = '1098'
      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` = 1107
      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` = '1107'
      ORDER BY list_order
  410. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1099
      LIMIT 1
  411. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1099'
      ORDER BY list_order
  412. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1100
      LIMIT 1
  413. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1100'
      ORDER BY list_order
  414. SELECT category_id, category_name
      FROM sh3e_vm_category
      WHERE `category_id`=1136
  415. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1136'
      ORDER BY list_order
  416. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1137
      LIMIT 1
  417. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1137'
      ORDER BY list_order
  418. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT 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
  419. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1142'
      ORDER BY list_order
  420. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1144
      LIMIT 1
  421. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1144'
      ORDER BY list_order
  422. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1145
      LIMIT 1
  423. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1145'
      ORDER BY list_order
  424. SELECT category_id,category_child_id,category_name  
      FROM `sh3e_vm_category`
      LEFT JOIN `sh3e_vm_category_xref`
      ON `sh3e_vm_category_xref`.`category_parent_id`=`sh3e_vm_category`.`category_id`
      WHERE `sh3e_vm_category`.`category_id` = 1146
      LIMIT 1
  425. SELECT category_child_id, list_order
      FROM `sh3e_vm_category_xref`  
      LEFT JOIN `sh3e_vm_category`
      ON `sh3e_vm_category_xref`.`category_child_id` = `sh3e_vm_category`.`category_id`  
      WHERE `category_parent_id` = '1146'
      ORDER BY list_order
  426. SELECT oldurl, dateadd
      FROM sh3e_redirection
      WHERE newurl = 'index.php?option=com_aicontactsafe&Itemid=12&lang=ru&layout=message&pf=3&view=message'
  427. SELECT name, link,id
      FROM sh3e_menu
      WHERE id = '12'
      AND published='1'
  428. SELECT oldurl, dateadd
      FROM sh3e_redirection
      WHERE newurl = 'index.php?option=com_aicontactsafe&Itemid=7&lang=ru&layout=message&pf=2&view=message'
  429. 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

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

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

•Нет•

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

•Нет•