Печи


Как мы строим печи - мастер класс Русские печи
Банные печи каменки Печи шведки
Варочные печи Пекарные печи
Печи отопительные Комбинированные печи
Керамические печи Кафельные печи
Изразцовые печи Чугунные печи
Камины печи

Печь отопительная ТНП47
Артикул ТНП47

Печь из крупноблочной керамики.

Подробнее
Печь шведка ПГ2
Артикул ПГ2
Ширина 720 мм.
Высота 2390 мм.
Глубина 720 мм.
Вес 1400 кг.

Подробнее
Варочная печь ВП11
Артикул ВП11

Кафельная (изразцовая) варочная печь с духовкой.

Подробнее
Варочная печь ВП19
Артикул ВП19

Подробнее
Русская печь РП10
Артикул РП10

Печь с лежанкой и духовкой.

Подробнее
Русская печь РП12
Артикул РП12

Русская печь с боковой сидушкой и подтопком

Подробнее
Банная печь БП2
Артикул БП2
Ширина 1180 мм.
Высота 2360 мм.
Глубина 1430 мм.

Эскизный проект изразцовой печи для Русской бани

Подробнее
Печь отопительная ТНП32
Артикул ТНП32

Отопительная печь из кафеля.

Подробнее
Комбинированная печь К3
Артикул К3
Ширина 1582 мм.
Высота 2840 мм.
Глубина 1015 мм.

Пекарная и отопительная печь.

Подробнее
Печь отопительная ТНП55
Артикул ТНП55

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

Кафельная печь конвекционная.

Подробнее
Печь отопительная ТНП27
Артикул ТНП27

Отопительная печь. Кафель.

Подробнее

Страница 8 из 18

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

Чугунная печь Lange L1
Артикул L1

Подробнее
Печь отопительная ТНП34
Артикул ТНП34

Подробнее
Керамическая печь КО63
Артикул КО63

Подробнее
Керамическая печь КО5
Артикул КО5

Подробнее

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

Application afterLoad: 0.000 seconds, 0.46 MB
Application afterInitialise: 0.038 seconds, 5.44 MB
Application afterRoute: 0.071 seconds, 9.07 MB
Application afterDispatch: 0.626 seconds, 22.13 MB
Application afterRender: 0.629 seconds, 22.28 MB

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

23696504

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'r2ar197jfmg43sd7c1o4v424i2'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1783330467' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'r2ar197jfmg43sd7c1o4v424i2'
  4. UPDATE `glenrich_session`
      SET `time`='1783334067',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1783334011;s:18:\"session.timer.last\";i:1783334065;s:17:\"session.timer.now\";i:1783334066;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:5:{s:3:\"idx\";i:4;i:0;a:2:{s:10:\"product_id\";i:1248;s:11:\"category_id\";s:3:\"141\";}i:1;a:2:{s:10:\"product_id\";i:1245;s:11:\"category_id\";s:3:\"141\";}i:2;a:2:{s:10:\"product_id\";i:322;s:11:\"category_id\";s:2:\"41\";}i:3;a:2:{s:10:\"product_id\";i:617;s:11:\"category_id\";s:3:\"113\";}}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";userstate|a:4:{s:10:\"product_id\";s:3:\"617\";s:32:\"view141product_detailslimitstart\";i:0;s:31:\"view41product_detailslimitstart\";i:0;s:32:\"view113product_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:11:{i:1242;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1247;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1248;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783334012;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1237;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1240;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1245;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783334012;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:323;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:321;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:322;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783334065;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:614;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:617;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783334066;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}'
      WHERE session_id='r2ar197jfmg43sd7c1o4v424i2'
  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 = 'pechi.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=2&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'pechi.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`=2
     
      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='2'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='2'
  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='2'
      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=132&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=132&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=16&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=16&lang=ru&limitstart=0&page=shop.browse'
  29. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=17&lang=ru&page=shop.browse'
  30. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  31. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=17&lang=ru&limitstart=0&page=shop.browse'
  32. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=140&lang=ru&page=shop.browse'
  33. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  34. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=140&lang=ru&limitstart=0&page=shop.browse'
  35. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=18&lang=ru&page=shop.browse'
  36. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  37. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=18&lang=ru&limitstart=0&page=shop.browse'
  38. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=19&lang=ru&page=shop.browse'
  39. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  40. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=19&lang=ru&limitstart=0&page=shop.browse'
  41. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&lang=ru&page=shop.browse'
  42. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  43. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&lang=ru&limitstart=0&page=shop.browse'
  44. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=22&lang=ru&page=shop.browse'
  45. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  46. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=22&lang=ru&limitstart=0&page=shop.browse'
  47. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=157&lang=ru&page=shop.browse'
  48. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  49. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=157&lang=ru&limitstart=0&page=shop.browse'
  50. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=23&lang=ru&page=shop.browse'
  51. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  52. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=23&lang=ru&limitstart=0&page=shop.browse'
  53. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=21&lang=ru&page=shop.browse'
  54. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  55. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=21&lang=ru&limitstart=0&page=shop.browse'
  56. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=144&lang=ru&page=shop.browse'
  57. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  58. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=144&lang=ru&limitstart=0&page=shop.browse'
  59. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=54&lang=ru&page=shop.browse'
  60. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  61. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=54&lang=ru&limitstart=0&page=shop.browse'
  62. 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='2'
      AND glenrich_vm_category.category_id='2'
  63. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
  64. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  65. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
  66. 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`=2
     
      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 84, 12
  67. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1294
  68. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1294'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  69. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1294
  70. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1294'
  72. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  73. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  74. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  75. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  76. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  77. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1294'
  78. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  80. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1294
  81. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1294
      AND `file_is_image`=1
      AND `file_published`=1
  82. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1294
  83. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  84. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1294
      AND `file_is_image`=0
  85. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1294'
  86. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  87. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1294'
  88. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1237
  89. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1237'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  90. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1237
  91. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1237'
  93. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  94. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  95. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  96. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  97. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1237'
  98. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  100. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1237
  101. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1237
      AND `file_is_image`=1
      AND `file_published`=1
  102. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1237
      AND `file_is_image`=0
  103. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1237'
  104. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1020
  105. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1020'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  106. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1020
  107. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  108. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1020'
  109. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1020
      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=1020
      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=1020
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  112. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1020
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  113. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1020'
  114. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1020
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  115. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1020
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  116. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1020
  117. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1020
      AND `file_is_image`=1
      AND `file_published`=1
  118. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1020
  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`=1020
      AND `file_is_image`=0
  121. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1020'
  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='1020'
  124. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1267
  125. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1267'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  126. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1267
  127. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  128. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1267'
  129. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1267
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  130. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1267
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  131. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1267
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  132. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1267
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  133. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1267'
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1267
      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=1267
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  136. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1267
  137. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1267
      AND `file_is_image`=1
      AND `file_published`=1
  138. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1267
  139. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  140. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1267
      AND `file_is_image`=0
  141. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1267'
  142. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  143. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1267'
  144. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1167
  145. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1167'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  146. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1167
  147. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  148. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1167'
  149. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  150. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1167'
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1167
      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=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  156. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1167
  157. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1167
      AND `file_is_image`=1
      AND `file_published`=1
  158. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1167
      AND `file_is_image`=0
  159. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1167'
  160. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  161. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1167'
  162. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1339
  163. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1339'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1339
  165. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1339'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  170. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  171. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1339'
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  173. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  174. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1339
  175. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1339
      AND `file_is_image`=1
      AND `file_published`=1
  176. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1339
      AND `file_is_image`=0
  177. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1339'
  178. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  179. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1339'
  180. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1351
  181. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1351'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1351
  183. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1351'
  185. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  186. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1351'
  190. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  191. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  192. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1351
  193. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1351
      AND `file_is_image`=1
      AND `file_published`=1
  194. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1351
      AND `file_is_image`=0
  195. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1351'
  196. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  197. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1351'
  198. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1073
  199. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1073'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1073
  201. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1073'
  203. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1073
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  204. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1073
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  205. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1073
      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=1073
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  207. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1073'
  208. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1073
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  209. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1073
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  210. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1073
  211. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1073
      AND `file_is_image`=1
      AND `file_published`=1
  212. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1073
  213. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  214. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1073
      AND `file_is_image`=0
  215. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1073'
  216. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  217. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1073'
  218. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=73
  219. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='73'
      AND (start_date<='1783334067' 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=73
  221. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' 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='73'
  223. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=73
      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=73
      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=73
      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=73
      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='73'
  228. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=73
      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=73
      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=73
  231. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=73
      AND `file_is_image`=1
      AND `file_published`=1
  232. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=73
  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`=73
      AND `file_is_image`=0
  235. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='73'
  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='73'
  238. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1317
  239. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1317'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  240. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1317
  241. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1317'
  243. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  244. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  245. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  246. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  247. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1317'
  248. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1317
      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=1317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1317
  251. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1317
      AND `file_is_image`=1
      AND `file_published`=1
  252. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1317
  253. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  254. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1317
      AND `file_is_image`=0
  255. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1317'
  256. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  257. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1317'
  258. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1307
  259. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1307'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  260. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1307
  261. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  262. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1307'
  263. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1307
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  264. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1307
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  265. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1307
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  266. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1307
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  267. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1307'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1307
      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=1307
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1307
  271. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1307
      AND `file_is_image`=1
      AND `file_published`=1
  272. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1307
  273. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  274. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1307
      AND `file_is_image`=0
  275. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1307'
  276. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  277. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1307'
  278. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1040
  279. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1040'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  280. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1040
  281. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  282. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1040'
  283. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  284. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  285. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  286. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  287. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1040'
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  289. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  290. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1040
  291. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1040
      AND `file_is_image`=1
      AND `file_published`=1
  292. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1040
      AND `file_is_image`=0
  293. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1040'
  294. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  295. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1040'
  296. 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 = '617'
      AND c.category_id = '113'
      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
  297. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=617
  298. 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 = '322'
      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
  299. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=322
  300. 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 = '1245'
      AND c.category_id = '141'
      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
  301. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1245
  302. 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 = '1248'
      AND c.category_id = '141'
      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
  303. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1248
  304. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  305. 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='2'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  306. 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`='68'
  307. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=68
  308. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='68'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  309. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=68
  310. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  311. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='68'
  312. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=68
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  313. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=68
  314. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='68'
  315. 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`='1164'
  316. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1164
  317. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1164'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  318. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1164
  319. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1164'
  321. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1164
      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=1164
      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=1164
      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=1164
      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='1164'
  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`='1019'
  327. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1019
  328. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1019'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  329. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1019
  330. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  331. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1019'
  332. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1019
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  333. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1019
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  334. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1019
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  335. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1019
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  336. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1019'
  337. 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`='361'
  338. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=361
  339. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='361'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  340. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=361
  341. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  342. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='361'
  343. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=361
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  344. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=361
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  345. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=361
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  346. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=361
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  347. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='361'
  348. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=68'
  349. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  350. 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 = 68
  351. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '68'
  352. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=68'
  353. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=68'
  354. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  355. 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 = 68
  356. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '68'
  357. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=68'
  358. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=1164'
  359. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  360. 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 = 1164
  361. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1164'
  362. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1164'
  363. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=1164'
  364. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  365. 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 = 1164
  366. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1164'
  367. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1164'
  368. 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=1019'
  369. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  370. 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 = 1019
  371. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1019'
  372. 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=1019'
  373. 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=1019'
  374. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  375. 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 = 1019
  376. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1019'
  377. 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=1019'
  378. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=361'
  379. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  380. 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 = 361
  381. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '361'
  382. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=361'
  383. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=361'
  384. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  385. 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 = 361
  386. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '361'
  387. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=361'
  388. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  389. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  390. 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;
  391. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=84&page=shop.browse'

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'r2ar197jfmg43sd7c1o4v424i2'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1783330467' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'r2ar197jfmg43sd7c1o4v424i2'
  4. UPDATE `glenrich_session`
      SET `time`='1783334067',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1783334011;s:18:\"session.timer.last\";i:1783334065;s:17:\"session.timer.now\";i:1783334066;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:5:{s:3:\"idx\";i:4;i:0;a:2:{s:10:\"product_id\";i:1248;s:11:\"category_id\";s:3:\"141\";}i:1;a:2:{s:10:\"product_id\";i:1245;s:11:\"category_id\";s:3:\"141\";}i:2;a:2:{s:10:\"product_id\";i:322;s:11:\"category_id\";s:2:\"41\";}i:3;a:2:{s:10:\"product_id\";i:617;s:11:\"category_id\";s:3:\"113\";}}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";userstate|a:4:{s:10:\"product_id\";s:3:\"617\";s:32:\"view141product_detailslimitstart\";i:0;s:31:\"view41product_detailslimitstart\";i:0;s:32:\"view113product_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:11:{i:1242;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1247;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1248;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783334012;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1237;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1240;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1245;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783334012;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:323;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:321;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:322;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783334065;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:614;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:617;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1783334066;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}'
      WHERE session_id='r2ar197jfmg43sd7c1o4v424i2'
  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 = 'pechi.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=2&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'pechi.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`=2
     
      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='2'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='2'
  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='2'
      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=132&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=132&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=16&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=16&lang=ru&limitstart=0&page=shop.browse'
  29. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=17&lang=ru&page=shop.browse'
  30. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  31. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=17&lang=ru&limitstart=0&page=shop.browse'
  32. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=140&lang=ru&page=shop.browse'
  33. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  34. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=140&lang=ru&limitstart=0&page=shop.browse'
  35. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=18&lang=ru&page=shop.browse'
  36. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  37. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=18&lang=ru&limitstart=0&page=shop.browse'
  38. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=19&lang=ru&page=shop.browse'
  39. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  40. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=19&lang=ru&limitstart=0&page=shop.browse'
  41. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&lang=ru&page=shop.browse'
  42. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  43. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&lang=ru&limitstart=0&page=shop.browse'
  44. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=22&lang=ru&page=shop.browse'
  45. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  46. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=22&lang=ru&limitstart=0&page=shop.browse'
  47. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=157&lang=ru&page=shop.browse'
  48. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  49. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=157&lang=ru&limitstart=0&page=shop.browse'
  50. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=23&lang=ru&page=shop.browse'
  51. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  52. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=23&lang=ru&limitstart=0&page=shop.browse'
  53. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=21&lang=ru&page=shop.browse'
  54. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  55. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=21&lang=ru&limitstart=0&page=shop.browse'
  56. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=144&lang=ru&page=shop.browse'
  57. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  58. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=144&lang=ru&limitstart=0&page=shop.browse'
  59. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=54&lang=ru&page=shop.browse'
  60. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  61. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=54&lang=ru&limitstart=0&page=shop.browse'
  62. 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='2'
      AND glenrich_vm_category.category_id='2'
  63. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
  64. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  65. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
  66. 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`=2
     
      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 84, 12
  67. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1294
  68. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1294'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  69. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1294
  70. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1294'
  72. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  73. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  74. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  75. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  76. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  77. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1294'
  78. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1294
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  80. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1294
  81. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1294
      AND `file_is_image`=1
      AND `file_published`=1
  82. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1294
  83. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  84. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1294
      AND `file_is_image`=0
  85. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1294'
  86. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  87. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1294'
  88. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1237
  89. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1237'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  90. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1237
  91. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1237'
  93. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  94. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  95. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  96. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  97. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1237'
  98. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1237
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  100. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1237
  101. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1237
      AND `file_is_image`=1
      AND `file_published`=1
  102. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1237
      AND `file_is_image`=0
  103. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1237'
  104. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1020
  105. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1020'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  106. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1020
  107. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  108. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1020'
  109. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1020
      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=1020
      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=1020
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  112. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1020
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  113. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1020'
  114. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1020
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  115. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1020
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  116. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1020
  117. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1020
      AND `file_is_image`=1
      AND `file_published`=1
  118. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1020
  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`=1020
      AND `file_is_image`=0
  121. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1020'
  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='1020'
  124. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1267
  125. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1267'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  126. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1267
  127. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  128. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1267'
  129. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1267
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  130. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1267
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  131. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1267
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  132. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1267
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  133. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1267'
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1267
      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=1267
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  136. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1267
  137. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1267
      AND `file_is_image`=1
      AND `file_published`=1
  138. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1267
  139. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  140. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1267
      AND `file_is_image`=0
  141. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1267'
  142. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  143. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1267'
  144. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1167
  145. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1167'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  146. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1167
  147. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  148. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1167'
  149. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  150. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1167'
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1167
      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=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  156. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1167
  157. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1167
      AND `file_is_image`=1
      AND `file_published`=1
  158. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1167
      AND `file_is_image`=0
  159. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1167'
  160. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  161. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1167'
  162. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1339
  163. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1339'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1339
  165. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1339'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  170. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  171. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1339'
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  173. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1339
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  174. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1339
  175. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1339
      AND `file_is_image`=1
      AND `file_published`=1
  176. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1339
      AND `file_is_image`=0
  177. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1339'
  178. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  179. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1339'
  180. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1351
  181. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1351'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1351
  183. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1351'
  185. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  186. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1351'
  190. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  191. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1351
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  192. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1351
  193. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1351
      AND `file_is_image`=1
      AND `file_published`=1
  194. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1351
      AND `file_is_image`=0
  195. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1351'
  196. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  197. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1351'
  198. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1073
  199. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1073'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1073
  201. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1073'
  203. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1073
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  204. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1073
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  205. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1073
      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=1073
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  207. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1073'
  208. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1073
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  209. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1073
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  210. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1073
  211. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1073
      AND `file_is_image`=1
      AND `file_published`=1
  212. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1073
  213. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  214. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1073
      AND `file_is_image`=0
  215. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1073'
  216. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  217. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1073'
  218. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=73
  219. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='73'
      AND (start_date<='1783334067' 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=73
  221. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' 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='73'
  223. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=73
      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=73
      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=73
      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=73
      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='73'
  228. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=73
      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=73
      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=73
  231. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=73
      AND `file_is_image`=1
      AND `file_published`=1
  232. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=73
  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`=73
      AND `file_is_image`=0
  235. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='73'
  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='73'
  238. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1317
  239. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1317'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  240. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1317
  241. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1317'
  243. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  244. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  245. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  246. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  247. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1317'
  248. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1317
      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=1317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1317
  251. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1317
      AND `file_is_image`=1
      AND `file_published`=1
  252. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1317
  253. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  254. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1317
      AND `file_is_image`=0
  255. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1317'
  256. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  257. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1317'
  258. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1307
  259. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1307'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  260. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1307
  261. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  262. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1307'
  263. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1307
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  264. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1307
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  265. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1307
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  266. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1307
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  267. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1307'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1307
      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=1307
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1307
  271. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1307
      AND `file_is_image`=1
      AND `file_published`=1
  272. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1307
  273. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  274. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1307
      AND `file_is_image`=0
  275. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1307'
  276. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  277. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1307'
  278. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1040
  279. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1040'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  280. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1040
  281. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334067' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  282. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1040'
  283. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  284. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  285. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  286. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  287. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1040'
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  289. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1040
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  290. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1040
  291. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1040
      AND `file_is_image`=1
      AND `file_published`=1
  292. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1040
      AND `file_is_image`=0
  293. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1040'
  294. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  295. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1040'
  296. 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 = '617'
      AND c.category_id = '113'
      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
  297. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=617
  298. 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 = '322'
      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
  299. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=322
  300. 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 = '1245'
      AND c.category_id = '141'
      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
  301. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1245
  302. 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 = '1248'
      AND c.category_id = '141'
      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
  303. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1248
  304. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  305. 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='2'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  306. 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`='68'
  307. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=68
  308. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='68'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  309. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=68
  310. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  311. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='68'
  312. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=68
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  313. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=68
  314. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='68'
  315. 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`='1164'
  316. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1164
  317. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1164'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  318. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1164
  319. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1164'
  321. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1164
      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=1164
      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=1164
      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=1164
      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='1164'
  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`='1019'
  327. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1019
  328. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1019'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  329. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1019
  330. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  331. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1019'
  332. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1019
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  333. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1019
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  334. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1019
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  335. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1019
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  336. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1019'
  337. 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`='361'
  338. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=361
  339. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='361'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  340. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=361
  341. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1783334068' OR start_date=0)
      AND (end_date>='1783294560' OR end_date=0)
      AND product_discount_id=discount_id
  342. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='361'
  343. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=361
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  344. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=361
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  345. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=361
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  346. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=361
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  347. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='361'
  348. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=68'
  349. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  350. 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 = 68
  351. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '68'
  352. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=68'
  353. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=68'
  354. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  355. 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 = 68
  356. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '68'
  357. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=68'
  358. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=1164'
  359. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  360. 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 = 1164
  361. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1164'
  362. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1164'
  363. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=1164'
  364. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  365. 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 = 1164
  366. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1164'
  367. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1164'
  368. 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=1019'
  369. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  370. 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 = 1019
  371. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1019'
  372. 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=1019'
  373. 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=1019'
  374. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  375. 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 = 1019
  376. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1019'
  377. 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=1019'
  378. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=361'
  379. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  380. 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 = 361
  381. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '361'
  382. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=361'
  383. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=361'
  384. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  385. 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 = 361
  386. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '361'
  387. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=361'
  388. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  389. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  390. 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;
  391. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=84&page=shop.browse'

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

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

Нет

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

Нет