Главная страницаКаталогКамины → Каминные топки RUEGG

Каминные топки RUEGG


Каминные топки RUEGG Classic Line Каминные топки RUEGG Premium Line
Каминные топки RUEGG Smart Line

Топка Jupiter K
Артикул Jupiter K
Ширина 767 мм.
Высота 1374 мм.
Глубина 474 мм.
Вес 161 кг.

Фронтальная каминная топка с плоским стеклом, производство Австрия.

Подробнее
Топка Jupiter Kr
Артикул Jupiter Kr
Ширина 741 мм.
Высота 1373 мм.
Глубина 503 мм.
Вес 161 кг.

Фронтальная каминная топка с круглым стеклом, производство Австрия.

Подробнее
Топка Jupiter prism
Артикул Jupiter prism
Ширина 777 мм.
Высота 1508 мм.
Глубина 548 мм.
Вес 208 кг.

Фронтальная каминная топка со стеклом в форме призмы, производство Австрия.

Подробнее
Топка Kyros flat
Артикул Kyros flat
Ширина 700 мм.
Высота 1850 мм.
Глубина 580 мм.

Фронтальная каминная топка с плоским стеклом, производство Австрия.

Подробнее
Топка Kyros round
Артикул Kyros round
Ширина 700 мм.
Высота 1850 мм.
Глубина 690 мм.

Фронтальная каминная топка с круглым стеклом, производство Австрия.

Подробнее
Топка Lumo
Артикул Lumo
Ширина 905 мм.
Высота 1788 мм.
Глубина 619 мм.
Вес 370 кг.

Фронтальная каминная топка, размер по дверце В78 х Ш58 см, производство Австрия.

Подробнее
Топка Mars 180r
Артикул Mars 180r
Ширина 662 мм.
Высота 1556 мм.
Глубина 693 мм.
Вес 176 кг.

Фронтальная каминная топка с круглым стеклом, производство Австрия.

Подробнее
Топка Mars HK
Артикул Mars HK
Ширина 637 мм.
Высота 1552 мм.
Глубина 497 мм.
Вес 186 кг.

Фронтальная каминная топка с плоским стеклом, производство Австрия.

Подробнее
Топка Mars HKr
Артикул Mars HKr
Ширина 677 мм.
Высота 1513 мм.
Глубина 553 мм.
Вес 186 кг.

Фронтальная каминная топка с круглым стеклом, производство Австрия.

Подробнее
Топка Mars K
Артикул Mars K
Ширина 667 мм.
Высота 1385 мм.
Глубина 474 мм.
Вес 144 кг.

Фронтальная каминная топка с плоским стеклом, производство Австрия.

Подробнее
Топка Mars Kr
Артикул Mars Kr
Ширина 641 мм.
Высота 1384 мм.
Глубина 460 мм.
Вес 144 кг.

Фронтальная каминная топка с круглым стеклом, производство Австрия.

Подробнее
Топка Mars prism
Артикул Mars prism
Ширина 677 мм.
Высота 1508 мм.
Глубина 548 мм.
Вес 186 кг.

Фронтальная каминная топка со стеклом в форме призмы, производство Австрия.

Подробнее

Страница 2 из 4

Поступившие товары

Топка EllipseR
Артикул EllipseR

Подробнее
Топка 720-4R
Артикул 720-4R

Подробнее
Топка Jupiter HK
Артикул Jupiter HK

Подробнее

Печи для дома, камины, банные печи, русские печи, барбекю, строительство печей, барбекю, каминов Наша группа вконтакте Наша группа в facebook Яндекс.Метрика

Обратный звонок

Дежурный менеджер свяжется с вами в течение 15-20 минут, время работы дежурного менеджера — 9.00-18.00 в рабочие дни. Спасибо!



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

Application afterLoad: 0.000 seconds, 0.45 MB
Application afterInitialise: 0.040 seconds, 5.41 MB
Application afterRoute: 0.075 seconds, 9.03 MB
Application afterDispatch: 0.647 seconds, 22.01 MB
Application afterRender: 0.872 seconds, 24.37 MB

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

25884160

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = '7s0lciknti328hdo0ttm3qf102'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1790096582' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = '7s0lciknti328hdo0ttm3qf102'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '7s0lciknti328hdo0ttm3qf102','1790100182','','0','1','0' )
  5. SELECT *
      FROM glenrich_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM glenrich_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT oldurl, newurl
      FROM glenrich_redirection
      WHERE oldurl = 'kaminy/kaminnye-topki-ruegg.html'
      ORDER BY rank ASC
      LIMIT 1
  8. UPDATE glenrich_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'kaminy/kaminnye-topki-ruegg.html'
  9. SELECT m.*, c.`option` AS component
      FROM glenrich_menu AS m
      LEFT JOIN glenrich_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  10. SELECT m.*, c.`option` AS component
      FROM glenrich_menu AS m
      LEFT JOIN glenrich_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  11. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  12. SELECT glenrich_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `glenrich_vm_shopper_group`
      WHERE glenrich_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  13. 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 (`glenrich_vm_vendor` v, `glenrich_vm_country` c)
                                   
      LEFT JOIN glenrich_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`);
  14. SELECT module_perms
      FROM glenrich_vm_module
      WHERE module_name='shop'
  15. SELECT id
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  16. SELECT COUNT(*) AS parentcnt
      FROM glenrich_vm_product
      WHERE product_parent_id>0
  17. SELECT COUNT(DISTINCT `glenrich_vm_product`.`product_sku`) AS num_rows
      FROM (`glenrich_vm_product`, `glenrich_vm_category`, `glenrich_vm_product_category_xref`,`glenrich_vm_shopper_group`)
      LEFT JOIN `glenrich_vm_product_price`
      ON `glenrich_vm_product`.`product_id` = `glenrich_vm_product_price`.`product_id`
      WHERE `glenrich_vm_product_category_xref`.`product_id`=`glenrich_vm_product`.`product_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=`glenrich_vm_category`.`category_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=61
     
      AND ((`glenrich_vm_product`.`product_id`=`glenrich_vm_product_price`.`product_id`
      AND `glenrich_vm_shopper_group`.`shopper_group_id`=`glenrich_vm_product_price`.`shopper_group_id`) OR `glenrich_vm_product_price`.`product_id` IS NULL)
     
      AND `glenrich_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  18. SELECT category_id, category_name
      FROM glenrich_vm_category
      WHERE category_id='61'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='61'
  20. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM glenrich_vm_category,glenrich_vm_category_xref
      WHERE glenrich_vm_category_xref.category_parent_id='61'
      AND glenrich_vm_category.category_id=glenrich_vm_category_xref.category_child_id
      AND glenrich_vm_category.vendor_id='1'
      AND glenrich_vm_category.category_publish='Y'
      ORDER BY glenrich_vm_category.list_order, glenrich_vm_category.category_name ASC
  21. SELECT id, params
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  22. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=110&lang=ru&page=shop.browse'
  23. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  24. SELECT c.category_name, c.category_id, x.category_parent_id
      FROM glenrich_vm_category AS c
     
      LEFT JOIN glenrich_vm_category_xref AS x
      ON c.category_id = x.category_child_id;
  25. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=110&lang=ru&limitstart=0&page=shop.browse'
  26. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=112&lang=ru&page=shop.browse'
  27. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  28. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=112&lang=ru&limitstart=0&page=shop.browse'
  29. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=113&lang=ru&page=shop.browse'
  30. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  31. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=113&lang=ru&limitstart=0&page=shop.browse'
  32. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM glenrich_vm_category, glenrich_vm_category_xref
      WHERE glenrich_vm_category_xref.category_child_id='61'
      AND glenrich_vm_category.category_id='61'
  33. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM glenrich_vm_category, glenrich_vm_category_xref
      WHERE glenrich_vm_category_xref.category_child_id='1'
      AND glenrich_vm_category.category_id='1'
  34. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  35. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  36. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  37. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  38. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  39. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  40. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  41. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  42. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  43. SELECT DISTINCT `glenrich_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `glenrich_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`, `glenrich_vm_product`.`mdate`, `glenrich_vm_product`.`cdate`
      FROM (`glenrich_vm_product`, `glenrich_vm_category`, `glenrich_vm_product_category_xref`,`glenrich_vm_shopper_group`)
      LEFT JOIN `glenrich_vm_product_price`
      ON `glenrich_vm_product`.`product_id` = `glenrich_vm_product_price`.`product_id`
      WHERE `glenrich_vm_product_category_xref`.`product_id`=`glenrich_vm_product`.`product_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=`glenrich_vm_category`.`category_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=61
     
      AND ((`glenrich_vm_product`.`product_id`=`glenrich_vm_product_price`.`product_id`
      AND `glenrich_vm_shopper_group`.`shopper_group_id`=`glenrich_vm_product_price`.`shopper_group_id`) OR `glenrich_vm_product_price`.`product_id` IS NULL)
     
      AND `glenrich_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `glenrich_vm_product`.`product_sku`
     
      ORDER BY `glenrich_vm_product_category_xref`.`product_list` ASC
      LIMIT 12, 12
  44. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1121'
  45. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  46. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1121
  47. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1121'
  48. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1121'
  49. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1121
  50. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1121'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  51. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1121
  52. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  53. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1121'
  54. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  55. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  56. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  57. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  58. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  59. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1121'
  60. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1121
  63. SELECT `tax_rate`
      FROM glenrich_vm_vendor, glenrich_vm_tax_rate
      WHERE tax_country=vendor_country
      AND glenrich_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  64. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1121
      AND `file_is_image`=1
      AND `file_published`=1
  65. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1121
      AND `file_is_image`=0
  66. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1121'
  67. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=615'
  68. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  69. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 615
  70. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '615'
  71. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=615'
  72. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=615
  73. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='615'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  74. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=615
  75. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  76. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='615'
  77. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  78. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  80. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  81. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='615'
  82. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  83. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  84. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=615
  85. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=615
      AND `file_is_image`=1
      AND `file_published`=1
  86. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=615
      AND `file_is_image`=0
  87. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='615'
  88. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=616'
  89. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  90. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 616
  91. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '616'
  92. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=616'
  93. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=616
  94. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='616'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  95. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=616
  96. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  97. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='616'
  98. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  100. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  102. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='616'
  103. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  104. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  105. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=616
  106. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=616
      AND `file_is_image`=1
      AND `file_published`=1
  107. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=616
      AND `file_is_image`=0
  108. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='616'
  109. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=618'
  110. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  111. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 618
  112. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '618'
  113. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=618'
  114. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=618
  115. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='618'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=618
  117. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  118. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='618'
  119. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  120. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  121. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  122. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  123. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='618'
  124. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  125. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  126. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=618
  127. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=618
      AND `file_is_image`=1
      AND `file_published`=1
  128. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=618
      AND `file_is_image`=0
  129. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='618'
  130. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=619'
  131. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  132. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 619
  133. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '619'
  134. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=619'
  135. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=619
  136. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='619'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  137. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=619
  138. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='619'
  140. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  141. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  142. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  143. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  144. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='619'
  145. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  146. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  147. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=619
  148. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=619
      AND `file_is_image`=1
      AND `file_published`=1
  149. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=619
      AND `file_is_image`=0
  150. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='619'
  151. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=620'
  152. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  153. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 620
  154. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '620'
  155. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=620'
  156. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=620
  157. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='620'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  158. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=620
  159. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  160. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='620'
  161. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  162. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  163. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  164. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  165. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='620'
  166. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=620
  169. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=620
      AND `file_is_image`=1
      AND `file_published`=1
  170. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=620
      AND `file_is_image`=0
  171. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='620'
  172. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1125'
  173. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  174. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1125
  175. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1125'
  176. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1125'
  177. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1125
  178. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1125'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  179. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1125
  180. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  181. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1125'
  182. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  183. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  184. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  185. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  186. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1125'
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1125
  190. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1125
      AND `file_is_image`=1
      AND `file_published`=1
  191. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1125
  192. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  193. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1125
      AND `file_is_image`=0
  194. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1125'
  195. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=622'
  196. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  197. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 622
  198. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '622'
  199. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=622'
  200. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=622
  201. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='622'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=622
  203. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='622'
  205. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  206. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  209. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='622'
  210. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  211. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  212. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=622
  213. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=622
      AND `file_is_image`=1
      AND `file_published`=1
  214. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=622
      AND `file_is_image`=0
  215. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='622'
  216. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1124'
  217. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  218. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1124
  219. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1124'
  220. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1124'
  221. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1124
  222. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1124'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  223. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1124
  224. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  225. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1124'
  226. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  229. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  230. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1124'
  231. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1124
  234. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1124
      AND `file_is_image`=1
      AND `file_published`=1
  235. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1124
  236. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  237. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1124
      AND `file_is_image`=0
  238. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1124'
  239. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1126'
  240. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  241. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1126
  242. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1126'
  243. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1126'
  244. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1126
  245. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1126'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  246. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1126
  247. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  248. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1126'
  249. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  251. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  252. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  253. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1126'
  254. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  255. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  256. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1126
  257. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1126
      AND `file_is_image`=1
      AND `file_published`=1
  258. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1126
      AND `file_is_image`=0
  259. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1126'
  260. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=623'
  261. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  262. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 623
  263. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '623'
  264. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=623'
  265. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=623
  266. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='623'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=623
  268. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  269. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='623'
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  273. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  274. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='623'
  275. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  276. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  277. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=623
  278. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=623
      AND `file_is_image`=1
      AND `file_published`=1
  279. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=623
  280. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  281. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=623
      AND `file_is_image`=0
  282. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='623'
  283. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=624'
  284. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  285. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 624
  286. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '624'
  287. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=624'
  288. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=624
  289. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='624'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  290. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=624
  291. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  292. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='624'
  293. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  294. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  295. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  296. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  297. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='624'
  298. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  299. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  300. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=624
  301. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=624
      AND `file_is_image`=1
      AND `file_published`=1
  302. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=624
  303. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  304. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=624
      AND `file_is_image`=0
  305. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='624'
  306. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  307. SELECT DISTINCT product_sku,glenrich_vm_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
      FROM glenrich_vm_product, glenrich_vm_product_category_xref, glenrich_vm_category
      WHERE
    (glenrich_vm_product.product_parent_id='' OR glenrich_vm_product.product_parent_id='0')

      AND glenrich_vm_product.product_id=glenrich_vm_product_category_xref.product_id

      AND glenrich_vm_category.category_id=glenrich_vm_product_category_xref.category_id

      AND glenrich_vm_category.category_id='61'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  308. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='610'
  309. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=610
  310. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='610'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  311. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=610
  312. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  313. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='610'
  314. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=610
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  315. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=610
  316. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='610'
  317. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='598'
  318. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=598
  319. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='598'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=598
  321. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  322. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='598'
  323. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=598
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  324. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=598
  325. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='598'
  326. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='614'
  327. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=614
  328. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='614'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  329. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=614
  330. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  331. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='614'
  332. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=614
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  333. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=614
  334. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='614'
  335. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=610'
  336. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  337. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  338. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  339. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=610'
  340. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=610'
  341. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  342. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  343. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  344. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=610'
  345. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=598'
  346. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  347. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 598
  348. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '598'
  349. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=598'
  350. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=598'
  351. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  352. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 598
  353. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '598'
  354. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=598'
  355. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=614'
  356. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  357. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 614
  358. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  359. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=614'
  360. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=614'
  361. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  362. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 614
  363. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  364. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=614'
  365. SELECT m.*, am.params AS adv_params
      FROM glenrich_modules AS m
      LEFT JOIN glenrich_advancedmodules AS am
      ON am.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      ORDER BY m.ordering, m.id
  366. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
  367. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  368. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
  369. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  370. SELECT published
      FROM glenrich_modules
      WHERE module='mod_virtuemart_cart'
  371. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=0
      AND a.category_publish='Y'
  372. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=0
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  373. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  374. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  375. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  376. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=1
      AND a.category_publish='Y'
  377. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=1
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  378. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=1
      AND a.category_publish='Y'
  379. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=1
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  380. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
  381. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  382. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=139
      AND a.category_publish='Y'
  383. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=164
      AND a.category_publish='Y'
  384. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=11
      AND a.category_publish='Y'
  385. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=12
      AND a.category_publish='Y'
  386. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=13
      AND a.category_publish='Y'
  387. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=162
      AND a.category_publish='Y'
  388. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=125
      AND a.category_publish='Y'
  389. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=14
      AND a.category_publish='Y'
  390. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=15
      AND a.category_publish='Y'
  391. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=24
      AND a.category_publish='Y'
  392. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=25
      AND a.category_publish='Y'
  393. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=56
      AND a.category_publish='Y'
  394. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
  395. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  396. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=88
      AND a.category_publish='Y'
  397. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=89
      AND a.category_publish='Y'
  398. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=90
      AND a.category_publish='Y'
  399. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=91
      AND a.category_publish='Y'
  400. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=93
      AND a.category_publish='Y'
  401. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=166
      AND a.category_publish='Y'
  402. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  403. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  404. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=110
      AND a.category_publish='Y'
  405. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=112
      AND a.category_publish='Y'
  406. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=113
      AND a.category_publish='Y'
  407. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
  408. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  409. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=120
      AND a.category_publish='Y'
  410. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=117
      AND a.category_publish='Y'
  411. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=119
      AND a.category_publish='Y'
  412. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=118
      AND a.category_publish='Y'
  413. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=167
      AND a.category_publish='Y'
  414. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=161
      AND a.category_publish='Y'
  415. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=1
      AND a.category_publish='Y'
  416. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=1
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  417. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&page=shop.browse'
  418. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  419. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&limitstart=0&page=shop.browse'
  420. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
  421. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=133
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  422. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
  423. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  424. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=139
      AND a.category_publish='Y'
  425. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=164
      AND a.category_publish='Y'
  426. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
  427. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  428. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
  429. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=11
      AND a.category_publish='Y'
  430. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=11
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  431. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=11
      AND a.category_publish='Y'
  432. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&page=shop.browse'
  433. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  434. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&limitstart=0&page=shop.browse'
  435. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=12
      AND a.category_publish='Y'
  436. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=12
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  437. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=12
      AND a.category_publish='Y'
  438. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&page=shop.browse'
  439. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  440. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&limitstart=0&page=shop.browse'
  441. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=13
      AND a.category_publish='Y'
  442. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=13
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  443. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=13
      AND a.category_publish='Y'
  444. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  445. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  446. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  447. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=162
      AND a.category_publish='Y'
  448. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=162
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  449. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=162
      AND a.category_publish='Y'
  450. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&page=shop.browse'
  451. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  452. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&limitstart=0&page=shop.browse'
  453. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=125
      AND a.category_publish='Y'
  454. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=125
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  455. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=125
      AND a.category_publish='Y'
  456. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&page=shop.browse'
  457. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  458. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&limitstart=0&page=shop.browse'
  459. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=14
      AND a.category_publish='Y'
  460. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=14
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  461. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=14
      AND a.category_publish='Y'
  462. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&page=shop.browse'
  463. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  464. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&limitstart=0&page=shop.browse'
  465. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=15
      AND a.category_publish='Y'
  466. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=15
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  467. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=15
      AND a.category_publish='Y'
  468. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&page=shop.browse'
  469. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  470. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&limitstart=0&page=shop.browse'
  471. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=24
      AND a.category_publish='Y'
  472. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=24
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  473. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=24
      AND a.category_publish='Y'
  474. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&page=shop.browse'
  475. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  476. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&limitstart=0&page=shop.browse'
  477. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=25
      AND a.category_publish='Y'
  478. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=25
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  479. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=25
      AND a.category_publish='Y'
  480. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&page=shop.browse'
  481. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  482. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&limitstart=0&page=shop.browse'
  483. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=56
      AND a.category_publish='Y'
  484. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=56
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  485. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=56
      AND a.category_publish='Y'
  486. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&page=shop.browse'
  487. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  488. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&limitstart=0&page=shop.browse'
  489. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
  490. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=60
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  491. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
  492. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  493. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=88
      AND a.category_publish='Y'
  494. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=89
      AND a.category_publish='Y'
  495. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=90
      AND a.category_publish='Y'
  496. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=91
      AND a.category_publish='Y'
  497. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=93
      AND a.category_publish='Y'
  498. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=166
      AND a.category_publish='Y'
  499. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  500. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  501. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  502. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  503. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=61
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  504. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  505. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  506. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=110
      AND a.category_publish='Y'
  507. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=112
      AND a.category_publish='Y'
  508. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=113
      AND a.category_publish='Y'
  509. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  510. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  511. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=110&lang=ru&page=shop.browse'
  512. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  513. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=110&lang=ru&limitstart=0&page=shop.browse'
  514. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=110
      AND a.category_publish='Y'
  515. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=110
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  516. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=110
      AND a.category_publish='Y'
  517. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=112&lang=ru&page=shop.browse'
  518. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  519. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=112&lang=ru&limitstart=0&page=shop.browse'
  520. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=112
      AND a.category_publish='Y'
  521. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=112
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  522. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=112
      AND a.category_publish='Y'
  523. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=113&lang=ru&page=shop.browse'
  524. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  525. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=113&lang=ru&limitstart=0&page=shop.browse'
  526. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=113
      AND a.category_publish='Y'
  527. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=113
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  528. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=113
      AND a.category_publish='Y'
  529. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  530. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  531. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  532. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
  533. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=62
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  534. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
  535. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  536. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=120
      AND a.category_publish='Y'
  537. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=117
      AND a.category_publish='Y'
  538. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=119
      AND a.category_publish='Y'
  539. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=118
      AND a.category_publish='Y'
  540. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=167
      AND a.category_publish='Y'
  541. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
  542. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  543. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
  544. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=161
      AND a.category_publish='Y'
  545. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=161
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  546. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=161
      AND a.category_publish='Y'
  547. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
  548. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  549. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
  550. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=2
      AND a.category_publish='Y'
  551. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=2
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  552. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=2
      AND a.category_publish='Y'
  553. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=2
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  554. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=132
      AND a.category_publish='Y'
  555. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=132
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  556. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=135
      AND a.category_publish='Y'
  557. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=136
      AND a.category_publish='Y'
  558. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=137
      AND a.category_publish='Y'
  559. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=145
      AND a.category_publish='Y'
  560. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=16
      AND a.category_publish='Y'
  561. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=17
      AND a.category_publish='Y'
  562. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=140
      AND a.category_publish='Y'
  563. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=140
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  564. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=141
      AND a.category_publish='Y'
  565. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=142
      AND a.category_publish='Y'
  566. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=143
      AND a.category_publish='Y'
  567. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=18
      AND a.category_publish='Y'
  568. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=19
      AND a.category_publish='Y'
  569. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=20
      AND a.category_publish='Y'
  570. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=22
      AND a.category_publish='Y'
  571. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=157
      AND a.category_publish='Y'
  572. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=157
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  573. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=158
      AND a.category_publish='Y'
  574. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=159
      AND a.category_publish='Y'
  575. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=23
      AND a.category_publish='Y'
  576. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=21
      AND a.category_publish='Y'
  577. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=144
      AND a.category_publish='Y'
  578. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=54
      AND a.category_publish='Y'
  579. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
  580. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  581. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
  582. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
  583. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=6
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  584. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
  585. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  586. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=40
      AND a.category_publish='Y'
  587. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=74
      AND a.category_publish='Y'
  588. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=42
      AND a.category_publish='Y'
  589. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=75
      AND a.category_publish='Y'
  590. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=43
      AND a.category_publish='Y'
  591. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=44
      AND a.category_publish='Y'
  592. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=41
      AND a.category_publish='Y'
  593. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
  594. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  595. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
  596. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=3
      AND a.category_publish='Y'
  597. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=3
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  598. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=3
      AND a.category_publish='Y'
  599. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=3
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  600. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=26
      AND a.category_publish='Y'
  601. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=27
      AND a.category_publish='Y'
  602. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=28
      AND a.category_publish='Y'
  603. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=29
      AND a.category_publish='Y'
  604. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=124
      AND a.category_publish='Y'
  605. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=30
      AND a.category_publish='Y'
  606. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=31
      AND a.category_publish='Y'
  607. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=163
      AND a.category_publish='Y'
  608. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
  609. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  610. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
  611. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=4
      AND a.category_publish='Y'
  612. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=4
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  613. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=4
      AND a.category_publish='Y'
  614. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=4
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  615. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=32
      AND a.category_publish='Y'
  616. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=33
      AND a.category_publish='Y'
  617. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
  618. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  619. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
  620. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=8
      AND a.category_publish='Y'
  621. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=8
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  622. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=8
      AND a.category_publish='Y'
  623. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=8
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  624. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=48
      AND a.category_publish='Y'
  625. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=48
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  626. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=94
      AND a.category_publish='Y'
  627. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=95
      AND a.category_publish='Y'
  628. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=96
      AND a.category_publish='Y'
  629. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=97
      AND a.category_publish='Y'
  630. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=103
      AND a.category_publish='Y'
  631. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=104
      AND a.category_publish='Y'
  632. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=168
      AND a.category_publish='Y'
  633. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=49
      AND a.category_publish='Y'
  634. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
  635. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  636. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
  637. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=9
      AND a.category_publish='Y'
  638. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=9
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  639. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=9
      AND a.category_publish='Y'
  640. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=9
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  641. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=50
      AND a.category_publish='Y'
  642. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=51
      AND a.category_publish='Y'
  643. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=51
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  644. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=126
      AND a.category_publish='Y'
  645. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=127
      AND a.category_publish='Y'
  646. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=128
      AND a.category_publish='Y'
  647. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=129
      AND a.category_publish='Y'
  648. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=130
      AND a.category_publish='Y'
  649. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
  650. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  651. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
  652. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=7
      AND a.category_publish='Y'
  653. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=7
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  654. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=7
      AND a.category_publish='Y'
  655. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=7
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  656. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=45
      AND a.category_publish='Y'
  657. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=46
      AND a.category_publish='Y'
  658. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=47
      AND a.category_publish='Y'
  659. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=57
      AND a.category_publish='Y'
  660. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=58
      AND a.category_publish='Y'
  661. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=59
      AND a.category_publish='Y'
  662. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
  663. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  664. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
  665. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=169
      AND a.category_publish='Y'
  666. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=169
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  667. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=169
      AND a.category_publish='Y'
  668. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
  669. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  670. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
  671. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=170
      AND a.category_publish='Y'
  672. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=170
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  673. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=170
      AND a.category_publish='Y'
  674. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=170
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  675. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=171
      AND a.category_publish='Y'
  676. SELECT params
      FROM glenrich_advancedmodules
      WHERE moduleid = 41
  677. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
  678. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  679. SELECT name, link,id
      FROM glenrich_menu
      WHERE id = '8'
      AND published='1'
  680. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
  681. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  682. SELECT c.category_name, c.category_id, c.category_description, x.category_parent_id
      FROM glenrich_vm_category AS c
     
      LEFT JOIN glenrich_vm_category_xref AS x
      ON c.category_id = x.category_child_id;
  683. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=12&page=shop.browse'

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = '7s0lciknti328hdo0ttm3qf102'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1790096582' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = '7s0lciknti328hdo0ttm3qf102'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '7s0lciknti328hdo0ttm3qf102','1790100182','','0','1','0' )
  5. SELECT *
      FROM glenrich_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM glenrich_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT oldurl, newurl
      FROM glenrich_redirection
      WHERE oldurl = 'kaminy/kaminnye-topki-ruegg.html'
      ORDER BY rank ASC
      LIMIT 1
  8. UPDATE glenrich_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'kaminy/kaminnye-topki-ruegg.html'
  9. SELECT m.*, c.`option` AS component
      FROM glenrich_menu AS m
      LEFT JOIN glenrich_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  10. SELECT m.*, c.`option` AS component
      FROM glenrich_menu AS m
      LEFT JOIN glenrich_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  11. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  12. SELECT glenrich_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `glenrich_vm_shopper_group`
      WHERE glenrich_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  13. 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 (`glenrich_vm_vendor` v, `glenrich_vm_country` c)
                                   
      LEFT JOIN glenrich_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`);
  14. SELECT module_perms
      FROM glenrich_vm_module
      WHERE module_name='shop'
  15. SELECT id
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  16. SELECT COUNT(*) AS parentcnt
      FROM glenrich_vm_product
      WHERE product_parent_id>0
  17. SELECT COUNT(DISTINCT `glenrich_vm_product`.`product_sku`) AS num_rows
      FROM (`glenrich_vm_product`, `glenrich_vm_category`, `glenrich_vm_product_category_xref`,`glenrich_vm_shopper_group`)
      LEFT JOIN `glenrich_vm_product_price`
      ON `glenrich_vm_product`.`product_id` = `glenrich_vm_product_price`.`product_id`
      WHERE `glenrich_vm_product_category_xref`.`product_id`=`glenrich_vm_product`.`product_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=`glenrich_vm_category`.`category_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=61
     
      AND ((`glenrich_vm_product`.`product_id`=`glenrich_vm_product_price`.`product_id`
      AND `glenrich_vm_shopper_group`.`shopper_group_id`=`glenrich_vm_product_price`.`shopper_group_id`) OR `glenrich_vm_product_price`.`product_id` IS NULL)
     
      AND `glenrich_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  18. SELECT category_id, category_name
      FROM glenrich_vm_category
      WHERE category_id='61'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='61'
  20. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM glenrich_vm_category,glenrich_vm_category_xref
      WHERE glenrich_vm_category_xref.category_parent_id='61'
      AND glenrich_vm_category.category_id=glenrich_vm_category_xref.category_child_id
      AND glenrich_vm_category.vendor_id='1'
      AND glenrich_vm_category.category_publish='Y'
      ORDER BY glenrich_vm_category.list_order, glenrich_vm_category.category_name ASC
  21. SELECT id, params
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  22. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=110&lang=ru&page=shop.browse'
  23. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  24. SELECT c.category_name, c.category_id, x.category_parent_id
      FROM glenrich_vm_category AS c
     
      LEFT JOIN glenrich_vm_category_xref AS x
      ON c.category_id = x.category_child_id;
  25. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=110&lang=ru&limitstart=0&page=shop.browse'
  26. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=112&lang=ru&page=shop.browse'
  27. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  28. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=112&lang=ru&limitstart=0&page=shop.browse'
  29. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=113&lang=ru&page=shop.browse'
  30. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  31. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=113&lang=ru&limitstart=0&page=shop.browse'
  32. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM glenrich_vm_category, glenrich_vm_category_xref
      WHERE glenrich_vm_category_xref.category_child_id='61'
      AND glenrich_vm_category.category_id='61'
  33. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM glenrich_vm_category, glenrich_vm_category_xref
      WHERE glenrich_vm_category_xref.category_child_id='1'
      AND glenrich_vm_category.category_id='1'
  34. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  35. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  36. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  37. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  38. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  39. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  40. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  41. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  42. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  43. SELECT DISTINCT `glenrich_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `glenrich_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`, `glenrich_vm_product`.`mdate`, `glenrich_vm_product`.`cdate`
      FROM (`glenrich_vm_product`, `glenrich_vm_category`, `glenrich_vm_product_category_xref`,`glenrich_vm_shopper_group`)
      LEFT JOIN `glenrich_vm_product_price`
      ON `glenrich_vm_product`.`product_id` = `glenrich_vm_product_price`.`product_id`
      WHERE `glenrich_vm_product_category_xref`.`product_id`=`glenrich_vm_product`.`product_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=`glenrich_vm_category`.`category_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=61
     
      AND ((`glenrich_vm_product`.`product_id`=`glenrich_vm_product_price`.`product_id`
      AND `glenrich_vm_shopper_group`.`shopper_group_id`=`glenrich_vm_product_price`.`shopper_group_id`) OR `glenrich_vm_product_price`.`product_id` IS NULL)
     
      AND `glenrich_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `glenrich_vm_product`.`product_sku`
     
      ORDER BY `glenrich_vm_product_category_xref`.`product_list` ASC
      LIMIT 12, 12
  44. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1121'
  45. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  46. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1121
  47. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1121'
  48. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1121'
  49. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1121
  50. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1121'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  51. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1121
  52. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  53. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1121'
  54. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  55. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  56. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  57. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  58. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  59. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1121'
  60. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1121
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1121
  63. SELECT `tax_rate`
      FROM glenrich_vm_vendor, glenrich_vm_tax_rate
      WHERE tax_country=vendor_country
      AND glenrich_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  64. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1121
      AND `file_is_image`=1
      AND `file_published`=1
  65. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1121
      AND `file_is_image`=0
  66. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1121'
  67. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=615'
  68. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  69. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 615
  70. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '615'
  71. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=615'
  72. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=615
  73. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='615'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  74. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=615
  75. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  76. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='615'
  77. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  78. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  80. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  81. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='615'
  82. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  83. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  84. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=615
  85. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=615
      AND `file_is_image`=1
      AND `file_published`=1
  86. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=615
      AND `file_is_image`=0
  87. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='615'
  88. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=616'
  89. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  90. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 616
  91. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '616'
  92. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=616'
  93. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=616
  94. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='616'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  95. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=616
  96. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  97. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='616'
  98. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  100. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  102. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='616'
  103. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  104. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=616
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  105. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=616
  106. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=616
      AND `file_is_image`=1
      AND `file_published`=1
  107. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=616
      AND `file_is_image`=0
  108. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='616'
  109. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=618'
  110. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  111. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 618
  112. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '618'
  113. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=618'
  114. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=618
  115. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='618'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=618
  117. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  118. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='618'
  119. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  120. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  121. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  122. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  123. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='618'
  124. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  125. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  126. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=618
  127. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=618
      AND `file_is_image`=1
      AND `file_published`=1
  128. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=618
      AND `file_is_image`=0
  129. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='618'
  130. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=619'
  131. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  132. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 619
  133. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '619'
  134. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=619'
  135. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=619
  136. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='619'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  137. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=619
  138. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='619'
  140. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  141. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  142. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  143. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  144. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='619'
  145. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  146. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  147. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=619
  148. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=619
      AND `file_is_image`=1
      AND `file_published`=1
  149. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=619
      AND `file_is_image`=0
  150. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='619'
  151. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=620'
  152. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  153. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 620
  154. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '620'
  155. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=620'
  156. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=620
  157. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='620'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  158. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=620
  159. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  160. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='620'
  161. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  162. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  163. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  164. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  165. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='620'
  166. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=620
  169. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=620
      AND `file_is_image`=1
      AND `file_published`=1
  170. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=620
      AND `file_is_image`=0
  171. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='620'
  172. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1125'
  173. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  174. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1125
  175. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1125'
  176. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1125'
  177. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1125
  178. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1125'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  179. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1125
  180. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100182' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  181. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1125'
  182. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  183. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  184. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  185. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  186. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1125'
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1125
  190. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1125
      AND `file_is_image`=1
      AND `file_published`=1
  191. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1125
  192. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  193. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1125
      AND `file_is_image`=0
  194. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1125'
  195. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=622'
  196. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  197. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 622
  198. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '622'
  199. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=622'
  200. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=622
  201. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='622'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=622
  203. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='622'
  205. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  206. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  209. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='622'
  210. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  211. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=622
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  212. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=622
  213. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=622
      AND `file_is_image`=1
      AND `file_published`=1
  214. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=622
      AND `file_is_image`=0
  215. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='622'
  216. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1124'
  217. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  218. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1124
  219. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1124'
  220. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1124'
  221. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1124
  222. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1124'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  223. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1124
  224. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  225. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1124'
  226. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  229. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  230. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1124'
  231. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1124
  234. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1124
      AND `file_is_image`=1
      AND `file_published`=1
  235. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1124
  236. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  237. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1124
      AND `file_is_image`=0
  238. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1124'
  239. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1126'
  240. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  241. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1126
  242. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1126'
  243. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1126'
  244. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1126
  245. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1126'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  246. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1126
  247. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  248. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1126'
  249. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  251. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  252. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  253. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1126'
  254. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  255. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1126
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  256. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1126
  257. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1126
      AND `file_is_image`=1
      AND `file_published`=1
  258. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1126
      AND `file_is_image`=0
  259. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1126'
  260. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=623'
  261. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  262. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 623
  263. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '623'
  264. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=623'
  265. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=623
  266. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='623'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=623
  268. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  269. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='623'
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  273. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  274. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='623'
  275. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  276. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=623
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  277. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=623
  278. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=623
      AND `file_is_image`=1
      AND `file_published`=1
  279. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=623
  280. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  281. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=623
      AND `file_is_image`=0
  282. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='623'
  283. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=624'
  284. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  285. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 624
  286. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '624'
  287. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=624'
  288. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=624
  289. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='624'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  290. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=624
  291. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  292. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='624'
  293. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  294. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  295. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  296. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  297. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='624'
  298. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  299. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=624
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  300. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=624
  301. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=624
      AND `file_is_image`=1
      AND `file_published`=1
  302. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=624
  303. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  304. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=624
      AND `file_is_image`=0
  305. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='624'
  306. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  307. SELECT DISTINCT product_sku,glenrich_vm_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
      FROM glenrich_vm_product, glenrich_vm_product_category_xref, glenrich_vm_category
      WHERE
    (glenrich_vm_product.product_parent_id='' OR glenrich_vm_product.product_parent_id='0')

      AND glenrich_vm_product.product_id=glenrich_vm_product_category_xref.product_id

      AND glenrich_vm_category.category_id=glenrich_vm_product_category_xref.category_id

      AND glenrich_vm_category.category_id='61'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  308. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='610'
  309. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=610
  310. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='610'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  311. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=610
  312. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  313. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='610'
  314. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=610
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  315. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=610
  316. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='610'
  317. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='598'
  318. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=598
  319. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='598'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=598
  321. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  322. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='598'
  323. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=598
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  324. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=598
  325. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='598'
  326. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='614'
  327. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=614
  328. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='614'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  329. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=614
  330. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790100183' OR start_date=0)
      AND (end_date>='1790033760' OR end_date=0)
      AND product_discount_id=discount_id
  331. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='614'
  332. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=614
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  333. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=614
  334. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='614'
  335. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=610'
  336. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  337. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  338. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  339. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=610'
  340. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=610'
  341. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  342. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  343. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  344. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=610'
  345. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=598'
  346. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  347. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 598
  348. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '598'
  349. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=598'
  350. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=598'
  351. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  352. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 598
  353. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '598'
  354. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=598'
  355. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=614'
  356. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  357. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 614
  358. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  359. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=614'
  360. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=614'
  361. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  362. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 614
  363. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  364. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=614'
  365. SELECT m.*, am.params AS adv_params
      FROM glenrich_modules AS m
      LEFT JOIN glenrich_advancedmodules AS am
      ON am.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      ORDER BY m.ordering, m.id
  366. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
  367. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  368. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
  369. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  370. SELECT published
      FROM glenrich_modules
      WHERE module='mod_virtuemart_cart'
  371. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=0
      AND a.category_publish='Y'
  372. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=0
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  373. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  374. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  375. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  376. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=1
      AND a.category_publish='Y'
  377. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=1
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  378. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=1
      AND a.category_publish='Y'
  379. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=1
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  380. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
  381. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  382. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=139
      AND a.category_publish='Y'
  383. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=164
      AND a.category_publish='Y'
  384. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=11
      AND a.category_publish='Y'
  385. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=12
      AND a.category_publish='Y'
  386. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=13
      AND a.category_publish='Y'
  387. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=162
      AND a.category_publish='Y'
  388. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=125
      AND a.category_publish='Y'
  389. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=14
      AND a.category_publish='Y'
  390. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=15
      AND a.category_publish='Y'
  391. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=24
      AND a.category_publish='Y'
  392. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=25
      AND a.category_publish='Y'
  393. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=56
      AND a.category_publish='Y'
  394. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
  395. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  396. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=88
      AND a.category_publish='Y'
  397. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=89
      AND a.category_publish='Y'
  398. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=90
      AND a.category_publish='Y'
  399. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=91
      AND a.category_publish='Y'
  400. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=93
      AND a.category_publish='Y'
  401. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=166
      AND a.category_publish='Y'
  402. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  403. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  404. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=110
      AND a.category_publish='Y'
  405. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=112
      AND a.category_publish='Y'
  406. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=113
      AND a.category_publish='Y'
  407. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
  408. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  409. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=120
      AND a.category_publish='Y'
  410. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=117
      AND a.category_publish='Y'
  411. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=119
      AND a.category_publish='Y'
  412. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=118
      AND a.category_publish='Y'
  413. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=167
      AND a.category_publish='Y'
  414. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=161
      AND a.category_publish='Y'
  415. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=1
      AND a.category_publish='Y'
  416. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=1
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  417. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&page=shop.browse'
  418. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  419. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&limitstart=0&page=shop.browse'
  420. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
  421. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=133
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  422. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
  423. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=133
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  424. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=139
      AND a.category_publish='Y'
  425. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=164
      AND a.category_publish='Y'
  426. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
  427. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  428. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
  429. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=11
      AND a.category_publish='Y'
  430. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=11
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  431. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=11
      AND a.category_publish='Y'
  432. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&page=shop.browse'
  433. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  434. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&limitstart=0&page=shop.browse'
  435. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=12
      AND a.category_publish='Y'
  436. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=12
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  437. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=12
      AND a.category_publish='Y'
  438. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&page=shop.browse'
  439. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  440. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&limitstart=0&page=shop.browse'
  441. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=13
      AND a.category_publish='Y'
  442. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=13
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  443. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=13
      AND a.category_publish='Y'
  444. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  445. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  446. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  447. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=162
      AND a.category_publish='Y'
  448. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=162
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  449. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=162
      AND a.category_publish='Y'
  450. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&page=shop.browse'
  451. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  452. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&limitstart=0&page=shop.browse'
  453. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=125
      AND a.category_publish='Y'
  454. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=125
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  455. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=125
      AND a.category_publish='Y'
  456. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&page=shop.browse'
  457. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  458. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&limitstart=0&page=shop.browse'
  459. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=14
      AND a.category_publish='Y'
  460. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=14
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  461. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=14
      AND a.category_publish='Y'
  462. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&page=shop.browse'
  463. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  464. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&limitstart=0&page=shop.browse'
  465. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=15
      AND a.category_publish='Y'
  466. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=15
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  467. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=15
      AND a.category_publish='Y'
  468. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&page=shop.browse'
  469. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  470. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&limitstart=0&page=shop.browse'
  471. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=24
      AND a.category_publish='Y'
  472. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=24
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  473. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=24
      AND a.category_publish='Y'
  474. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&page=shop.browse'
  475. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  476. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&limitstart=0&page=shop.browse'
  477. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=25
      AND a.category_publish='Y'
  478. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=25
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  479. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=25
      AND a.category_publish='Y'
  480. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&page=shop.browse'
  481. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  482. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&limitstart=0&page=shop.browse'
  483. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=56
      AND a.category_publish='Y'
  484. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=56
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  485. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=56
      AND a.category_publish='Y'
  486. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&page=shop.browse'
  487. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  488. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&limitstart=0&page=shop.browse'
  489. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
  490. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=60
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  491. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
  492. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=60
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  493. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=88
      AND a.category_publish='Y'
  494. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=89
      AND a.category_publish='Y'
  495. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=90
      AND a.category_publish='Y'
  496. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=91
      AND a.category_publish='Y'
  497. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=93
      AND a.category_publish='Y'
  498. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=166
      AND a.category_publish='Y'
  499. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  500. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  501. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  502. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  503. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=61
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  504. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  505. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  506. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=110
      AND a.category_publish='Y'
  507. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=112
      AND a.category_publish='Y'
  508. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=113
      AND a.category_publish='Y'
  509. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  510. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  511. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=110&lang=ru&page=shop.browse'
  512. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  513. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=110&lang=ru&limitstart=0&page=shop.browse'
  514. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=110
      AND a.category_publish='Y'
  515. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=110
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  516. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=110
      AND a.category_publish='Y'
  517. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=112&lang=ru&page=shop.browse'
  518. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  519. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=112&lang=ru&limitstart=0&page=shop.browse'
  520. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=112
      AND a.category_publish='Y'
  521. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=112
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  522. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=112
      AND a.category_publish='Y'
  523. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=113&lang=ru&page=shop.browse'
  524. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  525. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=113&lang=ru&limitstart=0&page=shop.browse'
  526. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=113
      AND a.category_publish='Y'
  527. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=113
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  528. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=113
      AND a.category_publish='Y'
  529. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  530. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  531. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  532. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
  533. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=62
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  534. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
  535. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  536. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=120
      AND a.category_publish='Y'
  537. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=117
      AND a.category_publish='Y'
  538. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=119
      AND a.category_publish='Y'
  539. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=118
      AND a.category_publish='Y'
  540. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=167
      AND a.category_publish='Y'
  541. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
  542. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  543. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
  544. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=161
      AND a.category_publish='Y'
  545. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=161
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  546. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=161
      AND a.category_publish='Y'
  547. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
  548. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  549. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
  550. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=2
      AND a.category_publish='Y'
  551. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=2
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  552. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=2
      AND a.category_publish='Y'
  553. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=2
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  554. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=132
      AND a.category_publish='Y'
  555. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=132
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  556. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=135
      AND a.category_publish='Y'
  557. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=136
      AND a.category_publish='Y'
  558. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=137
      AND a.category_publish='Y'
  559. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=145
      AND a.category_publish='Y'
  560. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=16
      AND a.category_publish='Y'
  561. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=17
      AND a.category_publish='Y'
  562. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=140
      AND a.category_publish='Y'
  563. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=140
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  564. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=141
      AND a.category_publish='Y'
  565. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=142
      AND a.category_publish='Y'
  566. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=143
      AND a.category_publish='Y'
  567. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=18
      AND a.category_publish='Y'
  568. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=19
      AND a.category_publish='Y'
  569. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=20
      AND a.category_publish='Y'
  570. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=22
      AND a.category_publish='Y'
  571. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=157
      AND a.category_publish='Y'
  572. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=157
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  573. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=158
      AND a.category_publish='Y'
  574. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=159
      AND a.category_publish='Y'
  575. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=23
      AND a.category_publish='Y'
  576. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=21
      AND a.category_publish='Y'
  577. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=144
      AND a.category_publish='Y'
  578. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=54
      AND a.category_publish='Y'
  579. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
  580. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  581. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
  582. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
  583. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=6
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  584. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
  585. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  586. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=40
      AND a.category_publish='Y'
  587. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=74
      AND a.category_publish='Y'
  588. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=42
      AND a.category_publish='Y'
  589. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=75
      AND a.category_publish='Y'
  590. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=43
      AND a.category_publish='Y'
  591. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=44
      AND a.category_publish='Y'
  592. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=41
      AND a.category_publish='Y'
  593. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
  594. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  595. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
  596. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=3
      AND a.category_publish='Y'
  597. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=3
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  598. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=3
      AND a.category_publish='Y'
  599. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=3
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  600. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=26
      AND a.category_publish='Y'
  601. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=27
      AND a.category_publish='Y'
  602. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=28
      AND a.category_publish='Y'
  603. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=29
      AND a.category_publish='Y'
  604. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=124
      AND a.category_publish='Y'
  605. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=30
      AND a.category_publish='Y'
  606. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=31
      AND a.category_publish='Y'
  607. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=163
      AND a.category_publish='Y'
  608. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
  609. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  610. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
  611. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=4
      AND a.category_publish='Y'
  612. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=4
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  613. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=4
      AND a.category_publish='Y'
  614. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=4
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  615. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=32
      AND a.category_publish='Y'
  616. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=33
      AND a.category_publish='Y'
  617. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
  618. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  619. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
  620. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=8
      AND a.category_publish='Y'
  621. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=8
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  622. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=8
      AND a.category_publish='Y'
  623. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=8
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  624. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=48
      AND a.category_publish='Y'
  625. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=48
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  626. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=94
      AND a.category_publish='Y'
  627. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=95
      AND a.category_publish='Y'
  628. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=96
      AND a.category_publish='Y'
  629. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=97
      AND a.category_publish='Y'
  630. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=103
      AND a.category_publish='Y'
  631. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=104
      AND a.category_publish='Y'
  632. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=168
      AND a.category_publish='Y'
  633. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=49
      AND a.category_publish='Y'
  634. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
  635. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  636. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
  637. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=9
      AND a.category_publish='Y'
  638. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=9
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  639. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=9
      AND a.category_publish='Y'
  640. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=9
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  641. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=50
      AND a.category_publish='Y'
  642. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=51
      AND a.category_publish='Y'
  643. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=51
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  644. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=126
      AND a.category_publish='Y'
  645. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=127
      AND a.category_publish='Y'
  646. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=128
      AND a.category_publish='Y'
  647. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=129
      AND a.category_publish='Y'
  648. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=130
      AND a.category_publish='Y'
  649. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
  650. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  651. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
  652. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=7
      AND a.category_publish='Y'
  653. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=7
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  654. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=7
      AND a.category_publish='Y'
  655. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=7
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  656. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=45
      AND a.category_publish='Y'
  657. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=46
      AND a.category_publish='Y'
  658. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=47
      AND a.category_publish='Y'
  659. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=57
      AND a.category_publish='Y'
  660. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=58
      AND a.category_publish='Y'
  661. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=59
      AND a.category_publish='Y'
  662. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
  663. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  664. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
  665. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=169
      AND a.category_publish='Y'
  666. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=169
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  667. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=169
      AND a.category_publish='Y'
  668. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
  669. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  670. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
  671. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=170
      AND a.category_publish='Y'
  672. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=170
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  673. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=170
      AND a.category_publish='Y'
  674. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=170
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  675. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=171
      AND a.category_publish='Y'
  676. SELECT params
      FROM glenrich_advancedmodules
      WHERE moduleid = 41
  677. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
  678. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  679. SELECT name, link,id
      FROM glenrich_menu
      WHERE id = '8'
      AND published='1'
  680. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
  681. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  682. SELECT c.category_name, c.category_id, c.category_description, x.category_parent_id
      FROM glenrich_vm_category AS c
     
      LEFT JOIN glenrich_vm_category_xref AS x
      ON c.category_id = x.category_child_id;
  683. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=12&page=shop.browse'

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

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

Нет

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

Нет