Антикварные печи и камины


Камины Каминные дровники
Каминные собаки Кафельные печи
Компенсационные рамки Чугунные и керамические отопительные печи
Чугунные варочные печи Антикварные дверцы

Каминный дровник АД6
Артикул АД6
Ширина 1302 мм.
Высота 679 мм.
Глубина 419 мм.

Необычно большой дровник эпохи Регентства

Подробнее
Компенсационная рамка АР2
Артикул АР2
Ширина 1270 мм.
Высота 750 мм.
Глубина 90 мм.

Большая компенсационная рамка времен Людовика XIV

Подробнее
Антикварный камин АМК29
Артикул АМК29
Ширина 2100 мм.
Высота 2125 мм.
Глубина 465 мм.

Большой, безупречный и изысканный каминный портал из черного мрамора

Подробнее
Каминные собаки АС6
Артикул АС6
Ширина 250 мм.
Высота 590 мм.
Глубина 220 мм.

Роскошные каминные собаки из позолоченной бронзы с масками сатиров

Подробнее
Каминные собаки АС29
Артикул АС29
Ширина 250 мм.
Высота 320 мм.
Глубина 300 мм.

Необычные и очень стильные каминные собаки в виде египетской богини Баст

Подробнее
Антикварный камин АМК20
Артикул АМК20
Ширина 2005 мм.
Высота 1900 мм.
Глубина 500 мм.

Великолепный каминный портал из черного мрамора, выполнен в стиле фламандского Возрождения

Подробнее
Каминный дровник АД29
Артикул АД29
Ширина 845 мм.
Высота 825 мм.
Глубина 410 мм.

Каминный дровник конца 19 века в стиле времен Георга III

Подробнее
Антикварная кафельная печь АП2
Артикул АП2

Антикварная теплонакопительная печь в стиле Бидермайер. Приблизительная дата изготовления 1820 год.

Подробнее
Антикварный камин АМК53
Артикул АМК53
Ширина 2230 мм.
Высота 1810 мм.
Глубина 340 мм.

Великолепный и впечатляющий каминный портал в неоклассическом стиле

Подробнее
Каминные собаки  АС20
Артикул АС20
Ширина 310 мм.
Высота 630 мм.
Глубина 210 мм.

Великолепные каминные собаки из позолоченной бронзы в роскошном стиле Барокко

Подробнее
Антикварный камин АМК11
Артикул АМК11
Ширина 1702 мм.
Высота 1111 мм.
Глубина 457 мм.

Очень элегантный камин, выполненный с тонким чувством пропорций и линий в стиле Палладианизма

Подробнее
Каминный дровник АД20
Артикул АД20
Ширина 900 мм.
Высота 670 мм.
Глубина 350 мм.

Чугунный каминный дровник с массивными декоративными элементами из латуни

Подробнее

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

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

Антикварный камин АМК40
Артикул АМК40

Подробнее

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

Application afterLoad: 0.000 seconds, 0.45 MB
Application afterInitialise: 0.039 seconds, 5.41 MB
Application afterRoute: 0.073 seconds, 9.03 MB
Application afterDispatch: 0.560 seconds, 21.93 MB
Application afterRender: 0.562 seconds, 22.09 MB

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

23490432

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'lgt1vs66jsgn53rmdjm1mbios1'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1783330727' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'lgt1vs66jsgn53rmdjm1mbios1'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'lgt1vs66jsgn53rmdjm1mbios1','1783334327','','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 = 'antikvarnye-pechi-i-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=3&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'antikvarnye-pechi-i-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`=3
     
      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='3'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='3'
  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='3'
      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=26&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=26&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=27&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=27&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=28&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=28&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=29&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=29&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=124&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=124&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=30&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=30&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=31&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=31&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=163&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=163&lang=ru&limitstart=0&page=shop.browse'
  47. 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='3'
      AND glenrich_vm_category.category_id='3'
  48. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
  49. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  50. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
  51. 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`=3
     
      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 72, 12
  52. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=919
  53. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='919'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  54. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=919
  55. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  56. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='919'
  57. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  58. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  59. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  60. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='919'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=919
  66. 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
  67. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=919
      AND `file_is_image`=1
      AND `file_published`=1
  68. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=919
  69. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  70. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=919
      AND `file_is_image`=0
  71. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='919'
  72. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  73. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='919'
  74. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=985
  75. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='985'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  76. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=985
  77. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  78. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='985'
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  80. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  81. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  82. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  83. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='985'
  84. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  85. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  86. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=985
  87. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=985
      AND `file_is_image`=1
      AND `file_published`=1
  88. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=985
  89. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  90. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=985
      AND `file_is_image`=0
  91. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='985'
  92. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  93. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='985'
  94. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=882
  95. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='882'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  96. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=882
  97. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='882'
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=882
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  100. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=882
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=882
      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=882
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  103. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='882'
  104. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=882
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  105. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=882
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  106. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=882
  107. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=882
      AND `file_is_image`=1
      AND `file_published`=1
  108. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=882
      AND `file_is_image`=0
  109. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='882'
  110. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  111. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='882'
  112. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=951
  113. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='951'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  114. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=951
  115. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='951'
  117. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=951
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  118. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=951
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  119. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=951
      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=951
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  121. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='951'
  122. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=951
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  123. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=951
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  124. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=951
  125. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=951
      AND `file_is_image`=1
      AND `file_published`=1
  126. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=951
      AND `file_is_image`=0
  127. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='951'
  128. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  129. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='951'
  130. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=976
  131. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='976'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=976
  133. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  134. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='976'
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  136. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  137. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  138. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  139. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='976'
  140. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  141. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  142. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=976
  143. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=976
      AND `file_is_image`=1
      AND `file_published`=1
  144. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=976
      AND `file_is_image`=0
  145. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='976'
  146. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  147. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='976'
  148. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=873
  149. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='873'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=873
  151. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  152. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='873'
  153. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  155. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  156. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  157. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='873'
  158. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  159. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  160. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=873
  161. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=873
      AND `file_is_image`=1
      AND `file_published`=1
  162. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=873
      AND `file_is_image`=0
  163. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='873'
  164. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  165. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='873'
  166. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=942
  167. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='942'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  168. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=942
  169. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  170. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='942'
  171. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  173. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  174. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  175. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='942'
  176. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  177. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  178. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=942
  179. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=942
      AND `file_is_image`=1
      AND `file_published`=1
  180. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=942
      AND `file_is_image`=0
  181. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='942'
  182. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  183. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='942'
  184. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1111
  185. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1111'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  186. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1111
  187. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  188. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1111'
  189. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  190. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  191. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  192. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  193. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1111'
  194. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  195. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  196. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1111
  197. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1111
      AND `file_is_image`=1
      AND `file_published`=1
  198. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1111
  199. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  200. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1111
      AND `file_is_image`=0
  201. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1111'
  202. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  203. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1111'
  204. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=905
  205. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='905'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=905
  207. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  208. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='905'
  209. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=905
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  210. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=905
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  211. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=905
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=905
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='905'
  214. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=905
      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=905
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  216. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=905
  217. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=905
      AND `file_is_image`=1
      AND `file_published`=1
  218. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=905
      AND `file_is_image`=0
  219. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='905'
  220. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  221. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='905'
  222. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=965
  223. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='965'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  224. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=965
  225. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  226. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='965'
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=965
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=965
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  229. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=965
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  230. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=965
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='965'
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=965
      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=965
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  234. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=965
  235. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=965
      AND `file_is_image`=1
      AND `file_published`=1
  236. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=965
      AND `file_is_image`=0
  237. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='965'
  238. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  239. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='965'
  240. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=864
  241. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='864'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=864
  243. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='864'
  245. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=864
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  246. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=864
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  247. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=864
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  248. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=864
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='864'
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=864
      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=864
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  252. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=864
  253. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=864
      AND `file_is_image`=1
      AND `file_published`=1
  254. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=864
      AND `file_is_image`=0
  255. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='864'
  256. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  257. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='864'
  258. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=933
  259. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='933'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  260. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=933
  261. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  262. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='933'
  263. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  264. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  265. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  266. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  267. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='933'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  269. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=933
  271. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=933
      AND `file_is_image`=1
      AND `file_published`=1
  272. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=933
      AND `file_is_image`=0
  273. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='933'
  274. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  275. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='933'
  276. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  277. 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='3'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  278. 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`='893'
  279. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=893
  280. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='893'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  281. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=893
  282. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  283. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='893'
  284. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=893
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  285. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=893
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  286. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=893
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  287. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=893
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  288. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='893'
  289. 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=893'
  290. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  291. 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 = 893
  292. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '893'
  293. 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=893'
  294. 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=893'
  295. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  296. 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 = 893
  297. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '893'
  298. 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=893'
  299. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  300. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  301. 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;
  302. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=72&page=shop.browse'

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'lgt1vs66jsgn53rmdjm1mbios1'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1783330727' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'lgt1vs66jsgn53rmdjm1mbios1'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'lgt1vs66jsgn53rmdjm1mbios1','1783334327','','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 = 'antikvarnye-pechi-i-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=3&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'antikvarnye-pechi-i-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`=3
     
      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='3'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='3'
  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='3'
      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=26&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=26&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=27&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=27&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=28&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=28&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=29&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=29&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=124&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=124&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=30&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=30&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=31&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=31&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=163&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=163&lang=ru&limitstart=0&page=shop.browse'
  47. 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='3'
      AND glenrich_vm_category.category_id='3'
  48. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
  49. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  50. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
  51. 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`=3
     
      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 72, 12
  52. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=919
  53. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='919'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  54. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=919
  55. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  56. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='919'
  57. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  58. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  59. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  60. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='919'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=919
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=919
  66. 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
  67. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=919
      AND `file_is_image`=1
      AND `file_published`=1
  68. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=919
  69. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  70. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=919
      AND `file_is_image`=0
  71. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='919'
  72. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  73. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='919'
  74. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=985
  75. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='985'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  76. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=985
  77. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  78. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='985'
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  80. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  81. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  82. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  83. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='985'
  84. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  85. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=985
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  86. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=985
  87. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=985
      AND `file_is_image`=1
      AND `file_published`=1
  88. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=985
  89. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  90. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=985
      AND `file_is_image`=0
  91. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='985'
  92. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  93. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='985'
  94. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=882
  95. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='882'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  96. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=882
  97. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='882'
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=882
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  100. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=882
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=882
      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=882
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  103. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='882'
  104. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=882
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  105. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=882
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  106. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=882
  107. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=882
      AND `file_is_image`=1
      AND `file_published`=1
  108. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=882
      AND `file_is_image`=0
  109. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='882'
  110. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  111. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='882'
  112. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=951
  113. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='951'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  114. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=951
  115. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='951'
  117. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=951
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  118. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=951
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  119. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=951
      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=951
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  121. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='951'
  122. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=951
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  123. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=951
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  124. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=951
  125. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=951
      AND `file_is_image`=1
      AND `file_published`=1
  126. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=951
      AND `file_is_image`=0
  127. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='951'
  128. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  129. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='951'
  130. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=976
  131. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='976'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=976
  133. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  134. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='976'
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  136. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  137. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  138. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  139. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='976'
  140. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  141. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=976
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  142. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=976
  143. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=976
      AND `file_is_image`=1
      AND `file_published`=1
  144. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=976
      AND `file_is_image`=0
  145. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='976'
  146. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  147. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='976'
  148. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=873
  149. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='873'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=873
  151. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  152. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='873'
  153. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  155. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  156. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  157. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='873'
  158. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  159. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=873
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  160. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=873
  161. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=873
      AND `file_is_image`=1
      AND `file_published`=1
  162. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=873
      AND `file_is_image`=0
  163. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='873'
  164. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  165. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='873'
  166. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=942
  167. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='942'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  168. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=942
  169. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  170. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='942'
  171. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  173. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  174. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  175. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='942'
  176. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  177. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=942
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  178. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=942
  179. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=942
      AND `file_is_image`=1
      AND `file_published`=1
  180. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=942
      AND `file_is_image`=0
  181. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='942'
  182. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  183. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='942'
  184. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1111
  185. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1111'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  186. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1111
  187. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  188. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1111'
  189. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  190. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  191. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  192. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  193. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1111'
  194. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  195. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1111
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  196. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1111
  197. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1111
      AND `file_is_image`=1
      AND `file_published`=1
  198. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1111
  199. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  200. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1111
      AND `file_is_image`=0
  201. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1111'
  202. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  203. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1111'
  204. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=905
  205. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='905'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=905
  207. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  208. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='905'
  209. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=905
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  210. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=905
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  211. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=905
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=905
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='905'
  214. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=905
      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=905
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  216. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=905
  217. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=905
      AND `file_is_image`=1
      AND `file_published`=1
  218. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=905
      AND `file_is_image`=0
  219. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='905'
  220. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  221. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='905'
  222. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=965
  223. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='965'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  224. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=965
  225. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  226. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='965'
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=965
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=965
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  229. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=965
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  230. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=965
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='965'
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=965
      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=965
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  234. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=965
  235. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=965
      AND `file_is_image`=1
      AND `file_published`=1
  236. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=965
      AND `file_is_image`=0
  237. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='965'
  238. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  239. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='965'
  240. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=864
  241. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='864'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=864
  243. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='864'
  245. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=864
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  246. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=864
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  247. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=864
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  248. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=864
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='864'
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=864
      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=864
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  252. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=864
  253. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=864
      AND `file_is_image`=1
      AND `file_published`=1
  254. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=864
      AND `file_is_image`=0
  255. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='864'
  256. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  257. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='864'
  258. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=933
  259. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='933'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  260. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=933
  261. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  262. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='933'
  263. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  264. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  265. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  266. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  267. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='933'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  269. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=933
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=933
  271. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=933
      AND `file_is_image`=1
      AND `file_published`=1
  272. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=933
      AND `file_is_image`=0
  273. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='933'
  274. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  275. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='933'
  276. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  277. 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='3'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  278. 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`='893'
  279. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=893
  280. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='893'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  281. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=893
  282. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334327' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  283. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='893'
  284. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=893
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  285. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=893
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  286. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=893
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  287. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=893
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  288. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='893'
  289. 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=893'
  290. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  291. 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 = 893
  292. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '893'
  293. 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=893'
  294. 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=893'
  295. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  296. 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 = 893
  297. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '893'
  298. 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=893'
  299. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  300. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  301. 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;
  302. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=72&page=shop.browse'

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

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

Нет

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

Нет