Камины


Как мы строим камины - мастер класс Изразцовые камины
Мраморные камины Камины Дворцовые и Замковые
Чугунные камины Малахитовые камины
Камины с облицовкой из камня Камины с облицовкой из дерева
Камины металлические Камины в стиле Минимализм
Английские камины Каминные топки BRUNNER
Каминные топки RUEGG Каминные топки SPARTHERM
Аксессуары для каминов

М22
Артикул М22
Цена 2406 €

Подробнее
Малахитовый камин МЛ2
Артикул МЛ2

Малахитовый камин в стиле модерн.

Подробнее
Топка Eck-Kamin 45/67/44 rechts Schiebetur
Артикул 45/67/44R
Ширина 886 мм.
Высота 1311 мм.
Глубина 656 мм.
Вес 252 кг.

Угловая (правая) каминная топка, размер по дверце В45 х Ш67 см, производство Германия.

Подробнее
Изразцовый камин ИК26
Артикул ИК26
Цена 2000 €
Ширина 1905 мм.
Высота 1930 мм.
Глубина 562 мм.

Кафельный (изразцовый) камин в деревянном доме.

Подробнее
Топка Prismalo
Артикул Prismalo
Ширина 844 мм.
Высота 1516 мм.
Глубина 576 мм.
Вес 240 кг.

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

Подробнее
Топка AK-Panorama 51/25/101/25
Артикул AK Panorama 51/25/101/25
Ширина 1223 мм.
Высота 1369 мм.
Глубина 617 мм.

Каминная топка Панорама, размеры по дверце В51 х Ш101 х Г25 см, производство Германия

Подробнее
Топка Uranus HK
Артикул Uranus HK
Ширина 837 мм.
Высота 1552 мм.
Глубина 506 мм.
Вес 220 кг.

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

Подробнее
М15
Артикул М15
Цена 5238 €

Подробнее
Изразцовый камин ИК17
Артикул ИК17
Ширина 1356 мм.
Высота 2260 мм.
Глубина 791 мм.

Изразцовый камин в деревянном доме.

Подробнее
Гриль с 1-м вертелом
Артикул Г 1

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

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

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

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

Подробнее

Страница 24 из 37

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

Топка 720-4R
Артикул 720-4R

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

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

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

Подробнее
Малахитовый камин МЛ1
Артикул МЛ1

Подробнее
Изразцовый камин ИК 27
Артикул ИК 27

Подробнее
Топка Eck-Kamine 53/121/50 R
Артикул 53/121/50 R

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

Подробнее
Изразцовый камин ИК44
Артикул ИК44

Подробнее
Топка Architektur-Kamine 53/121 f
Артикул 53/121 f

Подробнее

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

Application afterLoad: 0.000 seconds, 0.45 MB
Application afterInitialise: 0.046 seconds, 5.41 MB
Application afterRoute: 0.084 seconds, 9.03 MB
Application afterDispatch: 0.653 seconds, 22.24 MB
Application afterRender: 0.657 seconds, 22.40 MB

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

23821160

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

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

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

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

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

                           
      WHERE `glenrich_vm_product`.`product_id`='598'
  274. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=598
  275. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='598'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  276. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=598
  277. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  278. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='598'
  279. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=598
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  280. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=598
  281. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='598'
  282. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='614'
  283. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=614
  284. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='614'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  285. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=614
  286. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='614'
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=614
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  289. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=614
  290. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='614'
  291. 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'
  292. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=124
  293. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='124'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  294. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=124
  295. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  296. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='124'
  297. 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
  298. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  299. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  300. 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'
  301. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=182
  302. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='182'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  303. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=182
  304. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='182'
  306. 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
  307. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  308. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  309. 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`='1013'
  310. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1013
  311. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1013'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  312. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1013
  313. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  314. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1013'
  315. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  316. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  317. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  318. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  319. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1013'
  320. 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`='1191'
  321. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1191
  322. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1191'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  323. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1191
  324. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  325. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1191'
  326. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1191
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  327. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1191
  328. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1191'
  329. 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`='439'
  330. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=439
  331. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='439'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  332. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=439
  333. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  334. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='439'
  335. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  336. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  337. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  338. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  339. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='439'
  340. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='610'
  341. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=610
  342. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='610'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  343. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=610
  344. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  345. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='610'
  346. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=610
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  347. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=610
  348. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='610'
  349. 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`='1354'
  350. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1354
  351. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1354'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  352. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1354
  353. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  354. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1354'
  355. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1354
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  356. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1354
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  357. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1354
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  358. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1354
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  359. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1354'
  360. 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`='408'
  361. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=408
  362. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='408'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  363. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=408
  364. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  365. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='408'
  366. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  367. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  368. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  369. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  370. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='408'
  371. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=598'
  372. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  373. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 598
  374. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '598'
  375. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=598'
  376. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=598'
  377. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  378. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 598
  379. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '598'
  380. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=598'
  381. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=614'
  382. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  383. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 614
  384. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  385. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=614'
  386. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=614'
  387. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  388. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 614
  389. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  390. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=614'
  391. 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'
  392. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  393. 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
  394. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  395. 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'
  396. 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'
  397. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  398. 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
  399. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  400. 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'
  401. 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'
  402. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  403. 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
  404. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  405. 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'
  406. 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'
  407. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  408. 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
  409. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  410. 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'
  411. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1013'
  412. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  413. 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 = 1013
  414. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1013'
  415. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1013'
  416. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1013'
  417. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  418. 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 = 1013
  419. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1013'
  420. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1013'
  421. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1191'
  422. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  423. 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 = 1191
  424. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1191'
  425. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1191'
  426. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1191'
  427. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  428. 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 = 1191
  429. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1191'
  430. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1191'
  431. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=439'
  432. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  433. 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 = 439
  434. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '439'
  435. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=439'
  436. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=439'
  437. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  438. 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 = 439
  439. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '439'
  440. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=439'
  441. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=610'
  442. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  443. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  444. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  445. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=610'
  446. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=610'
  447. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  448. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  449. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  450. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=610'
  451. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1354'
  452. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  453. 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 = 1354
  454. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1354'
  455. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1354'
  456. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1354'
  457. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  458. 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 = 1354
  459. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1354'
  460. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1354'
  461. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=408'
  462. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  463. 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 = 408
  464. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '408'
  465. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=408'
  466. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=408'
  467. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  468. 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 = 408
  469. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '408'
  470. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=408'
  471. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  472. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  473. 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;
  474. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=276&page=shop.browse'

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

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

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

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

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

                           
      WHERE `glenrich_vm_product`.`product_id`='598'
  274. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=598
  275. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='598'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  276. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=598
  277. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  278. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='598'
  279. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=598
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  280. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=598
  281. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='598'
  282. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='614'
  283. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=614
  284. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='614'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  285. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=614
  286. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='614'
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=614
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  289. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=614
  290. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='614'
  291. 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'
  292. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=124
  293. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='124'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  294. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=124
  295. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  296. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='124'
  297. 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
  298. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  299. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  300. 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'
  301. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=182
  302. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='182'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  303. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=182
  304. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='182'
  306. 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
  307. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  308. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  309. 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`='1013'
  310. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1013
  311. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1013'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  312. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1013
  313. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  314. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1013'
  315. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  316. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  317. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  318. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  319. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1013'
  320. 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`='1191'
  321. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1191
  322. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1191'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  323. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1191
  324. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  325. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1191'
  326. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1191
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  327. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1191
  328. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1191'
  329. 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`='439'
  330. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=439
  331. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='439'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  332. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=439
  333. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  334. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='439'
  335. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  336. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  337. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  338. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  339. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='439'
  340. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='610'
  341. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=610
  342. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='610'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  343. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=610
  344. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  345. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='610'
  346. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=610
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  347. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=610
  348. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='610'
  349. 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`='1354'
  350. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1354
  351. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1354'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  352. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1354
  353. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  354. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1354'
  355. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1354
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  356. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1354
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  357. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1354
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  358. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1354
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  359. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1354'
  360. 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`='408'
  361. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=408
  362. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='408'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  363. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=408
  364. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785357442' OR start_date=0)
      AND (end_date>='1785281760' OR end_date=0)
      AND product_discount_id=discount_id
  365. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='408'
  366. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  367. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  368. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  369. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  370. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='408'
  371. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=598'
  372. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  373. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 598
  374. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '598'
  375. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=598'
  376. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=598'
  377. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  378. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 598
  379. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '598'
  380. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=598'
  381. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=614'
  382. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  383. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 614
  384. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  385. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=614'
  386. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=614'
  387. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  388. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 614
  389. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  390. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=614'
  391. 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'
  392. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  393. 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
  394. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  395. 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'
  396. 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'
  397. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  398. 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
  399. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  400. 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'
  401. 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'
  402. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  403. 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
  404. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  405. 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'
  406. 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'
  407. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  408. 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
  409. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  410. 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'
  411. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1013'
  412. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  413. 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 = 1013
  414. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1013'
  415. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1013'
  416. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1013'
  417. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  418. 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 = 1013
  419. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1013'
  420. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1013'
  421. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1191'
  422. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  423. 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 = 1191
  424. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1191'
  425. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1191'
  426. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1191'
  427. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  428. 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 = 1191
  429. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1191'
  430. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1191'
  431. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=439'
  432. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  433. 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 = 439
  434. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '439'
  435. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=439'
  436. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=439'
  437. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  438. 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 = 439
  439. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '439'
  440. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=439'
  441. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=610'
  442. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  443. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  444. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  445. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=610'
  446. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=610'
  447. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  448. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  449. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  450. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=610'
  451. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1354'
  452. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  453. 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 = 1354
  454. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1354'
  455. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1354'
  456. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1354'
  457. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  458. 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 = 1354
  459. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1354'
  460. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1354'
  461. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=408'
  462. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  463. 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 = 408
  464. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '408'
  465. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=408'
  466. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=408'
  467. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  468. 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 = 408
  469. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '408'
  470. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=408'
  471. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  472. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  473. 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;
  474. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=276&page=shop.browse'

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

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

Нет

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

Нет