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


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

Топочная дверца 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


 

 

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

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

Дверца TS4537
Артикул TS4537

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

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

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

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

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

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

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

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

Подробнее

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

Application afterLoad: 0.000 seconds, 0.46 MB
Application afterInitialise: 0.044 seconds, 5.44 MB
Application afterRoute: 0.085 seconds, 9.07 MB
Application afterDispatch: 0.731 seconds, 22.15 MB
Application afterRender: 0.734 seconds, 22.32 MB

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

23739368

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'lqk03fi7qhfec5curon0kug2q6'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1783327046' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'lqk03fi7qhfec5curon0kug2q6'
  4. UPDATE `glenrich_session`
      SET `time`='1783330646',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1783330643;s:18:\"session.timer.last\";i:1783330645;s:17:\"session.timer.now\";i:1783330645;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:68:\"/home/u70253/glenrich.ru/www/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:6:{s:3:\"idx\";i:5;i:0;a:2:{s:10:\"product_id\";i:948;s:11:\"category_id\";s:2:\"28\";}i:1;a:2:{s:10:\"product_id\";i:660;s:11:\"category_id\";s:3:\"159\";}i:2;a:2:{s:10:\"product_id\";i:311;s:11:\"category_id\";s:2:\"41\";}i:3;a:2:{s:10:\"product_id\";i:1369;s:11:\"category_id\";s:3:\"118\";}i:4;a:2:{s:10:\"product_id\";i:1313;s:11:\"category_id\";s:2:\"18\";}}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";userstate|a:6:{s:10:\"product_id\";s:4:\"1313\";s:31:\"view28product_detailslimitstart\";i:0;s:32:\"view159product_detailslimitstart\";i:0;s:31:\"view41product_detailslimitstart\";i:0;s:32:\"view118product_detailslimitstart\";i:0;s:31:\"view18product_detailslimitstart\";i:0;}last_page|s:20:\"shop.product_details\";last_browse_parameters|a:7:{s:11:\"category_id\";N;s:15:\"manufacturer_id\";N;s:7:\"keyword\";b:0;s:8:\"keyword1\";N;s:8:\"keyword2\";N;s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}product_sess|a:14:{i:949;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:947;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:948;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783330643;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:657;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:653;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:660;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783330644;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:312;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:310;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:311;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783330644;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1092;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:1368;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:1369;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783330645;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:23;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1313;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783330646;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}'
      WHERE session_id='lqk03fi7qhfec5curon0kug2q6'
  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<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' 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<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' 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 *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=565
      AND `file_is_image`=1
      AND `file_published`=1
  49. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=565
  50. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  51. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=565
      AND `file_is_image`=0
  52. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='565'
  53. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  54. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='565'
  55. 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
  56. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='565'
  57. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  58. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=582
  59. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='582'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=582
  61. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='582'
  63. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='582'
  68. 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
  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_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=582
  71. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=582
  72. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=582
      AND `file_is_image`=1
      AND `file_published`=1
  73. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=582
  74. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  75. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=582
      AND `file_is_image`=0
  76. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='582'
  77. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  78. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='582'
  79. 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
  80. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='582'
  81. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  82. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=562
  83. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='562'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=562
  85. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  86. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='562'
  87. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='562'
  92. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=562
  95. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=562
      AND `file_is_image`=1
      AND `file_published`=1
  96. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=562
      AND `file_is_image`=0
  97. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='562'
  98. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  99. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='562'
  100. 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
  101. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='562'
  102. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  103. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=583
  104. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='583'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  105. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=583
  106. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  107. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='583'
  108. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='583'
  113. 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
  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_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=583
  116. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=583
  117. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=583
      AND `file_is_image`=1
      AND `file_published`=1
  118. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=583
  119. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  120. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=583
      AND `file_is_image`=0
  121. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='583'
  122. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  123. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='583'
  124. 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
  125. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='583'
  126. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  127. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=560
  128. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='560'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=560
  130. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='560'
  132. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='560'
  137. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=560
  140. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=560
      AND `file_is_image`=1
      AND `file_published`=1
  141. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=560
      AND `file_is_image`=0
  142. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='560'
  143. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  144. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='560'
  145. 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
  146. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='560'
  147. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  148. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=587
  149. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='587'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=587
  151. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  152. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='587'
  153. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='587'
  158. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=587
  161. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=587
      AND `file_is_image`=1
      AND `file_published`=1
  162. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=587
  163. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  164. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=587
      AND `file_is_image`=0
  165. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='587'
  166. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  167. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='587'
  168. 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
  169. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='587'
  170. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  171. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=581
  172. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='581'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  173. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=581
  174. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  175. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='581'
  176. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='581'
  181. 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
  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_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=581
  184. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=581
  185. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=581
      AND `file_is_image`=1
      AND `file_published`=1
  186. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=581
  187. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  188. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=581
      AND `file_is_image`=0
  189. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='581'
  190. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  191. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='581'
  192. 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
  193. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='581'
  194. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  195. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=590
  196. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='590'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  197. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=590
  198. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  199. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='590'
  200. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='590'
  205. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=590
  208. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=590
      AND `file_is_image`=1
      AND `file_published`=1
  209. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=590
  210. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  211. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=590
      AND `file_is_image`=0
  212. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='590'
  213. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  214. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='590'
  215. 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
  216. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='590'
  217. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  218. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=564
  219. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='564'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  220. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=564
  221. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  222. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='564'
  223. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='564'
  228. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=564
  231. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=564
      AND `file_is_image`=1
      AND `file_published`=1
  232. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=564
  233. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  234. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=564
      AND `file_is_image`=0
  235. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='564'
  236. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  237. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='564'
  238. 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
  239. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='564'
  240. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  241. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=557
  242. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='557'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  243. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=557
  244. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  245. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='557'
  246. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='557'
  251. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=557
  254. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=557
      AND `file_is_image`=1
      AND `file_published`=1
  255. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=557
      AND `file_is_image`=0
  256. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='557'
  257. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  258. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='557'
  259. 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
  260. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='557'
  261. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  262. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=558
  263. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='558'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  264. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=558
  265. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  266. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='558'
  267. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='558'
  272. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=558
  275. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=558
      AND `file_is_image`=1
      AND `file_published`=1
  276. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=558
  277. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  278. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=558
      AND `file_is_image`=0
  279. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='558'
  280. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  281. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='558'
  282. 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
  283. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='558'
  284. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  285. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=563
  286. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='563'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=563
  288. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  289. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='563'
  290. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='563'
  295. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=563
  298. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=563
      AND `file_is_image`=1
      AND `file_published`=1
  299. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=563
  300. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  301. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=563
      AND `file_is_image`=0
  302. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='563'
  303. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  304. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='563'
  305. 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
  306. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='563'
  307. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  308. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '1313'
      AND c.category_id = '18'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  309. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1313
  310. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '1369'
      AND c.category_id = '118'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  311. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1369
  312. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '311'
      AND c.category_id = '41'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  313. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=311
  314. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '660'
      AND c.category_id = '159'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  315. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=660
  316. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '948'
      AND c.category_id = '28'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  317. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=948
  318. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  319. 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
  320. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='590'
  321. 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
  322. 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
  323. 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
  324. 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
  325. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='590'
  326. 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'
  327. 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
  328. 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
  329. 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
  330. 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
  331. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='557'
  332. 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'
  333. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1387
  334. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1387'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  335. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1387
  336. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  337. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1387'
  338. 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
  339. 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
  340. 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
  341. 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
  342. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1387'
  343. 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'
  344. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=550
  345. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='550'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  346. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=550
  347. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  348. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='550'
  349. 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
  350. 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
  351. 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
  352. 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
  353. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='550'
  354. 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'
  355. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1388
  356. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1388'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  357. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1388
  358. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  359. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1388'
  360. 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
  361. 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
  362. 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
  363. 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
  364. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1388'
  365. 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'
  366. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=552
  367. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='552'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  368. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=552
  369. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  370. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='552'
  371. 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
  372. 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
  373. 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
  374. 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
  375. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='552'
  376. 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'
  377. 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
  378. 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
  379. 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
  380. 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
  381. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='587'
  382. 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'
  383. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=555
  384. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='555'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  385. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=555
  386. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  387. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='555'
  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 `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
  390. 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
  391. 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
  392. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='555'
  393. 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'
  394. 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
  395. 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
  396. 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
  397. 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
  398. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='565'
  399. 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'
  400. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  401. 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
  402. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '590'
  403. 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'
  404. 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'
  405. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  406. 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
  407. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '590'
  408. 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'
  409. 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'
  410. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  411. 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
  412. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '557'
  413. 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'
  414. 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'
  415. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  416. 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
  417. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '557'
  418. 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'
  419. 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'
  420. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  421. 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
  422. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1387'
  423. 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'
  424. 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'
  425. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  426. 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
  427. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1387'
  428. 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'
  429. 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'
  430. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  431. 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
  432. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '550'
  433. 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'
  434. 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'
  435. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  436. 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
  437. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '550'
  438. 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'
  439. 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'
  440. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  441. 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
  442. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1388'
  443. 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'
  444. 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'
  445. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  446. 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
  447. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1388'
  448. 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'
  449. 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'
  450. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  451. 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
  452. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '552'
  453. 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'
  454. 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'
  455. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  456. 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
  457. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '552'
  458. 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'
  459. 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'
  460. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  461. 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
  462. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '587'
  463. 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'
  464. 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'
  465. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  466. 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
  467. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '587'
  468. 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'
  469. 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'
  470. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  471. 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
  472. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '555'
  473. 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'
  474. 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'
  475. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  476. 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
  477. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '555'
  478. 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'
  479. 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'
  480. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  481. 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
  482. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '565'
  483. 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'
  484. 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'
  485. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  486. 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
  487. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '565'
  488. 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'
  489. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  490. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  491. 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;
  492. 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'

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'lqk03fi7qhfec5curon0kug2q6'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1783327046' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'lqk03fi7qhfec5curon0kug2q6'
  4. UPDATE `glenrich_session`
      SET `time`='1783330646',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1783330643;s:18:\"session.timer.last\";i:1783330645;s:17:\"session.timer.now\";i:1783330645;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:68:\"/home/u70253/glenrich.ru/www/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:6:{s:3:\"idx\";i:5;i:0;a:2:{s:10:\"product_id\";i:948;s:11:\"category_id\";s:2:\"28\";}i:1;a:2:{s:10:\"product_id\";i:660;s:11:\"category_id\";s:3:\"159\";}i:2;a:2:{s:10:\"product_id\";i:311;s:11:\"category_id\";s:2:\"41\";}i:3;a:2:{s:10:\"product_id\";i:1369;s:11:\"category_id\";s:3:\"118\";}i:4;a:2:{s:10:\"product_id\";i:1313;s:11:\"category_id\";s:2:\"18\";}}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";userstate|a:6:{s:10:\"product_id\";s:4:\"1313\";s:31:\"view28product_detailslimitstart\";i:0;s:32:\"view159product_detailslimitstart\";i:0;s:31:\"view41product_detailslimitstart\";i:0;s:32:\"view118product_detailslimitstart\";i:0;s:31:\"view18product_detailslimitstart\";i:0;}last_page|s:20:\"shop.product_details\";last_browse_parameters|a:7:{s:11:\"category_id\";N;s:15:\"manufacturer_id\";N;s:7:\"keyword\";b:0;s:8:\"keyword1\";N;s:8:\"keyword2\";N;s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}product_sess|a:14:{i:949;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:947;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:948;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783330643;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:657;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:653;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:660;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783330644;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:312;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:310;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:311;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783330644;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1092;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:1368;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:1369;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783330645;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:23;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1313;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783330646;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}'
      WHERE session_id='lqk03fi7qhfec5curon0kug2q6'
  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<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' 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<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' 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 *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=565
      AND `file_is_image`=1
      AND `file_published`=1
  49. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=565
  50. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  51. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=565
      AND `file_is_image`=0
  52. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='565'
  53. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  54. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='565'
  55. 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
  56. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='565'
  57. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  58. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=582
  59. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='582'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=582
  61. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='582'
  63. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='582'
  68. 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
  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_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=582
  71. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=582
  72. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=582
      AND `file_is_image`=1
      AND `file_published`=1
  73. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=582
  74. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  75. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=582
      AND `file_is_image`=0
  76. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='582'
  77. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  78. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='582'
  79. 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
  80. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='582'
  81. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  82. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=562
  83. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='562'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=562
  85. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  86. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='562'
  87. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='562'
  92. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=562
  95. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=562
      AND `file_is_image`=1
      AND `file_published`=1
  96. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=562
      AND `file_is_image`=0
  97. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='562'
  98. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  99. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='562'
  100. 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
  101. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='562'
  102. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  103. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=583
  104. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='583'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  105. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=583
  106. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  107. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='583'
  108. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='583'
  113. 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
  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_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=583
  116. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=583
  117. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=583
      AND `file_is_image`=1
      AND `file_published`=1
  118. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=583
  119. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  120. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=583
      AND `file_is_image`=0
  121. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='583'
  122. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  123. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='583'
  124. 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
  125. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='583'
  126. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  127. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=560
  128. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='560'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=560
  130. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='560'
  132. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='560'
  137. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=560
  140. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=560
      AND `file_is_image`=1
      AND `file_published`=1
  141. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=560
      AND `file_is_image`=0
  142. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='560'
  143. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  144. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='560'
  145. 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
  146. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='560'
  147. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  148. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=587
  149. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='587'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=587
  151. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  152. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='587'
  153. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='587'
  158. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=587
  161. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=587
      AND `file_is_image`=1
      AND `file_published`=1
  162. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=587
  163. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  164. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=587
      AND `file_is_image`=0
  165. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='587'
  166. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  167. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='587'
  168. 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
  169. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='587'
  170. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  171. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=581
  172. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='581'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  173. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=581
  174. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  175. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='581'
  176. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='581'
  181. 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
  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_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=581
  184. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=581
  185. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=581
      AND `file_is_image`=1
      AND `file_published`=1
  186. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=581
  187. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  188. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=581
      AND `file_is_image`=0
  189. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='581'
  190. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  191. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='581'
  192. 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
  193. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='581'
  194. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  195. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=590
  196. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='590'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  197. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=590
  198. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  199. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='590'
  200. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='590'
  205. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=590
  208. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=590
      AND `file_is_image`=1
      AND `file_published`=1
  209. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=590
  210. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  211. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=590
      AND `file_is_image`=0
  212. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='590'
  213. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  214. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='590'
  215. 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
  216. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='590'
  217. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  218. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=564
  219. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='564'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  220. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=564
  221. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  222. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='564'
  223. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='564'
  228. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=564
  231. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=564
      AND `file_is_image`=1
      AND `file_published`=1
  232. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=564
  233. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  234. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=564
      AND `file_is_image`=0
  235. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='564'
  236. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  237. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='564'
  238. 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
  239. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='564'
  240. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  241. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=557
  242. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='557'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  243. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=557
  244. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  245. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='557'
  246. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='557'
  251. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=557
  254. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=557
      AND `file_is_image`=1
      AND `file_published`=1
  255. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=557
      AND `file_is_image`=0
  256. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='557'
  257. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  258. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='557'
  259. 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
  260. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='557'
  261. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  262. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=558
  263. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='558'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  264. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=558
  265. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  266. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='558'
  267. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='558'
  272. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=558
  275. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=558
      AND `file_is_image`=1
      AND `file_published`=1
  276. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=558
  277. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  278. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=558
      AND `file_is_image`=0
  279. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='558'
  280. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  281. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='558'
  282. 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
  283. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='558'
  284. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  285. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=563
  286. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='563'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=563
  288. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330646' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  289. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='563'
  290. 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
  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 COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='563'
  295. 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
  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 tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=563
  298. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=563
      AND `file_is_image`=1
      AND `file_published`=1
  299. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=563
  300. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  301. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=563
      AND `file_is_image`=0
  302. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='563'
  303. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  304. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='563'
  305. 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
  306. SELECT *
      FROM glenrich_vm_product_type_3
      WHERE product_id='563'
  307. SELECT *
      FROM glenrich_vm_product_type_parameter
      WHERE product_type_id=3
      ORDER BY parameter_list_order
  308. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '1313'
      AND c.category_id = '18'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  309. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1313
  310. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '1369'
      AND c.category_id = '118'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  311. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1369
  312. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '311'
      AND c.category_id = '41'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  313. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=311
  314. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '660'
      AND c.category_id = '159'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  315. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=660
  316. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '948'
      AND c.category_id = '28'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  317. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=948
  318. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  319. 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
  320. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='590'
  321. 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
  322. 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
  323. 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
  324. 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
  325. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='590'
  326. 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'
  327. 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
  328. 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
  329. 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
  330. 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
  331. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='557'
  332. 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'
  333. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1387
  334. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1387'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  335. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1387
  336. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  337. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1387'
  338. 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
  339. 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
  340. 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
  341. 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
  342. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1387'
  343. 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'
  344. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=550
  345. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='550'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  346. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=550
  347. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  348. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='550'
  349. 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
  350. 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
  351. 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
  352. 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
  353. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='550'
  354. 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'
  355. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1388
  356. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1388'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  357. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1388
  358. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  359. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1388'
  360. 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
  361. 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
  362. 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
  363. 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
  364. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1388'
  365. 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'
  366. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=552
  367. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='552'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  368. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=552
  369. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  370. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='552'
  371. 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
  372. 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
  373. 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
  374. 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
  375. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='552'
  376. 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'
  377. 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
  378. 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
  379. 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
  380. 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
  381. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='587'
  382. 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'
  383. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=555
  384. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='555'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  385. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=555
  386. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783330647' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  387. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='555'
  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 `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
  390. 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
  391. 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
  392. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='555'
  393. 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'
  394. 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
  395. 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
  396. 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
  397. 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
  398. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='565'
  399. 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'
  400. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  401. 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
  402. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '590'
  403. 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'
  404. 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'
  405. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  406. 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
  407. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '590'
  408. 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'
  409. 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'
  410. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  411. 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
  412. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '557'
  413. 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'
  414. 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'
  415. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  416. 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
  417. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '557'
  418. 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'
  419. 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'
  420. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  421. 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
  422. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1387'
  423. 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'
  424. 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'
  425. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  426. 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
  427. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1387'
  428. 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'
  429. 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'
  430. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  431. 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
  432. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '550'
  433. 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'
  434. 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'
  435. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  436. 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
  437. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '550'
  438. 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'
  439. 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'
  440. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  441. 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
  442. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1388'
  443. 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'
  444. 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'
  445. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  446. 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
  447. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1388'
  448. 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'
  449. 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'
  450. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  451. 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
  452. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '552'
  453. 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'
  454. 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'
  455. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  456. 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
  457. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '552'
  458. 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'
  459. 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'
  460. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  461. 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
  462. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '587'
  463. 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'
  464. 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'
  465. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  466. 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
  467. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '587'
  468. 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'
  469. 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'
  470. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  471. 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
  472. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '555'
  473. 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'
  474. 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'
  475. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  476. 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
  477. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '555'
  478. 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'
  479. 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'
  480. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  481. 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
  482. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '565'
  483. 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'
  484. 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'
  485. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  486. 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
  487. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '565'
  488. 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'
  489. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  490. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  491. 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;
  492. 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'

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

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

Нет

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

Нет