Дверцы и материалы для печей


Печные дверцы Термостойкие смеси и штукатурки для печей

Топочная дверца HT712NLR
Артикул HT712NLR
Габаритные размеры 23,5 х 35,7  см
Посадочные размеры 18,0 х 30,7  см

Топочная дверца 7/12

Подробнее
Уплотнительный шнур DS14B
Артикул DS14B

Уплотнительный шнур

Подробнее
Топочная дверца HT911SFNLR
Артикул HT911SFNLR
Габаритные размеры 25,9 х 32,9  см
Посадочные размеры 19,6 х 28,1  см

Топочная дверца 9/11 со стеклом
производство Австрия

Подробнее
Уплотнительный шнур DS16B
Артикул DS16B

Уплотнительный шнур

Подробнее
Топочная дверца HT911NLR
Артикул HT911NLR
Габаритные размеры 25,9 х 32,9  см
Посадочные размеры 19,6 х 28,1  см

Топочная дверца 9/11
производство Австрия

Подробнее
Дверца TS3439Т
Артикул TS3439Т
Габаритные размеры 34,4 x 39,0  см
Посадочные размеры 28,0 x 33,0  см

Дверца TWINSTAR 3439
производство Австрия

Подробнее
Уплотнительный шнур DS10B
Артикул DS10B

Уплотнительный шнур

Подробнее
Дверца TS4537
Артикул TS4537
Габаритные размеры 45,2 x 37,2  см
Посадочные размеры 30,0 x 31,5  см

Дверца TWINSTAR 4537
производство Австрия

Подробнее
Топочная дверца HT712AKR
Артикул HT712AKR
Габаритные размеры 23,5 х 35,7  см
Посадочные размеры 18,0 х 30,7  см

Топочная дверца 7/12

Подробнее
Топочная дверца HT1012SFNLR
Артикул HT1012SFNLR
Габаритные размеры 32,3 х 37,3  см
Посадочные размеры 25,3 х 31,5  см

Топочная дверца 10/12 со стеклом
производство Австрия

Подробнее
Решетка дырчатая APSPG1012V
Артикул APSPG1012V

Решетка дырчатая 10/12
производство Австрия

Подробнее
Решетка дырчатая APSPG911V
Артикул APSPG911V

Решетка дырчатая 9/11
производство Австрия

Подробнее

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


 

 

В этом разделе представлены "печные дверцы", используемые для строительства печей.
Это - топочные, зольниковые, прочистные, поддавальные дверцы для банных печей и др.
"Печные дверцы" предназначены для любых типов печей будь то отопительная, изразцовая, русская или варочная  печь, а также для барбекю и  барбекю-комплексов.
"Печные дверцы" - это один из основных элементов любой печи. Они  могут быть чугунными или металлическими, со стеклом или без стекла, с двойным стеклом, гладкие - классические или украшенные декоративными элементами и накладками, с деревянными ручками или металлическими и т.д.
Печные дверцы также могут быть изготовлены по специальному заказу для печи и иметь покрытие - "античная бронза", серебрянное или "золото". Дверцы могут быть ажурными, распашными, необычной формы и т.д. Все зависит от фантазии вашей или вашего архитектора. Основным спросом и любовью, конечно же, пользуются классические чугунные черные дверцы.
На сайте представлены "печные дверцы", входящие в производственную программу производителей и всегда имеющиеся в наличии на нашем складе в Москве.
Наша компания предлагает только немецкие, баварские или австрийские "печные дверцы" для печей. Этот выбор объясняется высокой надёжностью, безупречным качеством и долговечностью используемых нами материалов для строительства печей и каминов.
Также мы можем предложить замечательного качества производства Германии термостойкие уплотнительные шнуры, сетки для оштукатуривания печей , мастики, термостойкие штукатурки, в том числе и моделируемые, мертели, клеи, решетки для дверец, решетчатые и дырчатые,  и другие материалы.
Все эти материалы используются нашей компанией при строительстве печей, каминов, печных комплексов. Они высоко зарекомендовали себя за многие годы работы нашей компании в каминном и печном строительстве.
Все эти материалы для печей имеются в наличии на нашем складе в Москве.
В этом разделе представлены "печные дверцы", используемые для строительства печей. Это - топочные, зольниковые, прочистные, поддавальные дверцы для дровяных печей.
"Печные дверцы" предназначены для любых типов печей будь то отопительная, изразцовая, русская или варочная, а также для барбекю и  барбекю-комплексов.
Дверцы для печей - это один из основных элементов любой печи. Они  могут быть чугунными или металлическими, печные дверцы со стеклом или без стекла, с двойным стеклом, гладкие - классические или украшенные декоративными элементами и накладками, с деревянными ручками или металлическими и др.
Печные дверцы также могут быть изготовлены по специальному заказу для печи и иметь покрытие - "античная бронза", "серебряное" или "золото". Дверцы могут быть ажурными, распашными, необычной формы и др. Все зависит от фантазии вашей или вашего архитектора. Основным спросом и любовью, конечно же, пользуются классические чугунные черные печные дверцы.
На сайте представлены "печные дверцы", входящие в производственную программу производителей и всегда имеющиеся в наличии на нашем складе в Москве.
Наша компания предлагает только немецкие, баварские или австрийские дверцы для печей. Этот выбор объясняется высокой надёжностью, безупречным качеством и долговечностью используемых нами материалов для строительства печей и каминов.
Также мы можем предложить замечательного качества производства Германии термостойкие уплотнительные шнуры, сетки для штукатурки печей, мастики, термостойкие штукатурки, в том числе и моделируемые, мертели, клей, решетки для дверец, решетчатые и дырчатые,  и другие материалы.
Все эти материалы используются нашей компанией при строительстве печей, каминов, печных комплексов. Они высоко зарекомендовали себя за многие годы работы нашей компании в каминном и печном строительстве.
Все эти материалы для печей имеются в наличии на нашем складе в Москве.

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

Топочная дверца HT1216SFNLR
Артикул HT1216SFNLR

Подробнее
Дверца TS3439Т
Артикул TS3439Т

Подробнее
Топочная дверца HT1216NLR
Артикул HT1216NLR

Подробнее
Печная дверца
Артикул VS74x47

Подробнее
Дверца TS4537
Артикул TS4537

Подробнее
Топочная дверца HT712NLR
Артикул HT712NLR

Подробнее
Топочная дверца HT1012SFNLR
Артикул HT1012SFNLR

Подробнее
Печная дверца
Артикул HD50x30

Подробнее
Топочная дверца HT1012NLR
Артикул HT1012NLR

Подробнее

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

Application afterLoad: 0.000 seconds, 0.45 MB
Application afterInitialise: 0.039 seconds, 5.41 MB
Application afterRoute: 0.074 seconds, 9.03 MB
Application afterDispatch: 0.739 seconds, 22.07 MB
Application afterRender: 0.742 seconds, 22.23 MB

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

23649816

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'rv3gunva96144f8p4ku6q2ggg6'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1785251263' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'rv3gunva96144f8p4ku6q2ggg6'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'rv3gunva96144f8p4ku6q2ggg6','1785254863','','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 = 'dvercy-i-materialy-dlya-pechei.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=8&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'dvercy-i-materialy-dlya-pechei.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`=8
     
      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='8'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='8'
  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='8'
      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=48&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=48&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=49&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=49&lang=ru&limitstart=0&page=shop.browse'
  29. 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='8'
      AND glenrich_vm_category.category_id='8'
  30. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
  31. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  32. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
  33. 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`=8
     
      AND ((`glenrich_vm_product`.`product_id`=`glenrich_vm_product_price`.`product_id`
      AND `glenrich_vm_shopper_group`.`shopper_group_id`=`glenrich_vm_product_price`.`shopper_group_id`) OR `glenrich_vm_product_price`.`product_id` IS NULL)
     
      AND `glenrich_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `glenrich_vm_product`.`product_sku`
     
      ORDER BY `glenrich_vm_product_category_xref`.`product_list` ASC
      LIMIT 0, 12
  34. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=565
  35. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='565'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  36. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=565
  37. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  38. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='565'
  39. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  40. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  41. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  42. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  43. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  44. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='565'
  45. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  46. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  47. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=565
  48. SELECT `tax_rate`
      FROM glenrich_vm_vendor, glenrich_vm_tax_rate
      WHERE tax_country=vendor_country
      AND glenrich_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  49. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=565
      AND `file_is_image`=1
      AND `file_published`=1
  50. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=565
  51. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  52. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=565
      AND `file_is_image`=0
  53. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='565'
  54. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  55. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='565'
  56. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='565'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  57. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='565'
  58. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  59. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=582
  60. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='582'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  61. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=582
  62. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  63. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='582'
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  66. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  68. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='582'
  69. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  70. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  71. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=582
  72. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=582
  73. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=582
      AND `file_is_image`=1
      AND `file_published`=1
  74. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=582
  75. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  76. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=582
      AND `file_is_image`=0
  77. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='582'
  78. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  79. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='582'
  80. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='582'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  81. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='582'
  82. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  83. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=562
  84. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='562'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  85. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=562
  86. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  87. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='562'
  88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  89. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  90. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  91. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  92. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='562'
  93. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  94. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  95. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=562
  96. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=562
      AND `file_is_image`=1
      AND `file_published`=1
  97. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=562
      AND `file_is_image`=0
  98. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='562'
  99. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  100. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='562'
  101. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='562'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  102. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='562'
  103. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  104. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=583
  105. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='583'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  106. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=583
  107. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  108. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='583'
  109. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  110. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  111. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  112. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  113. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='583'
  114. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  115. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  116. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=583
  117. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=583
  118. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=583
      AND `file_is_image`=1
      AND `file_published`=1
  119. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=583
  120. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  121. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=583
      AND `file_is_image`=0
  122. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='583'
  123. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  124. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='583'
  125. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='583'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  126. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='583'
  127. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  128. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=560
  129. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='560'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  130. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=560
  131. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='560'
  133. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=560
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=560
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=560
      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=560
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  137. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='560'
  138. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=560
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  139. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=560
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  140. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=560
  141. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=560
      AND `file_is_image`=1
      AND `file_published`=1
  142. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=560
      AND `file_is_image`=0
  143. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='560'
  144. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  145. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='560'
  146. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='560'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  147. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='560'
  148. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  149. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=587
  150. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='587'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=587
  152. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  153. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='587'
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      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=587
      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=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  157. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  158. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='587'
  159. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  160. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  161. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=587
  162. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=587
      AND `file_is_image`=1
      AND `file_published`=1
  163. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=587
  164. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  165. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=587
      AND `file_is_image`=0
  166. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='587'
  167. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  168. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='587'
  169. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='587'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  170. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='587'
  171. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  172. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=581
  173. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='581'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=581
  175. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  176. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='581'
  177. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  178. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  179. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  180. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  181. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='581'
  182. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  183. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  184. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=581
  185. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=581
  186. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=581
      AND `file_is_image`=1
      AND `file_published`=1
  187. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=581
  188. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  189. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=581
      AND `file_is_image`=0
  190. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='581'
  191. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  192. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='581'
  193. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='581'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  194. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='581'
  195. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  196. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=590
  197. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='590'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  198. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=590
  199. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='590'
  201. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  202. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  203. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  204. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  205. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='590'
  206. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=590
  209. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=590
      AND `file_is_image`=1
      AND `file_published`=1
  210. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=590
  211. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  212. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=590
      AND `file_is_image`=0
  213. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='590'
  214. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  215. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='590'
  216. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='590'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  217. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='590'
  218. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  219. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=564
  220. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='564'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  221. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=564
  222. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  223. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='564'
  224. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=564
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  225. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=564
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  226. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=564
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=564
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='564'
  229. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=564
      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=564
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=564
  232. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=564
      AND `file_is_image`=1
      AND `file_published`=1
  233. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=564
  234. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  235. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=564
      AND `file_is_image`=0
  236. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='564'
  237. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  238. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='564'
  239. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='564'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  240. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='564'
  241. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  242. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=557
  243. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='557'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=557
  245. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  246. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='557'
  247. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      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=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  251. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='557'
  252. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  253. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  254. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=557
  255. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=557
      AND `file_is_image`=1
      AND `file_published`=1
  256. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=557
      AND `file_is_image`=0
  257. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='557'
  258. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  259. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='557'
  260. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='557'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  261. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='557'
  262. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  263. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=558
  264. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='558'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  265. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=558
  266. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='558'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=558
      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=558
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=558
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=558
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='558'
  273. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=558
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  274. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=558
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  275. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=558
  276. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=558
      AND `file_is_image`=1
      AND `file_published`=1
  277. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=558
  278. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  279. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=558
      AND `file_is_image`=0
  280. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='558'
  281. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  282. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='558'
  283. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='558'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  284. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='558'
  285. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  286. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=563
  287. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='563'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  288. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=563
  289. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  290. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='563'
  291. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  292. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  293. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  294. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  295. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='563'
  296. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  297. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  298. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=563
  299. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=563
      AND `file_is_image`=1
      AND `file_published`=1
  300. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=563
  301. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  302. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=563
      AND `file_is_image`=0
  303. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='563'
  304. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  305. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='563'
  306. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='563'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  307. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='563'
  308. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  309. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  310. 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='8'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  311. 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`='552'
  312. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=552
  313. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='552'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  314. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=552
  315. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  316. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='552'
  317. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=552
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  318. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=552
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  319. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=552
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  320. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=552
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  321. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='552'
  322. 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`='587'
  323. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  324. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  325. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  326. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  327. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='587'
  328. 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`='550'
  329. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=550
  330. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='550'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  331. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=550
  332. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  333. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='550'
  334. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=550
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  335. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=550
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  336. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=550
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  337. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=550
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  338. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='550'
  339. 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`='1388'
  340. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1388
  341. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1388'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  342. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1388
  343. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  344. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1388'
  345. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1388
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  346. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1388
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  347. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1388
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  348. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1388
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  349. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1388'
  350. 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`='590'
  351. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  352. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  353. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  354. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  355. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='590'
  356. 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`='565'
  357. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  358. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  359. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  360. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  361. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='565'
  362. 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`='557'
  363. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  364. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  365. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  366. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  367. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='557'
  368. 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`='1387'
  369. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1387
  370. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1387'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  371. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1387
  372. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  373. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1387'
  374. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1387
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  375. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1387
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  376. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1387
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  377. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1387
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  378. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1387'
  379. 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`='555'
  380. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=555
  381. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='555'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  382. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=555
  383. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  384. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='555'
  385. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=555
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  386. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=555
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  387. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=555
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  388. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=555
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  389. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='555'
  390. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=552'
  391. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  392. 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 = 552
  393. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '552'
  394. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=552'
  395. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=552'
  396. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  397. 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 = 552
  398. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '552'
  399. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=552'
  400. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=587'
  401. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  402. 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 = 587
  403. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '587'
  404. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=587'
  405. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=587'
  406. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  407. 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 = 587
  408. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '587'
  409. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=587'
  410. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=550'
  411. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  412. 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 = 550
  413. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '550'
  414. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=550'
  415. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=550'
  416. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  417. 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 = 550
  418. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '550'
  419. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=550'
  420. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1388'
  421. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  422. 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 = 1388
  423. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1388'
  424. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1388'
  425. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1388'
  426. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  427. 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 = 1388
  428. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1388'
  429. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1388'
  430. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=590'
  431. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  432. 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 = 590
  433. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '590'
  434. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=590'
  435. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=590'
  436. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  437. 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 = 590
  438. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '590'
  439. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=590'
  440. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=565'
  441. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  442. 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 = 565
  443. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '565'
  444. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=565'
  445. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=565'
  446. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  447. 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 = 565
  448. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '565'
  449. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=565'
  450. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=557'
  451. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  452. 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 = 557
  453. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '557'
  454. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=557'
  455. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=557'
  456. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  457. 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 = 557
  458. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '557'
  459. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=557'
  460. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1387'
  461. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  462. 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 = 1387
  463. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1387'
  464. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1387'
  465. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1387'
  466. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  467. 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 = 1387
  468. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1387'
  469. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1387'
  470. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=555'
  471. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  472. 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 = 555
  473. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '555'
  474. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=555'
  475. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=555'
  476. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  477. 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 = 555
  478. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '555'
  479. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=555'
  480. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  481. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  482. 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;
  483. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'rv3gunva96144f8p4ku6q2ggg6'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1785251263' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'rv3gunva96144f8p4ku6q2ggg6'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'rv3gunva96144f8p4ku6q2ggg6','1785254863','','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 = 'dvercy-i-materialy-dlya-pechei.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=8&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'dvercy-i-materialy-dlya-pechei.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`=8
     
      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='8'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='8'
  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='8'
      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=48&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=48&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=49&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=49&lang=ru&limitstart=0&page=shop.browse'
  29. 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='8'
      AND glenrich_vm_category.category_id='8'
  30. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
  31. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  32. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
  33. 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`=8
     
      AND ((`glenrich_vm_product`.`product_id`=`glenrich_vm_product_price`.`product_id`
      AND `glenrich_vm_shopper_group`.`shopper_group_id`=`glenrich_vm_product_price`.`shopper_group_id`) OR `glenrich_vm_product_price`.`product_id` IS NULL)
     
      AND `glenrich_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `glenrich_vm_product`.`product_sku`
     
      ORDER BY `glenrich_vm_product_category_xref`.`product_list` ASC
      LIMIT 0, 12
  34. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=565
  35. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='565'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  36. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=565
  37. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  38. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='565'
  39. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  40. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  41. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  42. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  43. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  44. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='565'
  45. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  46. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  47. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=565
  48. SELECT `tax_rate`
      FROM glenrich_vm_vendor, glenrich_vm_tax_rate
      WHERE tax_country=vendor_country
      AND glenrich_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  49. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=565
      AND `file_is_image`=1
      AND `file_published`=1
  50. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=565
  51. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  52. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=565
      AND `file_is_image`=0
  53. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='565'
  54. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  55. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='565'
  56. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='565'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  57. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='565'
  58. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  59. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=582
  60. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='582'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  61. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=582
  62. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  63. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='582'
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  66. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  68. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='582'
  69. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  70. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=582
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  71. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=582
  72. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=582
  73. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=582
      AND `file_is_image`=1
      AND `file_published`=1
  74. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=582
  75. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  76. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=582
      AND `file_is_image`=0
  77. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='582'
  78. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  79. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='582'
  80. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='582'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  81. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='582'
  82. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  83. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=562
  84. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='562'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  85. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=562
  86. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  87. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='562'
  88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  89. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  90. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  91. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  92. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='562'
  93. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  94. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=562
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  95. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=562
  96. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=562
      AND `file_is_image`=1
      AND `file_published`=1
  97. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=562
      AND `file_is_image`=0
  98. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='562'
  99. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  100. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='562'
  101. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='562'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  102. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='562'
  103. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  104. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=583
  105. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='583'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  106. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=583
  107. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  108. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='583'
  109. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  110. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  111. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  112. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  113. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='583'
  114. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  115. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=583
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  116. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=583
  117. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=583
  118. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=583
      AND `file_is_image`=1
      AND `file_published`=1
  119. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=583
  120. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  121. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=583
      AND `file_is_image`=0
  122. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='583'
  123. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  124. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='583'
  125. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='583'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  126. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='583'
  127. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  128. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=560
  129. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='560'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  130. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=560
  131. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='560'
  133. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=560
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=560
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=560
      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=560
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  137. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='560'
  138. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=560
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  139. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=560
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  140. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=560
  141. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=560
      AND `file_is_image`=1
      AND `file_published`=1
  142. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=560
      AND `file_is_image`=0
  143. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='560'
  144. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  145. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='560'
  146. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='560'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  147. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='560'
  148. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  149. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=587
  150. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='587'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=587
  152. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  153. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='587'
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      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=587
      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=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  157. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  158. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='587'
  159. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  160. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  161. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=587
  162. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=587
      AND `file_is_image`=1
      AND `file_published`=1
  163. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=587
  164. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  165. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=587
      AND `file_is_image`=0
  166. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='587'
  167. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  168. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='587'
  169. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='587'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  170. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='587'
  171. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  172. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=581
  173. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='581'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=581
  175. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  176. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='581'
  177. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  178. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  179. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  180. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  181. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='581'
  182. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  183. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=581
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  184. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=581
  185. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=581
  186. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=581
      AND `file_is_image`=1
      AND `file_published`=1
  187. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=581
  188. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  189. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=581
      AND `file_is_image`=0
  190. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='581'
  191. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  192. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='581'
  193. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='581'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  194. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='581'
  195. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  196. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=590
  197. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='590'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  198. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=590
  199. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='590'
  201. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  202. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  203. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  204. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  205. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='590'
  206. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=590
  209. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=590
      AND `file_is_image`=1
      AND `file_published`=1
  210. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=590
  211. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  212. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=590
      AND `file_is_image`=0
  213. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='590'
  214. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  215. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='590'
  216. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='590'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  217. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='590'
  218. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  219. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=564
  220. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='564'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  221. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=564
  222. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  223. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='564'
  224. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=564
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  225. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=564
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  226. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=564
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=564
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='564'
  229. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=564
      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=564
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=564
  232. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=564
      AND `file_is_image`=1
      AND `file_published`=1
  233. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=564
  234. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  235. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=564
      AND `file_is_image`=0
  236. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='564'
  237. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  238. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='564'
  239. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='564'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  240. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='564'
  241. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  242. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=557
  243. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='557'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=557
  245. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  246. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='557'
  247. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      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=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  251. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='557'
  252. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  253. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  254. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=557
  255. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=557
      AND `file_is_image`=1
      AND `file_published`=1
  256. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=557
      AND `file_is_image`=0
  257. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='557'
  258. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  259. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='557'
  260. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='557'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  261. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='557'
  262. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  263. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=558
  264. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='558'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  265. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=558
  266. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='558'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=558
      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=558
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=558
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=558
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='558'
  273. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=558
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  274. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=558
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  275. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=558
  276. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=558
      AND `file_is_image`=1
      AND `file_published`=1
  277. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=558
  278. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  279. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=558
      AND `file_is_image`=0
  280. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='558'
  281. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  282. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='558'
  283. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='558'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  284. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='558'
  285. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  286. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=563
  287. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='563'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  288. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=563
  289. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  290. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='563'
  291. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  292. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  293. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  294. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  295. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='563'
  296. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  297. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=563
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  298. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=563
  299. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=563
      AND `file_is_image`=1
      AND `file_published`=1
  300. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=563
  301. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  302. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=563
      AND `file_is_image`=0
  303. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='563'
  304. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  305. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='563'
  306. SELECT *
      FROM glenrich_vm_product_product_type_xref
      LEFT JOIN glenrich_vm_product_type USING (product_type_id)
      WHERE product_id='563'
      AND product_type_publish='Y'
      ORDER BY product_type_list_order
  307. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='563'
  308. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  309. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  310. 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='8'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  311. 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`='552'
  312. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=552
  313. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='552'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  314. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=552
  315. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  316. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='552'
  317. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=552
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  318. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=552
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  319. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=552
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  320. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=552
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  321. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='552'
  322. 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`='587'
  323. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  324. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  325. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  326. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=587
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  327. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='587'
  328. 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`='550'
  329. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=550
  330. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='550'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  331. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=550
  332. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  333. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='550'
  334. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=550
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  335. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=550
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  336. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=550
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  337. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=550
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  338. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='550'
  339. 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`='1388'
  340. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1388
  341. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1388'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  342. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1388
  343. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  344. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1388'
  345. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1388
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  346. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1388
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  347. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1388
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  348. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1388
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  349. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1388'
  350. 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`='590'
  351. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  352. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  353. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  354. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  355. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='590'
  356. 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`='565'
  357. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  358. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  359. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  360. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=565
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  361. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='565'
  362. 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`='557'
  363. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  364. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  365. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  366. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=557
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  367. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='557'
  368. 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`='1387'
  369. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1387
  370. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1387'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  371. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1387
  372. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  373. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1387'
  374. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1387
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  375. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1387
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  376. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1387
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  377. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1387
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  378. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1387'
  379. 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`='555'
  380. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=555
  381. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='555'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  382. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=555
  383. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254864' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  384. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='555'
  385. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=555
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  386. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=555
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  387. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=555
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  388. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=555
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  389. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='555'
  390. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=552'
  391. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  392. 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 = 552
  393. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '552'
  394. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=552'
  395. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=552'
  396. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  397. 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 = 552
  398. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '552'
  399. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=552'
  400. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=587'
  401. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  402. 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 = 587
  403. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '587'
  404. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=587'
  405. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=587'
  406. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  407. 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 = 587
  408. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '587'
  409. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=587'
  410. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=550'
  411. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  412. 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 = 550
  413. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '550'
  414. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=550'
  415. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=550'
  416. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  417. 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 = 550
  418. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '550'
  419. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=550'
  420. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1388'
  421. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  422. 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 = 1388
  423. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1388'
  424. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1388'
  425. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1388'
  426. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  427. 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 = 1388
  428. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1388'
  429. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1388'
  430. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=590'
  431. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  432. 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 = 590
  433. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '590'
  434. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=590'
  435. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=590'
  436. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  437. 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 = 590
  438. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '590'
  439. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=590'
  440. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=565'
  441. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  442. 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 = 565
  443. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '565'
  444. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=565'
  445. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=565'
  446. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  447. 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 = 565
  448. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '565'
  449. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=565'
  450. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=557'
  451. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  452. 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 = 557
  453. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '557'
  454. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=557'
  455. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=557'
  456. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  457. 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 = 557
  458. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '557'
  459. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=557'
  460. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1387'
  461. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  462. 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 = 1387
  463. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1387'
  464. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1387'
  465. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1387'
  466. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  467. 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 = 1387
  468. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1387'
  469. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1387'
  470. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=555'
  471. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  472. 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 = 555
  473. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '555'
  474. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=555'
  475. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=555'
  476. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  477. 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 = 555
  478. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '555'
  479. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=555'
  480. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  481. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  482. 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;
  483. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'

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

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

Нет

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

Нет