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

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


Каминные топки SPARTHERM Arte Каминные топки SPARTHERM Mini
Каминные топки SPARTHERM Speedy Каминные топки SPARTHERM Varia
Каминные топки SPARTHERM Premium

Топка Speedy Ph
Артикул Speedy Ph
Ширина 523 мм.
Высота 1422 мм.
Глубина 538 мм.
Вес 190 кг.

Полукруглая каминная топка, размер по дверце В57 х Ш52 см, производство Германия.

Подробнее
Топка Arte 2LRh-66
Артикул Arte 2LRh-66
Ширина 474 мм.
Высота 1604 мм.
Глубина 474 мм.
Вес 186 кг.

Угловая каминная топка, размер по дверце В66 х Ш36/36 см, производство Германия.

Подробнее
Топка Arte 3RL-80h
Артикул Arte 3R-L80h
Ширина 809 мм.
Высота 1560 мм.
Глубина 536 мм.
Вес 1560 кг.

Панорамная каминная топка, размер по дверце В57 х Ш40/80/40 см, производство Германия.

Подробнее
Топка Arte 3RL-60h
Артикул Arte 3RL-60h
Ширина 608 мм.
Высота 1557 мм.
Глубина 493 мм.
Вес 281 кг.

Панорамная каминная топка, размер по дверце В57 х Ш37/60/37 см, производство Германия.

Подробнее
Топка Speedy K
Артикул Speedy K
Ширина 686 мм.
Высота 1313 мм.
Глубина 520 мм.
Вес 190 кг.

Призматическая каминная топка, размер по дверце В51/57 х Ш67 см, производство Германия.

Подробнее
Топка Speedy Kh
Артикул Speedy Kh
Ширина 754 мм.
Высота 1478 мм.
Глубина 525 мм.
Вес 220 кг.

Призматическая каминная топка, размер по дверце В51/57 х Ш68 см, производство Германия.

Подробнее
Топка Speedy M
Артикул Speedy M
Ширина 586 мм.
Высота 1253 мм.
Глубина 480 мм.
Вес 129 кг.

Призматическая каминная топка, размер по дверце В51/57 х Ш54 см, производство Германия.

Подробнее
Топка Speedy Mh
Артикул Speedy Mh
Ширина 642 мм.
Высота 1478 мм.
Глубина 485 мм.
Вес 159 кг.

Призматическая каминная топка, размер по дверце В51/57 х Ш55 см, производство Германия.

Подробнее
Топка Speedy MDRh
Артикул Speedy MDRh
Ширина 668 мм.
Высота 1589 мм.
Глубина 665 мм.
Вес 300 кг.

Полукруглая каминная топка, размер по дверце В57 х Ш66 см, производство Германия.

Подробнее
Топка Speedy MR
Артикул Speedy MR
Ширина 550 мм.
Высота 1355 мм.
Глубина 552 мм.
Вес 200 кг.

Полукруглая каминная топка, размер по дверце В51/57 х Ш55 см, производство Германия.

Подробнее
Топка Speedy MRh
Артикул Speedy MRh
Ширина 622 мм.
Высота 1482 мм.
Глубина 601 мм.
Вес 240 кг.

Полукруглая каминная топка, размер по дверце В51/57 х Ш62 см, производство Германия.

Подробнее
Топка Speedy R
Артикул Speedy R
Ширина 686 мм.
Высота 1313 мм.
Глубина 576 мм.
Вес 173 кг.

Полукруглая каминная топка, размер по дверце В51/57 х Ш67 см, производство Германия.

Подробнее

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

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

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

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



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

Application afterLoad: 0.000 seconds, 0.45 MB
Application afterInitialise: 0.042 seconds, 5.41 MB
Application afterRoute: 0.079 seconds, 9.03 MB
Application afterDispatch: 0.575 seconds, 21.94 MB
Application afterRender: 0.785 seconds, 24.30 MB

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

25813728

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'rr6g4232aibo5a0oilsfeoi346'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1780071200' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'rr6g4232aibo5a0oilsfeoi346'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'rr6g4232aibo5a0oilsfeoi346','1780074800','','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-spartherm.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=62&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'kaminy/kaminnye-topki-spartherm.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`=62
     
      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='62'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='62'
  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='62'
      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=120&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=120&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=117&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=117&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=119&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=119&lang=ru&limitstart=0&page=shop.browse'
  32. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&page=shop.browse'
  33. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  34. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&limitstart=0&page=shop.browse'
  35. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=167&lang=ru&page=shop.browse'
  36. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  37. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=167&lang=ru&limitstart=0&page=shop.browse'
  38. 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='62'
      AND glenrich_vm_category.category_id='62'
  39. 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'
  40. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&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=1&lang=ru&limitstart=0&page=shop.browse'
  43. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  44. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  45. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  46. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  47. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  48. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  49. 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`=62
     
      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 36, 12
  50. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1159'
  51. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  52. 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 = 1159
  53. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1159'
  54. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1159'
  55. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1159
  56. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1159'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  57. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1159
  58. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  59. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1159'
  60. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1159'
  66. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  68. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1159
  69. 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
  70. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1159
      AND `file_is_image`=1
      AND `file_published`=1
  71. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1159
      AND `file_is_image`=0
  72. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1159'
  73. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1382'
  74. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  75. 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 = 1382
  76. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1382'
  77. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1382'
  78. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1382
  79. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1382'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  80. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1382
  81. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1382'
  83. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  84. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  85. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  86. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  87. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1382'
  88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  89. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  90. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1382
  91. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1382
      AND `file_is_image`=1
      AND `file_published`=1
  92. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1382
      AND `file_is_image`=0
  93. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1382'
  94. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1129'
  95. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  96. 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 = 1129
  97. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1129'
  98. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1129'
  99. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1129
  100. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1129'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1129
  102. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  103. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1129'
  104. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  105. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  106. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  107. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  108. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1129'
  109. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  110. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  111. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1129
  112. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1129
      AND `file_is_image`=1
      AND `file_published`=1
  113. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1129
      AND `file_is_image`=0
  114. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1129'
  115. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1128'
  116. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  117. 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 = 1128
  118. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1128'
  119. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1128'
  120. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1128
  121. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1128'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  122. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1128
  123. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  124. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1128'
  125. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  126. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  127. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  128. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  129. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1128'
  130. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  131. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  132. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1128
  133. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1128
      AND `file_is_image`=1
      AND `file_published`=1
  134. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1128
      AND `file_is_image`=0
  135. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1128'
  136. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1098'
  137. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  138. 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 = 1098
  139. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1098'
  140. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1098'
  141. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1098
  142. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1098'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  143. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1098
  144. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1098'
  146. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  147. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  148. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  149. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  150. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1098'
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1098
  154. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1098
      AND `file_is_image`=1
      AND `file_published`=1
  155. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1098
      AND `file_is_image`=0
  156. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1098'
  157. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1099'
  158. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  159. 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 = 1099
  160. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1099'
  161. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1099'
  162. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1099
  163. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1099'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1099
  165. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1099'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  170. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  171. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1099'
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  173. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  174. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1099
  175. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1099
      AND `file_is_image`=1
      AND `file_published`=1
  176. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1099
      AND `file_is_image`=0
  177. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1099'
  178. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1100'
  179. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  180. 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 = 1100
  181. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1100'
  182. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1100'
  183. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1100
  184. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1100'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1100
  186. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  187. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1100'
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  190. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  191. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  192. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1100'
  193. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  194. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  195. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1100
  196. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1100
      AND `file_is_image`=1
      AND `file_published`=1
  197. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1100
      AND `file_is_image`=0
  198. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1100'
  199. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1101'
  200. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  201. 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 = 1101
  202. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1101'
  203. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1101'
  204. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1101
  205. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1101'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1101
  207. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  208. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1101'
  209. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1101
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  210. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1101
      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=1101
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1101
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1101'
  214. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1101
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  215. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1101
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  216. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1101
  217. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1101
      AND `file_is_image`=1
      AND `file_published`=1
  218. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1101
      AND `file_is_image`=0
  219. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1101'
  220. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1102'
  221. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  222. 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 = 1102
  223. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1102'
  224. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1102'
  225. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1102
  226. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1102'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  227. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1102
  228. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  229. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1102'
  230. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1102
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1102
      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=1102
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1102
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  234. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1102'
  235. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1102
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  236. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1102
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  237. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1102
  238. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1102
      AND `file_is_image`=1
      AND `file_published`=1
  239. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1102
      AND `file_is_image`=0
  240. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1102'
  241. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1103'
  242. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  243. 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 = 1103
  244. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1103'
  245. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1103'
  246. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1103
  247. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1103'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  248. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1103
  249. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  250. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1103'
  251. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1103
      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=1103
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  253. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1103
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  254. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1103
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  255. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1103'
  256. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1103
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  257. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1103
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  258. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1103
  259. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1103
      AND `file_is_image`=1
      AND `file_published`=1
  260. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1103
      AND `file_is_image`=0
  261. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1103'
  262. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1104'
  263. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  264. 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 = 1104
  265. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1104'
  266. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1104'
  267. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1104
  268. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1104'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  269. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1104
  270. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  271. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1104'
  272. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1104
      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=1104
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  274. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1104
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  275. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1104
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  276. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1104'
  277. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1104
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  278. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1104
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  279. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1104
  280. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1104
      AND `file_is_image`=1
      AND `file_published`=1
  281. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1104
      AND `file_is_image`=0
  282. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1104'
  283. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1105'
  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 = 1105
  286. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1105'
  287. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1105'
  288. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1105
  289. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1105'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  290. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1105
  291. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  292. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1105'
  293. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1105
      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=1105
      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=1105
      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=1105
      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='1105'
  298. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1105
      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=1105
      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=1105
  301. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1105
      AND `file_is_image`=1
      AND `file_published`=1
  302. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1105
      AND `file_is_image`=0
  303. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1105'
  304. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  305. 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='62'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  306. 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
  307. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
  308. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  309. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
  310. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  311. SELECT published
      FROM glenrich_modules
      WHERE module='mod_virtuemart_cart'
  312. SELECT COUNT(*)
      FROM 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'
  313. 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
  314. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  315. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  316. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  317. SELECT COUNT(*)
      FROM 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'
  318. 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'
  319. SELECT COUNT(*)
      FROM 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'
  320. 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
  321. SELECT COUNT(*)
      FROM 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'
  322. 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
  323. SELECT COUNT(*)
      FROM 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'
  324. SELECT COUNT(*)
      FROM 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'
  325. SELECT COUNT(*)
      FROM 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'
  326. SELECT COUNT(*)
      FROM 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'
  327. SELECT COUNT(*)
      FROM 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'
  328. SELECT COUNT(*)
      FROM 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'
  329. SELECT COUNT(*)
      FROM 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'
  330. SELECT COUNT(*)
      FROM 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'
  331. SELECT COUNT(*)
      FROM 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'
  332. SELECT COUNT(*)
      FROM 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'
  333. SELECT COUNT(*)
      FROM 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'
  334. SELECT COUNT(*)
      FROM 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'
  335. SELECT COUNT(*)
      FROM 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'
  336. 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
  337. SELECT COUNT(*)
      FROM 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'
  338. SELECT COUNT(*)
      FROM 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'
  339. SELECT COUNT(*)
      FROM 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'
  340. SELECT COUNT(*)
      FROM 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'
  341. SELECT COUNT(*)
      FROM 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'
  342. SELECT COUNT(*)
      FROM 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'
  343. SELECT COUNT(*)
      FROM 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'
  344. 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
  345. SELECT COUNT(*)
      FROM 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'
  346. SELECT COUNT(*)
      FROM 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'
  347. SELECT COUNT(*)
      FROM 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'
  348. SELECT COUNT(*)
      FROM 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'
  349. 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
  350. SELECT COUNT(*)
      FROM 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'
  351. SELECT COUNT(*)
      FROM 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'
  352. SELECT COUNT(*)
      FROM 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'
  353. SELECT COUNT(*)
      FROM 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'
  354. SELECT COUNT(*)
      FROM 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'
  355. SELECT COUNT(*)
      FROM 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'
  356. SELECT COUNT(*)
      FROM 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'
  357. 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
  358. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&page=shop.browse'
  359. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  360. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&limitstart=0&page=shop.browse'
  361. SELECT COUNT(*)
      FROM 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'
  362. 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'
  363. SELECT COUNT(*)
      FROM 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'
  364. 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
  365. SELECT COUNT(*)
      FROM 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'
  366. SELECT COUNT(*)
      FROM 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'
  367. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
  368. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  369. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
  370. SELECT COUNT(*)
      FROM 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'
  371. 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'
  372. SELECT COUNT(*)
      FROM 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'
  373. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&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=12&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=12
      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=12
      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=12
      AND a.category_publish='Y'
  379. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&page=shop.browse'
  380. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  381. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&limitstart=0&page=shop.browse'
  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=13
      AND a.category_publish='Y'
  383. 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'
  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=13
      AND a.category_publish='Y'
  385. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  386. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  387. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  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=162
      AND a.category_publish='Y'
  389. 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'
  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=162
      AND a.category_publish='Y'
  391. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&page=shop.browse'
  392. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  393. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&limitstart=0&page=shop.browse'
  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=125
      AND a.category_publish='Y'
  395. 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'
  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=125
      AND a.category_publish='Y'
  397. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&page=shop.browse'
  398. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  399. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&limitstart=0&page=shop.browse'
  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=14
      AND a.category_publish='Y'
  401. 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'
  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=14
      AND a.category_publish='Y'
  403. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&page=shop.browse'
  404. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  405. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&limitstart=0&page=shop.browse'
  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=15
      AND a.category_publish='Y'
  407. 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'
  408. SELECT COUNT(*)
      FROM 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'
  409. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&page=shop.browse'
  410. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  411. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&limitstart=0&page=shop.browse'
  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=24
      AND a.category_publish='Y'
  413. 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'
  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=24
      AND a.category_publish='Y'
  415. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&page=shop.browse'
  416. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  417. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&limitstart=0&page=shop.browse'
  418. SELECT COUNT(*)
      FROM 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'
  419. 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'
  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=25
      AND a.category_publish='Y'
  421. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&page=shop.browse'
  422. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  423. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&limitstart=0&page=shop.browse'
  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=56
      AND a.category_publish='Y'
  425. 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'
  426. SELECT COUNT(*)
      FROM 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'
  427. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&page=shop.browse'
  428. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  429. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&limitstart=0&page=shop.browse'
  430. SELECT COUNT(*)
      FROM 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'
  431. 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'
  432. SELECT COUNT(*)
      FROM 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'
  433. 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
  434. SELECT COUNT(*)
      FROM 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'
  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=89
      AND a.category_publish='Y'
  436. SELECT COUNT(*)
      FROM 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'
  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=91
      AND a.category_publish='Y'
  438. SELECT COUNT(*)
      FROM 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'
  439. SELECT COUNT(*)
      FROM 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'
  440. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  441. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  442. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  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=61
      AND a.category_publish='Y'
  444. 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'
  445. SELECT COUNT(*)
      FROM 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'
  446. 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
  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=110
      AND a.category_publish='Y'
  448. SELECT COUNT(*)
      FROM 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'
  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=113
      AND a.category_publish='Y'
  450. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&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=62&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=62
      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=62
      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=62
      AND a.category_publish='Y'
  456. 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
  457. SELECT COUNT(*)
      FROM 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'
  458. SELECT COUNT(*)
      FROM 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'
  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=119
      AND a.category_publish='Y'
  460. SELECT COUNT(*)
      FROM 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'
  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=167
      AND a.category_publish='Y'
  462. SELECT COUNT(*)
      FROM 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'
  463. 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
  464. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=120&lang=ru&page=shop.browse'
  465. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  466. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=120&lang=ru&limitstart=0&page=shop.browse'
  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=120
      AND a.category_publish='Y'
  468. 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=120
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  469. SELECT COUNT(*)
      FROM 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'
  470. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=117&lang=ru&page=shop.browse'
  471. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  472. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=117&lang=ru&limitstart=0&page=shop.browse'
  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=117
      AND a.category_publish='Y'
  474. 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=117
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  475. SELECT COUNT(*)
      FROM 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'
  476. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=119&lang=ru&page=shop.browse'
  477. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  478. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=119&lang=ru&limitstart=0&page=shop.browse'
  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=119
      AND a.category_publish='Y'
  480. 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=119
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  481. SELECT COUNT(*)
      FROM 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'
  482. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&page=shop.browse'
  483. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  484. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&limitstart=0&page=shop.browse'
  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=118
      AND a.category_publish='Y'
  486. 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=118
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  487. SELECT COUNT(*)
      FROM 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'
  488. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=167&lang=ru&page=shop.browse'
  489. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  490. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=167&lang=ru&limitstart=0&page=shop.browse'
  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=167
      AND a.category_publish='Y'
  492. 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=167
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  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=167
      AND a.category_publish='Y'
  494. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
  495. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  496. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
  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=161
      AND a.category_publish='Y'
  498. 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'
  499. SELECT COUNT(*)
      FROM 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'
  500. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
  501. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  502. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
  503. SELECT COUNT(*)
      FROM 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'
  504. 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'
  505. SELECT COUNT(*)
      FROM 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'
  506. 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
  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=132
      AND a.category_publish='Y'
  508. 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
  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=135
      AND a.category_publish='Y'
  510. SELECT COUNT(*)
      FROM 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'
  511. SELECT COUNT(*)
      FROM 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'
  512. SELECT COUNT(*)
      FROM 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'
  513. SELECT COUNT(*)
      FROM 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'
  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=17
      AND a.category_publish='Y'
  515. SELECT COUNT(*)
      FROM 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'
  516. 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
  517. SELECT COUNT(*)
      FROM 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'
  518. SELECT COUNT(*)
      FROM 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'
  519. SELECT COUNT(*)
      FROM 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'
  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=18
      AND a.category_publish='Y'
  521. SELECT COUNT(*)
      FROM 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'
  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=20
      AND a.category_publish='Y'
  523. SELECT COUNT(*)
      FROM 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'
  524. SELECT COUNT(*)
      FROM 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'
  525. 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
  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=158
      AND a.category_publish='Y'
  527. SELECT COUNT(*)
      FROM 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'
  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=23
      AND a.category_publish='Y'
  529. SELECT COUNT(*)
      FROM 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'
  530. SELECT COUNT(*)
      FROM 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'
  531. SELECT COUNT(*)
      FROM 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'
  532. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
  533. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  534. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
  535. SELECT COUNT(*)
      FROM 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'
  536. 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'
  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=6
      AND a.category_publish='Y'
  538. 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
  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=40
      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=74
      AND a.category_publish='Y'
  541. SELECT COUNT(*)
      FROM 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'
  542. SELECT COUNT(*)
      FROM 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'
  543. SELECT COUNT(*)
      FROM 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'
  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=44
      AND a.category_publish='Y'
  545. SELECT COUNT(*)
      FROM 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'
  546. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
  547. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  548. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
  549. SELECT COUNT(*)
      FROM 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'
  550. 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'
  551. SELECT COUNT(*)
      FROM 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'
  552. 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
  553. SELECT COUNT(*)
      FROM 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'
  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=27
      AND a.category_publish='Y'
  555. SELECT COUNT(*)
      FROM 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'
  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=29
      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=124
      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=30
      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=31
      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=163
      AND a.category_publish='Y'
  561. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
  562. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  563. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
  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=4
      AND a.category_publish='Y'
  565. 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'
  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=4
      AND a.category_publish='Y'
  567. 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
  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=32
      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=33
      AND a.category_publish='Y'
  570. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
  571. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  572. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
  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=8
      AND a.category_publish='Y'
  574. 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'
  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=8
      AND a.category_publish='Y'
  576. 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
  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=48
      AND a.category_publish='Y'
  578. 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
  579. SELECT COUNT(*)
      FROM 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'
  580. SELECT COUNT(*)
      FROM 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'
  581. SELECT COUNT(*)
      FROM 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'
  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=97
      AND a.category_publish='Y'
  583. SELECT COUNT(*)
      FROM 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'
  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=104
      AND a.category_publish='Y'
  585. SELECT COUNT(*)
      FROM 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'
  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=49
      AND a.category_publish='Y'
  587. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
  588. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  589. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
  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=9
      AND a.category_publish='Y'
  591. 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'
  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=9
      AND a.category_publish='Y'
  593. 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
  594. SELECT COUNT(*)
      FROM 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'
  595. SELECT COUNT(*)
      FROM 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'
  596. 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
  597. SELECT COUNT(*)
      FROM 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'
  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=127
      AND a.category_publish='Y'
  599. SELECT COUNT(*)
      FROM 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'
  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=129
      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=130
      AND a.category_publish='Y'
  602. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
  603. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  604. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
  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=7
      AND a.category_publish='Y'
  606. 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'
  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=7
      AND a.category_publish='Y'
  608. 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
  609. SELECT COUNT(*)
      FROM 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'
  610. SELECT COUNT(*)
      FROM 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'
  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=47
      AND a.category_publish='Y'
  612. SELECT COUNT(*)
      FROM 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'
  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=58
      AND a.category_publish='Y'
  614. SELECT COUNT(*)
      FROM 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'
  615. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
  616. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  617. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
  618. SELECT COUNT(*)
      FROM 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'
  619. 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'
  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=169
      AND a.category_publish='Y'
  621. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
  622. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  623. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
  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=170
      AND a.category_publish='Y'
  625. 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'
  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=170
      AND a.category_publish='Y'
  627. 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
  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=171
      AND a.category_publish='Y'
  629. SELECT params
      FROM glenrich_advancedmodules
      WHERE moduleid = 41
  630. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
  631. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  632. SELECT name, link,id
      FROM glenrich_menu
      WHERE id = '8'
      AND published='1'
  633. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
  634. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  635. 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;
  636. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=36&page=shop.browse'

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'rr6g4232aibo5a0oilsfeoi346'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1780071200' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'rr6g4232aibo5a0oilsfeoi346'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'rr6g4232aibo5a0oilsfeoi346','1780074800','','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-spartherm.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=62&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'kaminy/kaminnye-topki-spartherm.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`=62
     
      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='62'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='62'
  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='62'
      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=120&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=120&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=117&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=117&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=119&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=119&lang=ru&limitstart=0&page=shop.browse'
  32. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&page=shop.browse'
  33. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  34. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&limitstart=0&page=shop.browse'
  35. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=167&lang=ru&page=shop.browse'
  36. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  37. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=167&lang=ru&limitstart=0&page=shop.browse'
  38. 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='62'
      AND glenrich_vm_category.category_id='62'
  39. 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'
  40. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&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=1&lang=ru&limitstart=0&page=shop.browse'
  43. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  44. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  45. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  46. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  47. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  48. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  49. 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`=62
     
      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 36, 12
  50. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1159'
  51. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  52. 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 = 1159
  53. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1159'
  54. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1159'
  55. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1159
  56. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1159'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  57. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1159
  58. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  59. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1159'
  60. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1159'
  66. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  68. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1159
  69. 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
  70. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1159
      AND `file_is_image`=1
      AND `file_published`=1
  71. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1159
      AND `file_is_image`=0
  72. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1159'
  73. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1382'
  74. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  75. 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 = 1382
  76. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1382'
  77. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1382'
  78. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1382
  79. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1382'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  80. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1382
  81. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1382'
  83. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  84. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  85. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  86. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  87. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1382'
  88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  89. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1382
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  90. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1382
  91. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1382
      AND `file_is_image`=1
      AND `file_published`=1
  92. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1382
      AND `file_is_image`=0
  93. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1382'
  94. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1129'
  95. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  96. 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 = 1129
  97. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1129'
  98. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1129'
  99. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1129
  100. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1129'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1129
  102. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  103. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1129'
  104. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  105. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  106. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  107. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  108. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1129'
  109. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  110. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1129
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  111. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1129
  112. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1129
      AND `file_is_image`=1
      AND `file_published`=1
  113. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1129
      AND `file_is_image`=0
  114. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1129'
  115. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1128'
  116. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  117. 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 = 1128
  118. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1128'
  119. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1128'
  120. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1128
  121. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1128'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  122. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1128
  123. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  124. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1128'
  125. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  126. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  127. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  128. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  129. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1128'
  130. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  131. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  132. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1128
  133. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1128
      AND `file_is_image`=1
      AND `file_published`=1
  134. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1128
      AND `file_is_image`=0
  135. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1128'
  136. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1098'
  137. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  138. 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 = 1098
  139. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1098'
  140. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1098'
  141. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1098
  142. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1098'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  143. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1098
  144. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1098'
  146. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  147. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  148. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  149. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  150. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1098'
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1098
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1098
  154. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1098
      AND `file_is_image`=1
      AND `file_published`=1
  155. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1098
      AND `file_is_image`=0
  156. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1098'
  157. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1099'
  158. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  159. 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 = 1099
  160. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1099'
  161. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1099'
  162. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1099
  163. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1099'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1099
  165. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1099'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  170. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  171. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1099'
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  173. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  174. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1099
  175. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1099
      AND `file_is_image`=1
      AND `file_published`=1
  176. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1099
      AND `file_is_image`=0
  177. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1099'
  178. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1100'
  179. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  180. 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 = 1100
  181. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1100'
  182. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1100'
  183. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1100
  184. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1100'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1100
  186. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  187. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1100'
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  190. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  191. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  192. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1100'
  193. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  194. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1100
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  195. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1100
  196. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1100
      AND `file_is_image`=1
      AND `file_published`=1
  197. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1100
      AND `file_is_image`=0
  198. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1100'
  199. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1101'
  200. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  201. 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 = 1101
  202. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1101'
  203. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1101'
  204. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1101
  205. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1101'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1101
  207. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  208. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1101'
  209. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1101
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  210. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1101
      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=1101
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1101
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1101'
  214. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1101
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  215. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1101
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  216. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1101
  217. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1101
      AND `file_is_image`=1
      AND `file_published`=1
  218. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1101
      AND `file_is_image`=0
  219. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1101'
  220. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1102'
  221. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  222. 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 = 1102
  223. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1102'
  224. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1102'
  225. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1102
  226. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1102'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  227. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1102
  228. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  229. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1102'
  230. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1102
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1102
      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=1102
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1102
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  234. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1102'
  235. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1102
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  236. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1102
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  237. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1102
  238. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1102
      AND `file_is_image`=1
      AND `file_published`=1
  239. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1102
      AND `file_is_image`=0
  240. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1102'
  241. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1103'
  242. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  243. 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 = 1103
  244. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1103'
  245. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1103'
  246. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1103
  247. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1103'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  248. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1103
  249. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  250. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1103'
  251. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1103
      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=1103
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  253. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1103
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  254. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1103
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  255. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1103'
  256. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1103
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  257. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1103
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  258. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1103
  259. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1103
      AND `file_is_image`=1
      AND `file_published`=1
  260. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1103
      AND `file_is_image`=0
  261. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1103'
  262. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1104'
  263. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  264. 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 = 1104
  265. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1104'
  266. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1104'
  267. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1104
  268. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1104'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  269. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1104
  270. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  271. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1104'
  272. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1104
      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=1104
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  274. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1104
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  275. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1104
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  276. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1104'
  277. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1104
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  278. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1104
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  279. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1104
  280. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1104
      AND `file_is_image`=1
      AND `file_published`=1
  281. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1104
      AND `file_is_image`=0
  282. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1104'
  283. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1105'
  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 = 1105
  286. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1105'
  287. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1105'
  288. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1105
  289. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1105'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  290. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1105
  291. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1780074800' OR start_date=0)
      AND (end_date>='1780011360' OR end_date=0)
      AND product_discount_id=discount_id
  292. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1105'
  293. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1105
      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=1105
      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=1105
      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=1105
      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='1105'
  298. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1105
      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=1105
      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=1105
  301. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1105
      AND `file_is_image`=1
      AND `file_published`=1
  302. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1105
      AND `file_is_image`=0
  303. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1105'
  304. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  305. 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='62'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  306. 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
  307. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
  308. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  309. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
  310. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  311. SELECT published
      FROM glenrich_modules
      WHERE module='mod_virtuemart_cart'
  312. SELECT COUNT(*)
      FROM 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'
  313. 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
  314. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  315. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  316. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  317. SELECT COUNT(*)
      FROM 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'
  318. 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'
  319. SELECT COUNT(*)
      FROM 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'
  320. 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
  321. SELECT COUNT(*)
      FROM 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'
  322. 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
  323. SELECT COUNT(*)
      FROM 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'
  324. SELECT COUNT(*)
      FROM 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'
  325. SELECT COUNT(*)
      FROM 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'
  326. SELECT COUNT(*)
      FROM 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'
  327. SELECT COUNT(*)
      FROM 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'
  328. SELECT COUNT(*)
      FROM 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'
  329. SELECT COUNT(*)
      FROM 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'
  330. SELECT COUNT(*)
      FROM 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'
  331. SELECT COUNT(*)
      FROM 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'
  332. SELECT COUNT(*)
      FROM 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'
  333. SELECT COUNT(*)
      FROM 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'
  334. SELECT COUNT(*)
      FROM 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'
  335. SELECT COUNT(*)
      FROM 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'
  336. 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
  337. SELECT COUNT(*)
      FROM 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'
  338. SELECT COUNT(*)
      FROM 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'
  339. SELECT COUNT(*)
      FROM 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'
  340. SELECT COUNT(*)
      FROM 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'
  341. SELECT COUNT(*)
      FROM 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'
  342. SELECT COUNT(*)
      FROM 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'
  343. SELECT COUNT(*)
      FROM 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'
  344. 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
  345. SELECT COUNT(*)
      FROM 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'
  346. SELECT COUNT(*)
      FROM 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'
  347. SELECT COUNT(*)
      FROM 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'
  348. SELECT COUNT(*)
      FROM 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'
  349. 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
  350. SELECT COUNT(*)
      FROM 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'
  351. SELECT COUNT(*)
      FROM 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'
  352. SELECT COUNT(*)
      FROM 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'
  353. SELECT COUNT(*)
      FROM 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'
  354. SELECT COUNT(*)
      FROM 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'
  355. SELECT COUNT(*)
      FROM 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'
  356. SELECT COUNT(*)
      FROM 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'
  357. 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
  358. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&page=shop.browse'
  359. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  360. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&limitstart=0&page=shop.browse'
  361. SELECT COUNT(*)
      FROM 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'
  362. 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'
  363. SELECT COUNT(*)
      FROM 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'
  364. 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
  365. SELECT COUNT(*)
      FROM 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'
  366. SELECT COUNT(*)
      FROM 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'
  367. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
  368. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  369. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
  370. SELECT COUNT(*)
      FROM 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'
  371. 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'
  372. SELECT COUNT(*)
      FROM 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'
  373. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&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=12&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=12
      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=12
      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=12
      AND a.category_publish='Y'
  379. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&page=shop.browse'
  380. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  381. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&limitstart=0&page=shop.browse'
  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=13
      AND a.category_publish='Y'
  383. 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'
  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=13
      AND a.category_publish='Y'
  385. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  386. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  387. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  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=162
      AND a.category_publish='Y'
  389. 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'
  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=162
      AND a.category_publish='Y'
  391. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&page=shop.browse'
  392. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  393. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&limitstart=0&page=shop.browse'
  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=125
      AND a.category_publish='Y'
  395. 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'
  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=125
      AND a.category_publish='Y'
  397. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&page=shop.browse'
  398. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  399. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&limitstart=0&page=shop.browse'
  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=14
      AND a.category_publish='Y'
  401. 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'
  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=14
      AND a.category_publish='Y'
  403. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&page=shop.browse'
  404. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  405. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&limitstart=0&page=shop.browse'
  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=15
      AND a.category_publish='Y'
  407. 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'
  408. SELECT COUNT(*)
      FROM 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'
  409. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&page=shop.browse'
  410. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  411. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&limitstart=0&page=shop.browse'
  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=24
      AND a.category_publish='Y'
  413. 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'
  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=24
      AND a.category_publish='Y'
  415. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&page=shop.browse'
  416. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  417. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&limitstart=0&page=shop.browse'
  418. SELECT COUNT(*)
      FROM 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'
  419. 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'
  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=25
      AND a.category_publish='Y'
  421. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&page=shop.browse'
  422. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  423. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&limitstart=0&page=shop.browse'
  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=56
      AND a.category_publish='Y'
  425. 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'
  426. SELECT COUNT(*)
      FROM 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'
  427. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&page=shop.browse'
  428. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  429. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&limitstart=0&page=shop.browse'
  430. SELECT COUNT(*)
      FROM 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'
  431. 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'
  432. SELECT COUNT(*)
      FROM 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'
  433. 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
  434. SELECT COUNT(*)
      FROM 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'
  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=89
      AND a.category_publish='Y'
  436. SELECT COUNT(*)
      FROM 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'
  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=91
      AND a.category_publish='Y'
  438. SELECT COUNT(*)
      FROM 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'
  439. SELECT COUNT(*)
      FROM 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'
  440. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  441. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  442. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  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=61
      AND a.category_publish='Y'
  444. 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'
  445. SELECT COUNT(*)
      FROM 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'
  446. 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
  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=110
      AND a.category_publish='Y'
  448. SELECT COUNT(*)
      FROM 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'
  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=113
      AND a.category_publish='Y'
  450. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&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=62&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=62
      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=62
      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=62
      AND a.category_publish='Y'
  456. 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
  457. SELECT COUNT(*)
      FROM 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'
  458. SELECT COUNT(*)
      FROM 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'
  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=119
      AND a.category_publish='Y'
  460. SELECT COUNT(*)
      FROM 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'
  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=167
      AND a.category_publish='Y'
  462. SELECT COUNT(*)
      FROM 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'
  463. 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
  464. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=120&lang=ru&page=shop.browse'
  465. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  466. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=120&lang=ru&limitstart=0&page=shop.browse'
  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=120
      AND a.category_publish='Y'
  468. 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=120
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  469. SELECT COUNT(*)
      FROM 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'
  470. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=117&lang=ru&page=shop.browse'
  471. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  472. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=117&lang=ru&limitstart=0&page=shop.browse'
  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=117
      AND a.category_publish='Y'
  474. 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=117
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  475. SELECT COUNT(*)
      FROM 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'
  476. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=119&lang=ru&page=shop.browse'
  477. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  478. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=119&lang=ru&limitstart=0&page=shop.browse'
  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=119
      AND a.category_publish='Y'
  480. 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=119
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  481. SELECT COUNT(*)
      FROM 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'
  482. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&page=shop.browse'
  483. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  484. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&limitstart=0&page=shop.browse'
  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=118
      AND a.category_publish='Y'
  486. 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=118
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  487. SELECT COUNT(*)
      FROM 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'
  488. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=167&lang=ru&page=shop.browse'
  489. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  490. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=167&lang=ru&limitstart=0&page=shop.browse'
  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=167
      AND a.category_publish='Y'
  492. 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=167
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  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=167
      AND a.category_publish='Y'
  494. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
  495. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  496. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
  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=161
      AND a.category_publish='Y'
  498. 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'
  499. SELECT COUNT(*)
      FROM 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'
  500. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
  501. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  502. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
  503. SELECT COUNT(*)
      FROM 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'
  504. 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'
  505. SELECT COUNT(*)
      FROM 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'
  506. 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
  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=132
      AND a.category_publish='Y'
  508. 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
  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=135
      AND a.category_publish='Y'
  510. SELECT COUNT(*)
      FROM 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'
  511. SELECT COUNT(*)
      FROM 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'
  512. SELECT COUNT(*)
      FROM 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'
  513. SELECT COUNT(*)
      FROM 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'
  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=17
      AND a.category_publish='Y'
  515. SELECT COUNT(*)
      FROM 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'
  516. 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
  517. SELECT COUNT(*)
      FROM 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'
  518. SELECT COUNT(*)
      FROM 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'
  519. SELECT COUNT(*)
      FROM 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'
  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=18
      AND a.category_publish='Y'
  521. SELECT COUNT(*)
      FROM 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'
  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=20
      AND a.category_publish='Y'
  523. SELECT COUNT(*)
      FROM 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'
  524. SELECT COUNT(*)
      FROM 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'
  525. 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
  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=158
      AND a.category_publish='Y'
  527. SELECT COUNT(*)
      FROM 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'
  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=23
      AND a.category_publish='Y'
  529. SELECT COUNT(*)
      FROM 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'
  530. SELECT COUNT(*)
      FROM 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'
  531. SELECT COUNT(*)
      FROM 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'
  532. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
  533. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  534. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
  535. SELECT COUNT(*)
      FROM 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'
  536. 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'
  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=6
      AND a.category_publish='Y'
  538. 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
  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=40
      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=74
      AND a.category_publish='Y'
  541. SELECT COUNT(*)
      FROM 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'
  542. SELECT COUNT(*)
      FROM 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'
  543. SELECT COUNT(*)
      FROM 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'
  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=44
      AND a.category_publish='Y'
  545. SELECT COUNT(*)
      FROM 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'
  546. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
  547. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  548. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
  549. SELECT COUNT(*)
      FROM 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'
  550. 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'
  551. SELECT COUNT(*)
      FROM 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'
  552. 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
  553. SELECT COUNT(*)
      FROM 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'
  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=27
      AND a.category_publish='Y'
  555. SELECT COUNT(*)
      FROM 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'
  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=29
      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=124
      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=30
      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=31
      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=163
      AND a.category_publish='Y'
  561. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
  562. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  563. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
  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=4
      AND a.category_publish='Y'
  565. 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'
  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=4
      AND a.category_publish='Y'
  567. 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
  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=32
      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=33
      AND a.category_publish='Y'
  570. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
  571. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  572. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
  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=8
      AND a.category_publish='Y'
  574. 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'
  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=8
      AND a.category_publish='Y'
  576. 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
  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=48
      AND a.category_publish='Y'
  578. 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
  579. SELECT COUNT(*)
      FROM 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'
  580. SELECT COUNT(*)
      FROM 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'
  581. SELECT COUNT(*)
      FROM 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'
  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=97
      AND a.category_publish='Y'
  583. SELECT COUNT(*)
      FROM 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'
  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=104
      AND a.category_publish='Y'
  585. SELECT COUNT(*)
      FROM 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'
  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=49
      AND a.category_publish='Y'
  587. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
  588. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  589. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
  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=9
      AND a.category_publish='Y'
  591. 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'
  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=9
      AND a.category_publish='Y'
  593. 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
  594. SELECT COUNT(*)
      FROM 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'
  595. SELECT COUNT(*)
      FROM 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'
  596. 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
  597. SELECT COUNT(*)
      FROM 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'
  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=127
      AND a.category_publish='Y'
  599. SELECT COUNT(*)
      FROM 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'
  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=129
      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=130
      AND a.category_publish='Y'
  602. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
  603. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  604. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
  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=7
      AND a.category_publish='Y'
  606. 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'
  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=7
      AND a.category_publish='Y'
  608. 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
  609. SELECT COUNT(*)
      FROM 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'
  610. SELECT COUNT(*)
      FROM 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'
  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=47
      AND a.category_publish='Y'
  612. SELECT COUNT(*)
      FROM 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'
  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=58
      AND a.category_publish='Y'
  614. SELECT COUNT(*)
      FROM 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'
  615. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
  616. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  617. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
  618. SELECT COUNT(*)
      FROM 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'
  619. 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'
  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=169
      AND a.category_publish='Y'
  621. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
  622. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  623. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
  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=170
      AND a.category_publish='Y'
  625. 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'
  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=170
      AND a.category_publish='Y'
  627. 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
  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=171
      AND a.category_publish='Y'
  629. SELECT params
      FROM glenrich_advancedmodules
      WHERE moduleid = 41
  630. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
  631. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  632. SELECT name, link,id
      FROM glenrich_menu
      WHERE id = '8'
      AND published='1'
  633. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
  634. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  635. 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;
  636. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=36&page=shop.browse'

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

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

Нет

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

Нет