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

Чугунные камины

Чугунный камин АК5
Артикул АК5
Цена 2120 €
Ширина 1110 мм.
Высота 1190 мм.
Глубина 130 мм.

Стиль: Модерн
Отделка: Черный

Подробнее
Английский камин АК18
Артикул АК18
Цена 2100 €
Ширина 1040 мм.
Высота 1040 мм.
Глубина 200 мм.

Стиль: Викторианский
Отделка: Полированный

Подробнее
Английский камин АК79
Артикул АК79
Цена 2465 €
Ширина 1400 мм.
Высота 1230 мм.
Глубина 200 мм.

Чугунный камин

Подробнее
Чугунный камин АК91
Артикул АК91
Цена 3450 €
Ширина 1510 мм.
Высота 1220 мм.
Глубина 280 мм.

Стиль: Рококо
Отделка: Черный

Подробнее
Английский камин АК27
Артикул АК27
Цена 2070 €
Ширина 990 мм.
Высота 1050 мм.
Глубина 200 мм.

Стиль: Георгианский
Отделка: Черный

Подробнее
Английский камин АК12
Артикул АК12
Цена 1998 €
Ширина 1010 мм.
Высота 1020 мм.
Глубина 240 мм.

Стиль: Поздний викторианский
Отделка: Полированный

Подробнее
Английский камин АК16
Артикул АК16
Цена 2180 €
Ширина 1140 мм.
Высота 1030 мм.
Глубина 220 мм.

Стиль: Викторианский
Отделка: Полированный

Подробнее
Английский камин АК70
Артикул АК70
Цена 2598 €
Ширина 1510 мм.
Высота 1220 мм.
Глубина 300 мм.

Стиль: Георгианский
Отделка: Частично полированный

Подробнее
Английский камин АК54
Артикул АК54
Цена 2295 €
Ширина 1370 мм.
Высота 1210 мм.
Глубина 250 мм.

Стиль: Ранний викторианский
Отделка: Черный

Подробнее
Английский камин АК88
Артикул АК88
Цена 2680 €
Ширина 1370 мм.
Высота 1210 мм.
Глубина 200 мм.

Стиль: Традиционный
Отделка: Черный

Подробнее
Английский камин АК4
Артикул АК4
Цена 2190 €
Ширина 1110 мм.
Высота 1190 мм.
Глубина 130 мм.

Стиль: Модерн
Отделка: Полированный

Подробнее
Английский камин АК60
Артикул АК60
Цена 2350 €
Ширина 1360 мм.
Высота 1140 мм.
Глубина 180 мм.

Стиль: Викторианский
Отделка: Черный

Подробнее

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


Представляем вашему вниманию чугунные камины, изготовленные в традиционно английском,

викторианском стиле.

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

На нашем сайте Вы можете видеть чугунные камины, которые представляют полностью литую конструкцию, точнее - портал вместе с топкой – это одно изделие. Есть модели каминов, которые состоят из двух частей, деталей – это чугунный или деревянный портал (обрамление) и чугунная топка.

Некоторые модели чугунных каминов украшены изразцами или керамической плиткой покрытой глазурью однотонной окраски либо с цветочным орнаментом.

Замечательно выглядят чугунные камины с деревянным порталом.

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

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

Чугунный английский камин не потерял привлекательность и в наши дни.

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

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

Габаритные размеры каждой модели в прикрепленных файлах.

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

Английский камин АК12
Артикул АК12

Подробнее
Английский камин АК64
Артикул АК64

Подробнее
Английский камин АК70
Артикул АК70

Подробнее

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

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

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



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

Application afterLoad: 0.000 seconds, 0.45 MB
Application afterInitialise: 0.064 seconds, 5.41 MB
Application afterRoute: 0.124 seconds, 9.03 MB
Application afterDispatch: 0.671 seconds, 21.98 MB
Application afterRender: 0.932 seconds, 24.29 MB

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

25798736

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'b328cl8el9400bh56ck5mt4k30'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1781477436' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'b328cl8el9400bh56ck5mt4k30'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'b328cl8el9400bh56ck5mt4k30','1781481036','','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/chugunnye-kaminy.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=162&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'kaminy/chugunnye-kaminy.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`=162
     
      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='162'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='162'
  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='162'
      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 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='162'
      AND glenrich_vm_category.category_id='162'
  22. 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'
  23. SELECT id, params
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  24. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  25. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  26. 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;
  27. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  28. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  29. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  30. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  31. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  32. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  33. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  34. 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`=162
     
      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 0, 12
  35. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=117'
  36. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  37. 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 = 117
  38. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '117'
  39. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=117'
  40. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=117
  41. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='117'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  42. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=117
  43. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  44. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='117'
  45. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  46. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=117
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  47. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=117
  48. 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
  49. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='117'
  50. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=117
  51. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=117
      AND `file_is_image`=1
      AND `file_published`=1
  52. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=117
      AND `file_is_image`=0
  53. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='117'
  54. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=130'
  55. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  56. 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 = 130
  57. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '130'
  58. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=130'
  59. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=130
  60. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='130'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  61. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=130
  62. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  63. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='130'
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=130
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=130
  66. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='130'
  67. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=130
  68. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=130
      AND `file_is_image`=1
      AND `file_published`=1
  69. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=130
      AND `file_is_image`=0
  70. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='130'
  71. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=191'
  72. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  73. 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 = 191
  74. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '191'
  75. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=191'
  76. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=191
  77. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='191'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  78. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=191
  79. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  80. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='191'
  81. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=191
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  82. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=191
  83. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='191'
  84. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=191
  85. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=191
      AND `file_is_image`=1
      AND `file_published`=1
  86. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=191
      AND `file_is_image`=0
  87. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='191'
  88. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  89. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='191'
  90. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1345'
  91. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  92. 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 = 1345
  93. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1345'
  94. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1345'
  95. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1345
  96. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1345'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  97. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1345
  98. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1345'
  100. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1345
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  101. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1345
  102. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1345'
  103. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1345
  104. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1345
      AND `file_is_image`=1
      AND `file_published`=1
  105. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1345
      AND `file_is_image`=0
  106. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1345'
  107. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=139'
  108. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  109. 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 = 139
  110. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '139'
  111. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=139'
  112. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=139
  113. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='139'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  114. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=139
  115. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='139'
  117. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=139
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  118. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=139
  119. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='139'
  120. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=139
  121. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=139
      AND `file_is_image`=1
      AND `file_published`=1
  122. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=139
      AND `file_is_image`=0
  123. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='139'
  124. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=124'
  125. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  126. 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 = 124
  127. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  128. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  129. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=124
  130. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='124'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=124
  132. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  133. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='124'
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  135. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  136. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  137. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  138. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=1
      AND `file_published`=1
  139. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=0
  140. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='124'
  141. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=128'
  142. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  143. 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 = 128
  144. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '128'
  145. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=128'
  146. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=128
  147. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='128'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  148. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=128
  149. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='128'
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  152. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=128
  153. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='128'
  154. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=128
  155. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=128
      AND `file_is_image`=1
      AND `file_published`=1
  156. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=128
      AND `file_is_image`=0
  157. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='128'
  158. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=182'
  159. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  160. 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 = 182
  161. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  162. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  163. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=182
  164. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='182'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=182
  166. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='182'
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=182
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  170. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  171. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  172. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=182
      AND `file_is_image`=1
      AND `file_published`=1
  173. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=182
      AND `file_is_image`=0
  174. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='182'
  175. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=166'
  176. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  177. 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 = 166
  178. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '166'
  179. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=166'
  180. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=166
  181. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='166'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=166
  183. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='166'
  185. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=166
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  186. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=166
  187. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='166'
  188. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=166
  189. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=166
      AND `file_is_image`=1
      AND `file_published`=1
  190. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=166
      AND `file_is_image`=0
  191. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='166'
  192. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=196'
  193. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  194. 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 = 196
  195. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '196'
  196. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=196'
  197. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=196
  198. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='196'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  199. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=196
  200. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  201. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='196'
  202. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=196
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  203. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=196
  204. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='196'
  205. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=196
  206. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=196
      AND `file_is_image`=1
      AND `file_published`=1
  207. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=196
      AND `file_is_image`=0
  208. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='196'
  209. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  210. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='196'
  211. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=116'
  212. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  213. 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 = 116
  214. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '116'
  215. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=116'
  216. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=116
  217. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='116'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  218. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=116
  219. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  220. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='116'
  221. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=116
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  222. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  223. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='116'
  224. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  225. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=1
      AND `file_published`=1
  226. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=0
  227. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='116'
  228. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=172'
  229. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  230. 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 = 172
  231. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '172'
  232. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=172'
  233. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=172
  234. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='172'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  235. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=172
  236. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  237. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='172'
  238. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=172
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  239. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=172
  240. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='172'
  241. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=172
  242. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=172
      AND `file_is_image`=1
      AND `file_published`=1
  243. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=172
      AND `file_is_image`=0
  244. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='172'
  245. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  246. 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='162'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

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

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

                           
      WHERE `glenrich_vm_product`.`product_id`='124'
  248. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  249. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  250. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='176'
  251. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=176
  252. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='176'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  253. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=176
  254. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='176'
  256. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=176
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  257. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=176
  258. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='176'
  259. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='182'
  260. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  261. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  262. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=124'
  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 = 124
  265. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  266. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  267. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=124'
  268. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  269. 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 = 124
  270. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  271. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  272. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=176'
  273. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  274. 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 = 176
  275. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '176'
  276. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=176'
  277. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=176'
  278. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  279. 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 = 176
  280. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '176'
  281. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=176'
  282. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=182'
  283. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  284. 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 = 182
  285. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  286. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  287. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=182'
  288. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  289. 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 = 182
  290. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  291. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  292. 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
  293. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
  294. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  295. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
  296. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  297. SELECT published
      FROM glenrich_modules
      WHERE module='mod_virtuemart_cart'
  298. SELECT COUNT(*)
      FROM 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'
  299. 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
  300. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  301. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  302. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  303. SELECT COUNT(*)
      FROM 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'
  304. 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'
  305. SELECT COUNT(*)
      FROM 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'
  306. 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
  307. SELECT COUNT(*)
      FROM 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'
  308. 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
  309. SELECT COUNT(*)
      FROM 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'
  310. SELECT COUNT(*)
      FROM 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'
  311. SELECT COUNT(*)
      FROM 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'
  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=12
      AND a.category_publish='Y'
  313. SELECT COUNT(*)
      FROM 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'
  314. SELECT COUNT(*)
      FROM 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'
  315. SELECT COUNT(*)
      FROM 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'
  316. SELECT COUNT(*)
      FROM 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'
  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=15
      AND a.category_publish='Y'
  318. SELECT COUNT(*)
      FROM 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'
  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=25
      AND a.category_publish='Y'
  320. SELECT COUNT(*)
      FROM 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'
  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=60
      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=60
      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=88
      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=89
      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=90
      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=91
      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=93
      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=166
      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=61
      AND a.category_publish='Y'
  330. 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
  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=110
      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=112
      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=113
      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=62
      AND a.category_publish='Y'
  335. 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
  336. SELECT COUNT(*)
      FROM 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'
  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=117
      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=119
      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=118
      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=167
      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=161
      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=1
      AND a.category_publish='Y'
  343. 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
  344. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&page=shop.browse'
  345. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  346. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&limitstart=0&page=shop.browse'
  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=133
      AND a.category_publish='Y'
  348. 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'
  349. SELECT COUNT(*)
      FROM 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'
  350. 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
  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=139
      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=164
      AND a.category_publish='Y'
  353. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
  354. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  355. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
  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=11
      AND a.category_publish='Y'
  357. 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'
  358. SELECT COUNT(*)
      FROM 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'
  359. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&page=shop.browse'
  360. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  361. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&limitstart=0&page=shop.browse'
  362. SELECT COUNT(*)
      FROM 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'
  363. 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'
  364. SELECT COUNT(*)
      FROM 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'
  365. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&page=shop.browse'
  366. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  367. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&limitstart=0&page=shop.browse'
  368. SELECT COUNT(*)
      FROM 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'
  369. 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'
  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=13
      AND a.category_publish='Y'
  371. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  372. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  373. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  374. SELECT COUNT(*)
      FROM 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'
  375. 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'
  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=162
      AND a.category_publish='Y'
  377. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&page=shop.browse'
  378. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  379. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&limitstart=0&page=shop.browse'
  380. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=125
      AND a.category_publish='Y'
  381. 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'
  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=125
      AND a.category_publish='Y'
  383. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&page=shop.browse'
  384. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  385. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&limitstart=0&page=shop.browse'
  386. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=14
      AND a.category_publish='Y'
  387. 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'
  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=14
      AND a.category_publish='Y'
  389. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&page=shop.browse'
  390. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  391. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&limitstart=0&page=shop.browse'
  392. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=15
      AND a.category_publish='Y'
  393. 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'
  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=15
      AND a.category_publish='Y'
  395. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&page=shop.browse'
  396. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  397. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&limitstart=0&page=shop.browse'
  398. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=24
      AND a.category_publish='Y'
  399. 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'
  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=24
      AND a.category_publish='Y'
  401. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&page=shop.browse'
  402. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  403. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&limitstart=0&page=shop.browse'
  404. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=25
      AND a.category_publish='Y'
  405. 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'
  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=25
      AND a.category_publish='Y'
  407. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&page=shop.browse'
  408. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  409. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&limitstart=0&page=shop.browse'
  410. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=56
      AND a.category_publish='Y'
  411. 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'
  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=56
      AND a.category_publish='Y'
  413. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&page=shop.browse'
  414. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  415. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&limitstart=0&page=shop.browse'
  416. SELECT COUNT(*)
      FROM 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'
  417. 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'
  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=60
      AND a.category_publish='Y'
  419. 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
  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=88
      AND a.category_publish='Y'
  421. SELECT COUNT(*)
      FROM 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'
  422. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=90
      AND a.category_publish='Y'
  423. SELECT COUNT(*)
      FROM 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'
  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=93
      AND a.category_publish='Y'
  425. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=166
      AND a.category_publish='Y'
  426. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  427. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  428. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  429. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  430. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=61
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  431. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  432. 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
  433. SELECT COUNT(*)
      FROM 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'
  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=112
      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=113
      AND a.category_publish='Y'
  436. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  437. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  438. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  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=62
      AND a.category_publish='Y'
  440. 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'
  441. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
  442. 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
  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=120
      AND a.category_publish='Y'
  444. SELECT COUNT(*)
      FROM 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'
  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=119
      AND a.category_publish='Y'
  446. SELECT COUNT(*)
      FROM 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'
  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=167
      AND a.category_publish='Y'
  448. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
  449. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  450. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
  451. SELECT COUNT(*)
      FROM 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'
  452. 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'
  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=161
      AND a.category_publish='Y'
  454. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
  455. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  456. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
  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=2
      AND a.category_publish='Y'
  458. 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'
  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=2
      AND a.category_publish='Y'
  460. 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
  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=132
      AND a.category_publish='Y'
  462. 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
  463. SELECT COUNT(*)
      FROM 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'
  464. SELECT COUNT(*)
      FROM 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'
  465. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=137
      AND a.category_publish='Y'
  466. SELECT COUNT(*)
      FROM 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'
  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=16
      AND a.category_publish='Y'
  468. SELECT COUNT(*)
      FROM 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'
  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=140
      AND a.category_publish='Y'
  470. 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
  471. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=141
      AND a.category_publish='Y'
  472. SELECT COUNT(*)
      FROM 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'
  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=143
      AND a.category_publish='Y'
  474. SELECT COUNT(*)
      FROM 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'
  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=19
      AND a.category_publish='Y'
  476. SELECT COUNT(*)
      FROM 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'
  477. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=22
      AND a.category_publish='Y'
  478. SELECT COUNT(*)
      FROM 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'
  479. 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
  480. SELECT COUNT(*)
      FROM 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'
  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=159
      AND a.category_publish='Y'
  482. SELECT COUNT(*)
      FROM 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'
  483. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=21
      AND a.category_publish='Y'
  484. SELECT COUNT(*)
      FROM 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'
  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=54
      AND a.category_publish='Y'
  486. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
  487. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  488. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
  489. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
  490. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=6
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  491. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
  492. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  493. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=40
      AND a.category_publish='Y'
  494. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=74
      AND a.category_publish='Y'
  495. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=42
      AND a.category_publish='Y'
  496. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=75
      AND a.category_publish='Y'
  497. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=43
      AND a.category_publish='Y'
  498. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=44
      AND a.category_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=41
      AND a.category_publish='Y'
  500. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&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=3&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=3
      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=3
      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=3
      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=3
      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=26
      AND a.category_publish='Y'
  508. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=27
      AND a.category_publish='Y'
  509. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=28
      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=29
      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=124
      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=30
      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=31
      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=163
      AND a.category_publish='Y'
  515. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
  516. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  517. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
  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=4
      AND a.category_publish='Y'
  519. 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'
  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=4
      AND a.category_publish='Y'
  521. 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
  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=32
      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=33
      AND a.category_publish='Y'
  524. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
  525. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  526. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
  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=8
      AND a.category_publish='Y'
  528. 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'
  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=8
      AND a.category_publish='Y'
  530. 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
  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=48
      AND a.category_publish='Y'
  532. 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
  533. SELECT COUNT(*)
      FROM 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'
  534. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=95
      AND a.category_publish='Y'
  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=96
      AND a.category_publish='Y'
  536. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=97
      AND a.category_publish='Y'
  537. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=103
      AND a.category_publish='Y'
  538. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=104
      AND a.category_publish='Y'
  539. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=168
      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=49
      AND a.category_publish='Y'
  541. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
  542. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  543. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
  544. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=9
      AND a.category_publish='Y'
  545. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=9
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  546. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=9
      AND a.category_publish='Y'
  547. 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
  548. SELECT COUNT(*)
      FROM 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'
  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=51
      AND a.category_publish='Y'
  550. 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
  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=126
      AND a.category_publish='Y'
  552. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=127
      AND a.category_publish='Y'
  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=128
      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=129
      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=130
      AND a.category_publish='Y'
  556. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
  557. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  558. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
  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=7
      AND a.category_publish='Y'
  560. 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'
  561. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=7
      AND a.category_publish='Y'
  562. 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
  563. SELECT COUNT(*)
      FROM 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'
  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=46
      AND a.category_publish='Y'
  565. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=47
      AND a.category_publish='Y'
  566. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=57
      AND a.category_publish='Y'
  567. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=58
      AND a.category_publish='Y'
  568. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=59
      AND a.category_publish='Y'
  569. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
  570. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  571. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
  572. SELECT COUNT(*)
      FROM 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'
  573. 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'
  574. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=169
      AND a.category_publish='Y'
  575. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
  576. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  577. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
  578. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=170
      AND a.category_publish='Y'
  579. 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'
  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=170
      AND a.category_publish='Y'
  581. 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
  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=171
      AND a.category_publish='Y'
  583. SELECT params
      FROM glenrich_advancedmodules
      WHERE moduleid = 41
  584. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
  585. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  586. SELECT name, link,id
      FROM glenrich_menu
      WHERE id = '8'
      AND published='1'
  587. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
  588. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  589. 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;
  590. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'b328cl8el9400bh56ck5mt4k30'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1781477436' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'b328cl8el9400bh56ck5mt4k30'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'b328cl8el9400bh56ck5mt4k30','1781481036','','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/chugunnye-kaminy.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=162&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'kaminy/chugunnye-kaminy.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`=162
     
      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='162'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='162'
  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='162'
      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 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='162'
      AND glenrich_vm_category.category_id='162'
  22. 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'
  23. SELECT id, params
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  24. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  25. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  26. 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;
  27. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  28. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  29. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  30. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  31. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  32. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  33. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  34. 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`=162
     
      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 0, 12
  35. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=117'
  36. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  37. 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 = 117
  38. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '117'
  39. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=117'
  40. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=117
  41. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='117'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  42. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=117
  43. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  44. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='117'
  45. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  46. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=117
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  47. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=117
  48. 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
  49. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='117'
  50. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=117
  51. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=117
      AND `file_is_image`=1
      AND `file_published`=1
  52. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=117
      AND `file_is_image`=0
  53. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='117'
  54. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=130'
  55. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  56. 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 = 130
  57. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '130'
  58. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=130'
  59. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=130
  60. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='130'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  61. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=130
  62. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  63. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='130'
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=130
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=130
  66. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='130'
  67. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=130
  68. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=130
      AND `file_is_image`=1
      AND `file_published`=1
  69. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=130
      AND `file_is_image`=0
  70. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='130'
  71. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=191'
  72. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  73. 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 = 191
  74. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '191'
  75. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=191'
  76. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=191
  77. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='191'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  78. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=191
  79. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  80. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='191'
  81. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=191
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  82. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=191
  83. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='191'
  84. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=191
  85. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=191
      AND `file_is_image`=1
      AND `file_published`=1
  86. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=191
      AND `file_is_image`=0
  87. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='191'
  88. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  89. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='191'
  90. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1345'
  91. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  92. 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 = 1345
  93. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1345'
  94. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1345'
  95. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1345
  96. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1345'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  97. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1345
  98. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1345'
  100. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1345
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  101. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1345
  102. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1345'
  103. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1345
  104. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1345
      AND `file_is_image`=1
      AND `file_published`=1
  105. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1345
      AND `file_is_image`=0
  106. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1345'
  107. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=139'
  108. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  109. 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 = 139
  110. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '139'
  111. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=139'
  112. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=139
  113. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='139'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  114. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=139
  115. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='139'
  117. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=139
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  118. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=139
  119. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='139'
  120. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=139
  121. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=139
      AND `file_is_image`=1
      AND `file_published`=1
  122. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=139
      AND `file_is_image`=0
  123. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='139'
  124. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=124'
  125. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  126. 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 = 124
  127. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  128. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  129. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=124
  130. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='124'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=124
  132. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  133. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='124'
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  135. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  136. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  137. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  138. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=1
      AND `file_published`=1
  139. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=0
  140. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='124'
  141. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=128'
  142. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  143. 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 = 128
  144. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '128'
  145. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=128'
  146. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=128
  147. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='128'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  148. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=128
  149. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='128'
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  152. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=128
  153. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='128'
  154. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=128
  155. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=128
      AND `file_is_image`=1
      AND `file_published`=1
  156. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=128
      AND `file_is_image`=0
  157. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='128'
  158. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=182'
  159. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  160. 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 = 182
  161. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  162. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  163. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=182
  164. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='182'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=182
  166. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='182'
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=182
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  170. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  171. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  172. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=182
      AND `file_is_image`=1
      AND `file_published`=1
  173. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=182
      AND `file_is_image`=0
  174. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='182'
  175. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=166'
  176. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  177. 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 = 166
  178. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '166'
  179. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=166'
  180. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=166
  181. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='166'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=166
  183. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='166'
  185. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=166
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  186. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=166
  187. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='166'
  188. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=166
  189. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=166
      AND `file_is_image`=1
      AND `file_published`=1
  190. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=166
      AND `file_is_image`=0
  191. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='166'
  192. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=196'
  193. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  194. 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 = 196
  195. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '196'
  196. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=196'
  197. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=196
  198. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='196'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  199. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=196
  200. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481036' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  201. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='196'
  202. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=196
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  203. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=196
  204. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='196'
  205. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=196
  206. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=196
      AND `file_is_image`=1
      AND `file_published`=1
  207. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=196
      AND `file_is_image`=0
  208. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='196'
  209. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  210. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='196'
  211. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=116'
  212. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  213. 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 = 116
  214. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '116'
  215. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=116'
  216. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=116
  217. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='116'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  218. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=116
  219. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  220. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='116'
  221. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=116
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  222. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  223. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='116'
  224. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  225. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=1
      AND `file_published`=1
  226. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=0
  227. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='116'
  228. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=172'
  229. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  230. 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 = 172
  231. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '172'
  232. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=172'
  233. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=172
  234. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='172'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  235. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=172
  236. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  237. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='172'
  238. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=172
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  239. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=172
  240. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='172'
  241. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=172
  242. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=172
      AND `file_is_image`=1
      AND `file_published`=1
  243. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=172
      AND `file_is_image`=0
  244. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='172'
  245. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  246. 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='162'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

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

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

                           
      WHERE `glenrich_vm_product`.`product_id`='124'
  248. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  249. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  250. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='176'
  251. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=176
  252. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='176'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  253. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=176
  254. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1781481037' OR start_date=0)
      AND (end_date>='1781393760' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='176'
  256. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=176
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  257. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=176
  258. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='176'
  259. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='182'
  260. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  261. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  262. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=124'
  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 = 124
  265. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  266. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  267. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=124'
  268. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  269. 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 = 124
  270. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  271. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  272. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=176'
  273. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  274. 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 = 176
  275. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '176'
  276. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=176'
  277. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=176'
  278. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  279. 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 = 176
  280. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '176'
  281. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=176'
  282. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=182'
  283. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  284. 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 = 182
  285. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  286. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  287. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=182'
  288. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  289. 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 = 182
  290. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  291. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  292. 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
  293. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
  294. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  295. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
  296. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  297. SELECT published
      FROM glenrich_modules
      WHERE module='mod_virtuemart_cart'
  298. SELECT COUNT(*)
      FROM 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'
  299. 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
  300. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  301. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  302. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  303. SELECT COUNT(*)
      FROM 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'
  304. 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'
  305. SELECT COUNT(*)
      FROM 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'
  306. 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
  307. SELECT COUNT(*)
      FROM 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'
  308. 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
  309. SELECT COUNT(*)
      FROM 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'
  310. SELECT COUNT(*)
      FROM 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'
  311. SELECT COUNT(*)
      FROM 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'
  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=12
      AND a.category_publish='Y'
  313. SELECT COUNT(*)
      FROM 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'
  314. SELECT COUNT(*)
      FROM 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'
  315. SELECT COUNT(*)
      FROM 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'
  316. SELECT COUNT(*)
      FROM 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'
  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=15
      AND a.category_publish='Y'
  318. SELECT COUNT(*)
      FROM 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'
  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=25
      AND a.category_publish='Y'
  320. SELECT COUNT(*)
      FROM 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'
  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=60
      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=60
      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=88
      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=89
      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=90
      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=91
      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=93
      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=166
      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=61
      AND a.category_publish='Y'
  330. 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
  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=110
      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=112
      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=113
      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=62
      AND a.category_publish='Y'
  335. 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
  336. SELECT COUNT(*)
      FROM 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'
  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=117
      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=119
      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=118
      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=167
      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=161
      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=1
      AND a.category_publish='Y'
  343. 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
  344. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&page=shop.browse'
  345. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  346. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&limitstart=0&page=shop.browse'
  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=133
      AND a.category_publish='Y'
  348. 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'
  349. SELECT COUNT(*)
      FROM 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'
  350. 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
  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=139
      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=164
      AND a.category_publish='Y'
  353. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
  354. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  355. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
  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=11
      AND a.category_publish='Y'
  357. 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'
  358. SELECT COUNT(*)
      FROM 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'
  359. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&page=shop.browse'
  360. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  361. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&limitstart=0&page=shop.browse'
  362. SELECT COUNT(*)
      FROM 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'
  363. 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'
  364. SELECT COUNT(*)
      FROM 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'
  365. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&page=shop.browse'
  366. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  367. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&limitstart=0&page=shop.browse'
  368. SELECT COUNT(*)
      FROM 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'
  369. 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'
  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=13
      AND a.category_publish='Y'
  371. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  372. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  373. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  374. SELECT COUNT(*)
      FROM 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'
  375. 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'
  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=162
      AND a.category_publish='Y'
  377. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&page=shop.browse'
  378. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  379. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&limitstart=0&page=shop.browse'
  380. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=125
      AND a.category_publish='Y'
  381. 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'
  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=125
      AND a.category_publish='Y'
  383. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&page=shop.browse'
  384. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  385. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&limitstart=0&page=shop.browse'
  386. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=14
      AND a.category_publish='Y'
  387. 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'
  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=14
      AND a.category_publish='Y'
  389. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&page=shop.browse'
  390. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  391. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&limitstart=0&page=shop.browse'
  392. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=15
      AND a.category_publish='Y'
  393. 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'
  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=15
      AND a.category_publish='Y'
  395. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&page=shop.browse'
  396. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  397. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&limitstart=0&page=shop.browse'
  398. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=24
      AND a.category_publish='Y'
  399. 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'
  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=24
      AND a.category_publish='Y'
  401. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&page=shop.browse'
  402. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  403. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&limitstart=0&page=shop.browse'
  404. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=25
      AND a.category_publish='Y'
  405. 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'
  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=25
      AND a.category_publish='Y'
  407. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&page=shop.browse'
  408. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  409. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&limitstart=0&page=shop.browse'
  410. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=56
      AND a.category_publish='Y'
  411. 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'
  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=56
      AND a.category_publish='Y'
  413. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&page=shop.browse'
  414. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  415. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&limitstart=0&page=shop.browse'
  416. SELECT COUNT(*)
      FROM 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'
  417. 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'
  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=60
      AND a.category_publish='Y'
  419. 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
  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=88
      AND a.category_publish='Y'
  421. SELECT COUNT(*)
      FROM 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'
  422. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=90
      AND a.category_publish='Y'
  423. SELECT COUNT(*)
      FROM 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'
  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=93
      AND a.category_publish='Y'
  425. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=166
      AND a.category_publish='Y'
  426. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  427. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  428. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  429. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  430. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=61
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  431. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=61
      AND a.category_publish='Y'
  432. 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
  433. SELECT COUNT(*)
      FROM 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'
  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=112
      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=113
      AND a.category_publish='Y'
  436. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  437. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  438. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  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=62
      AND a.category_publish='Y'
  440. 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'
  441. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=62
      AND a.category_publish='Y'
  442. 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
  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=120
      AND a.category_publish='Y'
  444. SELECT COUNT(*)
      FROM 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'
  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=119
      AND a.category_publish='Y'
  446. SELECT COUNT(*)
      FROM 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'
  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=167
      AND a.category_publish='Y'
  448. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
  449. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  450. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
  451. SELECT COUNT(*)
      FROM 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'
  452. 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'
  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=161
      AND a.category_publish='Y'
  454. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
  455. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  456. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
  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=2
      AND a.category_publish='Y'
  458. 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'
  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=2
      AND a.category_publish='Y'
  460. 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
  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=132
      AND a.category_publish='Y'
  462. 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
  463. SELECT COUNT(*)
      FROM 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'
  464. SELECT COUNT(*)
      FROM 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'
  465. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=137
      AND a.category_publish='Y'
  466. SELECT COUNT(*)
      FROM 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'
  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=16
      AND a.category_publish='Y'
  468. SELECT COUNT(*)
      FROM 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'
  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=140
      AND a.category_publish='Y'
  470. 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
  471. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=141
      AND a.category_publish='Y'
  472. SELECT COUNT(*)
      FROM 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'
  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=143
      AND a.category_publish='Y'
  474. SELECT COUNT(*)
      FROM 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'
  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=19
      AND a.category_publish='Y'
  476. SELECT COUNT(*)
      FROM 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'
  477. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=22
      AND a.category_publish='Y'
  478. SELECT COUNT(*)
      FROM 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'
  479. 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
  480. SELECT COUNT(*)
      FROM 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'
  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=159
      AND a.category_publish='Y'
  482. SELECT COUNT(*)
      FROM 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'
  483. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=21
      AND a.category_publish='Y'
  484. SELECT COUNT(*)
      FROM 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'
  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=54
      AND a.category_publish='Y'
  486. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
  487. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  488. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
  489. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
  490. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=6
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  491. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
  492. SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=6
      AND a.category_publish='Y'
      ORDER BY a.list_order, a.category_name
  493. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=40
      AND a.category_publish='Y'
  494. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=74
      AND a.category_publish='Y'
  495. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=42
      AND a.category_publish='Y'
  496. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=75
      AND a.category_publish='Y'
  497. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=43
      AND a.category_publish='Y'
  498. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=44
      AND a.category_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=41
      AND a.category_publish='Y'
  500. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&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=3&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=3
      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=3
      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=3
      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=3
      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=26
      AND a.category_publish='Y'
  508. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=27
      AND a.category_publish='Y'
  509. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=28
      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=29
      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=124
      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=30
      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=31
      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=163
      AND a.category_publish='Y'
  515. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
  516. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  517. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
  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=4
      AND a.category_publish='Y'
  519. 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'
  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=4
      AND a.category_publish='Y'
  521. 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
  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=32
      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=33
      AND a.category_publish='Y'
  524. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
  525. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  526. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
  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=8
      AND a.category_publish='Y'
  528. 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'
  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=8
      AND a.category_publish='Y'
  530. 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
  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=48
      AND a.category_publish='Y'
  532. 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
  533. SELECT COUNT(*)
      FROM 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'
  534. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=95
      AND a.category_publish='Y'
  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=96
      AND a.category_publish='Y'
  536. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=97
      AND a.category_publish='Y'
  537. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=103
      AND a.category_publish='Y'
  538. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=104
      AND a.category_publish='Y'
  539. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=168
      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=49
      AND a.category_publish='Y'
  541. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
  542. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  543. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
  544. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=9
      AND a.category_publish='Y'
  545. SELECT COUNT(*)
      FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
      WHERE a.category_id = f.category_id
      AND f.category_id=9
      AND a.category_publish='Y'
      AND p.product_id = f.product_id
      AND p.product_publish='Y'
  546. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=9
      AND a.category_publish='Y'
  547. 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
  548. SELECT COUNT(*)
      FROM 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'
  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=51
      AND a.category_publish='Y'
  550. 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
  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=126
      AND a.category_publish='Y'
  552. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=127
      AND a.category_publish='Y'
  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=128
      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=129
      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=130
      AND a.category_publish='Y'
  556. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
  557. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  558. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
  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=7
      AND a.category_publish='Y'
  560. 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'
  561. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=7
      AND a.category_publish='Y'
  562. 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
  563. SELECT COUNT(*)
      FROM 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'
  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=46
      AND a.category_publish='Y'
  565. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=47
      AND a.category_publish='Y'
  566. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=57
      AND a.category_publish='Y'
  567. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=58
      AND a.category_publish='Y'
  568. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=59
      AND a.category_publish='Y'
  569. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
  570. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  571. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
  572. SELECT COUNT(*)
      FROM 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'
  573. 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'
  574. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=169
      AND a.category_publish='Y'
  575. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
  576. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  577. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
  578. SELECT COUNT(*)
      FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
      WHERE a.category_id = f.category_child_id
      AND f.category_parent_id=170
      AND a.category_publish='Y'
  579. 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'
  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=170
      AND a.category_publish='Y'
  581. 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
  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=171
      AND a.category_publish='Y'
  583. SELECT params
      FROM glenrich_advancedmodules
      WHERE moduleid = 41
  584. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
  585. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  586. SELECT name, link,id
      FROM glenrich_menu
      WHERE id = '8'
      AND published='1'
  587. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
  588. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  589. 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;
  590. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'

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

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

Нет

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

Нет