Печи


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

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

Подробнее
Печь шведка ПГ 14
Артикул ПГ 14
Ширина 960 мм.
Высота 2430 мм.
Глубина 600 мм.
Вес 1400 кг.

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

Печь круглая.

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

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

Подробнее
Изразцовая печь ИП41
Артикул ИП41

Изразцовая печь с росписью.

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

Кафельная печь.

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

Русская классическая печь с подтопком и отделкой кафелем ручной росписи

Подробнее
Банная печь БП18
Артикул БП18
Ширина 1356 мм.
Высота 2574 мм.
Глубина 1017 мм.

Изразцовая печь-каменка для Русской бани с подиумом

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

Подробнее
Изразцовая печь КП18
Артикул ИП18

Круглая печь на "ножках".

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

Отопительная печь, мотивный кафель (животные).

Подробнее

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

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

Керамическая печь КО63
Артикул КО63

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

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

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

Подробнее

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

Application afterLoad: 0.000 seconds, 0.46 MB
Application afterInitialise: 0.045 seconds, 5.47 MB
Application afterRoute: 0.084 seconds, 9.10 MB
Application afterDispatch: 0.584 seconds, 22.14 MB
Application afterRender: 0.586 seconds, 22.29 MB

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

23708480

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = '0hgmd2b35iskmjlhchkpqc1db3'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1785250988' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = '0hgmd2b35iskmjlhchkpqc1db3'
  4. UPDATE `glenrich_session`
      SET `time`='1785254588',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1785254586;s:18:\"session.timer.last\";i:1785254586;s:17:\"session.timer.now\";i:1785254587;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:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"com_content\";a:1:{s:4:\"data\";O:8:\"stdClass\":2:{s:2:\"sh\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":1:{s:7:\"default\";O:8:\"stdClass\":1:{s:5:\"limit\";s:2:\"10\";}}}s:7:\"default\";O:8:\"stdClass\":1:{s:5:\"limit\";i:10;}}}}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:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";userstate|a:2:{s:10:\"product_id\";i:0;s:21:\"view1browselimitstart\";s:2:\"60\";}last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:1:\"1\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}product_sess|a:22:{i:533;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:444;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:88;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:330;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:524;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:425;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:109;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:547;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:460;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:538;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:449;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:416;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:614;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:408;a:3:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";}i:439;a:3:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";}i:598;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:412;a:3:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";}i:610;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1013;a:3:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";}i:176;a:4:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1191;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1165;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}'
      WHERE session_id='0hgmd2b35iskmjlhchkpqc1db3'
  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 48, 12
  67. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1315
  68. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1315'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  69. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1315
  70. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1315'
  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=1315
      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=1315
      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=1315
      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=1315
      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='1315'
  78. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1315
      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=1315
      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=1315
  81. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1315
      AND `file_is_image`=1
      AND `file_published`=1
  82. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1315
  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`=1315
      AND `file_is_image`=0
  85. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1315'
  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='1315'
  88. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1249
  89. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1249'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  90. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1249
  91. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1249'
  93. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1249
      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=1249
      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=1249
      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=1249
      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='1249'
  98. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1249
      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=1249
      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=1249
  101. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1249
      AND `file_is_image`=1
      AND `file_published`=1
  102. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1249
      AND `file_is_image`=0
  103. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1249'
  104. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  105. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1249'
  106. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1028
  107. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1028'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  108. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1028
  109. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  110. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1028'
  111. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1028
      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=1028
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  113. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1028
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  114. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1028
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  115. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1028'
  116. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1028
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  117. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1028
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  118. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1028
  119. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1028
      AND `file_is_image`=1
      AND `file_published`=1
  120. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1028
  121. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  122. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1028
      AND `file_is_image`=0
  123. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1028'
  124. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  125. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1028'
  126. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1303
  127. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1303'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  128. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1303
  129. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  130. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1303'
  131. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1303
      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=1303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  133. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  135. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1303'
  136. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  137. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  138. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1303
  139. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1303
      AND `file_is_image`=1
      AND `file_published`=1
  140. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1303
  141. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  142. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1303
      AND `file_is_image`=0
  143. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1303'
  144. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  145. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1303'
  146. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1240
  147. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1240'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  148. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1240
  149. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1240'
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1240
      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=1240
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1240
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1240
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  155. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1240'
  156. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1240
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  157. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1240
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  158. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1240
  159. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1240
      AND `file_is_image`=1
      AND `file_published`=1
  160. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1240
      AND `file_is_image`=0
  161. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1240'
  162. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1273
  163. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1273'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1273
  165. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1273'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1273
      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=1273
      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=1273
      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=1273
      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='1273'
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1273
      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=1273
      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=1273
  175. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1273
      AND `file_is_image`=1
      AND `file_published`=1
  176. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1273
  177. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  178. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1273
      AND `file_is_image`=0
  179. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1273'
  180. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  181. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1273'
  182. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=341
  183. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='341'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=341
  185. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  186. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='341'
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=341
      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=341
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=341
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  190. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=341
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  191. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='341'
  192. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=341
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  193. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=341
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  194. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=341
  195. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=341
      AND `file_is_image`=1
      AND `file_published`=1
  196. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=341
  197. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  198. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=341
      AND `file_is_image`=0
  199. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='341'
  200. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  201. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='341'
  202. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1174
  203. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1174'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1174
  205. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1174'
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1174
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1174
      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=1174
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  210. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1174
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  211. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1174'
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1174
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1174
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  214. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1174
  215. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1174
      AND `file_is_image`=1
      AND `file_published`=1
  216. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1174
  217. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  218. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1174
      AND `file_is_image`=0
  219. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1174'
  220. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  221. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1174'
  222. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1433
  223. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1433'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  224. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1433
  225. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  226. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1433'
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1433
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1433
      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=1433
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  230. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1433
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1433'
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1433
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1433
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  234. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1433
  235. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1433
      AND `file_is_image`=1
      AND `file_published`=1
  236. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1433
      AND `file_is_image`=0
  237. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1433'
  238. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  239. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1433'
  240. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1261
  241. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1261'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1261
  243. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1261'
  245. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1261
      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=1261
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  247. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1261
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  248. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1261
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1261'
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1261
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  251. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1261
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  252. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1261
  253. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1261
      AND `file_is_image`=1
      AND `file_published`=1
  254. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1261
  255. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  256. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1261
      AND `file_is_image`=0
  257. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1261'
  258. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  259. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1261'
  260. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1320
  261. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1320'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  262. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1320
  263. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  264. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1320'
  265. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1320
      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=1320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  267. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  269. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1320'
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1320
  273. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1320
      AND `file_is_image`=1
      AND `file_published`=1
  274. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1320
  275. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  276. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1320
      AND `file_is_image`=0
  277. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1320'
  278. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  279. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1320'
  280. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1045
  281. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1045'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  282. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1045
  283. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  284. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1045'
  285. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1045
      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=1045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  287. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  289. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1045'
  290. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  291. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  292. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1045
  293. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1045
      AND `file_is_image`=1
      AND `file_published`=1
  294. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1045
      AND `file_is_image`=0
  295. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1045'
  296. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  297. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1045'
  298. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  299. 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
  300. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='1019'
  301. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1019
  302. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1019'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  303. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1019
  304. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1019'
  306. 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
  307. 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
  308. 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
  309. 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
  310. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1019'
  311. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='1164'
  312. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1164
  313. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1164'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  314. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1164
  315. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  316. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1164'
  317. 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
  318. 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
  319. 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
  320. 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
  321. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1164'
  322. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='361'
  323. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=361
  324. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='361'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  325. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=361
  326. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  327. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='361'
  328. 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
  329. 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
  330. 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
  331. 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
  332. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='361'
  333. 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'
  334. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=68
  335. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='68'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  336. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=68
  337. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  338. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='68'
  339. 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
  340. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=68
  341. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='68'
  342. 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'
  343. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  344. 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
  345. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1019'
  346. 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'
  347. 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'
  348. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  349. 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
  350. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1019'
  351. 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'
  352. 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'
  353. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  354. 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
  355. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1164'
  356. 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'
  357. 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'
  358. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  359. 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
  360. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1164'
  361. 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'
  362. 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'
  363. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  364. 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
  365. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '361'
  366. 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'
  367. 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'
  368. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  369. 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
  370. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '361'
  371. 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'
  372. 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'
  373. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  374. 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
  375. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '68'
  376. 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'
  377. 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'
  378. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  379. 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
  380. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '68'
  381. 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'
  382. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  383. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  384. 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;
  385. 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=48&page=shop.browse'

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = '0hgmd2b35iskmjlhchkpqc1db3'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1785250988' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = '0hgmd2b35iskmjlhchkpqc1db3'
  4. UPDATE `glenrich_session`
      SET `time`='1785254588',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1785254586;s:18:\"session.timer.last\";i:1785254586;s:17:\"session.timer.now\";i:1785254587;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:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"com_content\";a:1:{s:4:\"data\";O:8:\"stdClass\":2:{s:2:\"sh\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":1:{s:7:\"default\";O:8:\"stdClass\":1:{s:5:\"limit\";s:2:\"10\";}}}s:7:\"default\";O:8:\"stdClass\":1:{s:5:\"limit\";i:10;}}}}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:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";userstate|a:2:{s:10:\"product_id\";i:0;s:21:\"view1browselimitstart\";s:2:\"60\";}last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:1:\"1\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}product_sess|a:22:{i:533;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:444;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:88;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:330;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:524;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:425;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:109;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:547;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:460;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:538;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:449;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:416;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:614;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:408;a:3:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";}i:439;a:3:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";}i:598;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:412;a:3:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";}i:610;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1013;a:3:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";}i:176;a:4:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1191;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1165;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1785254586;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}'
      WHERE session_id='0hgmd2b35iskmjlhchkpqc1db3'
  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 48, 12
  67. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1315
  68. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1315'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  69. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1315
  70. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1315'
  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=1315
      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=1315
      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=1315
      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=1315
      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='1315'
  78. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1315
      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=1315
      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=1315
  81. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1315
      AND `file_is_image`=1
      AND `file_published`=1
  82. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1315
  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`=1315
      AND `file_is_image`=0
  85. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1315'
  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='1315'
  88. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1249
  89. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1249'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  90. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1249
  91. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1249'
  93. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1249
      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=1249
      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=1249
      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=1249
      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='1249'
  98. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1249
      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=1249
      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=1249
  101. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1249
      AND `file_is_image`=1
      AND `file_published`=1
  102. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1249
      AND `file_is_image`=0
  103. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1249'
  104. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  105. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1249'
  106. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1028
  107. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1028'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  108. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1028
  109. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  110. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1028'
  111. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1028
      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=1028
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  113. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1028
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  114. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1028
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  115. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1028'
  116. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1028
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  117. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1028
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  118. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1028
  119. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1028
      AND `file_is_image`=1
      AND `file_published`=1
  120. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1028
  121. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  122. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1028
      AND `file_is_image`=0
  123. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1028'
  124. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  125. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1028'
  126. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1303
  127. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1303'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  128. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1303
  129. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  130. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1303'
  131. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1303
      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=1303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  133. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  135. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1303'
  136. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  137. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  138. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1303
  139. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1303
      AND `file_is_image`=1
      AND `file_published`=1
  140. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1303
  141. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  142. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1303
      AND `file_is_image`=0
  143. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1303'
  144. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  145. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1303'
  146. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1240
  147. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1240'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  148. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1240
  149. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1240'
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1240
      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=1240
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1240
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1240
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  155. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1240'
  156. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1240
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  157. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1240
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  158. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1240
  159. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1240
      AND `file_is_image`=1
      AND `file_published`=1
  160. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1240
      AND `file_is_image`=0
  161. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1240'
  162. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1273
  163. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1273'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1273
  165. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1273'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1273
      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=1273
      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=1273
      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=1273
      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='1273'
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1273
      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=1273
      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=1273
  175. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1273
      AND `file_is_image`=1
      AND `file_published`=1
  176. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1273
  177. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  178. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1273
      AND `file_is_image`=0
  179. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1273'
  180. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  181. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1273'
  182. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=341
  183. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='341'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=341
  185. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  186. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='341'
  187. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=341
      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=341
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=341
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  190. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=341
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  191. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='341'
  192. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=341
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  193. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=341
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  194. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=341
  195. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=341
      AND `file_is_image`=1
      AND `file_published`=1
  196. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=341
  197. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  198. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=341
      AND `file_is_image`=0
  199. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='341'
  200. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  201. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='341'
  202. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1174
  203. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1174'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1174
  205. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1174'
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1174
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1174
      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=1174
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  210. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1174
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  211. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1174'
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1174
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1174
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  214. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1174
  215. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1174
      AND `file_is_image`=1
      AND `file_published`=1
  216. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1174
  217. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  218. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1174
      AND `file_is_image`=0
  219. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1174'
  220. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  221. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1174'
  222. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1433
  223. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1433'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  224. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1433
  225. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  226. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1433'
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1433
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1433
      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=1433
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  230. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1433
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1433'
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1433
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1433
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  234. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1433
  235. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1433
      AND `file_is_image`=1
      AND `file_published`=1
  236. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1433
      AND `file_is_image`=0
  237. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1433'
  238. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  239. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1433'
  240. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1261
  241. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1261'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1261
  243. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1261'
  245. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1261
      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=1261
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  247. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1261
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  248. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1261
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1261'
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1261
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  251. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1261
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  252. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1261
  253. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1261
      AND `file_is_image`=1
      AND `file_published`=1
  254. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1261
  255. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  256. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1261
      AND `file_is_image`=0
  257. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1261'
  258. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  259. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1261'
  260. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1320
  261. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1320'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  262. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1320
  263. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  264. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1320'
  265. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1320
      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=1320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  267. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  269. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1320'
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1320
  273. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1320
      AND `file_is_image`=1
      AND `file_published`=1
  274. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1320
  275. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  276. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1320
      AND `file_is_image`=0
  277. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1320'
  278. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  279. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1320'
  280. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1045
  281. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1045'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  282. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1045
  283. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  284. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1045'
  285. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1045
      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=1045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  287. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  289. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1045'
  290. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  291. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  292. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1045
  293. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1045
      AND `file_is_image`=1
      AND `file_published`=1
  294. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1045
      AND `file_is_image`=0
  295. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='1045'
  296. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  297. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1045'
  298. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  299. 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
  300. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='1019'
  301. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1019
  302. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1019'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  303. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1019
  304. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1019'
  306. 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
  307. 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
  308. 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
  309. 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
  310. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1019'
  311. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='1164'
  312. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1164
  313. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1164'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  314. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1164
  315. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  316. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1164'
  317. 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
  318. 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
  319. 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
  320. 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
  321. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1164'
  322. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

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

                           
      WHERE `glenrich_vm_product`.`product_id`='361'
  323. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=361
  324. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='361'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  325. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=361
  326. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  327. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='361'
  328. 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
  329. 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
  330. 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
  331. 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
  332. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='361'
  333. 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'
  334. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=68
  335. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='68'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  336. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=68
  337. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1785254588' OR start_date=0)
      AND (end_date>='1785195360' OR end_date=0)
      AND product_discount_id=discount_id
  338. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='68'
  339. 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
  340. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=68
  341. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='68'
  342. 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'
  343. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  344. 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
  345. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1019'
  346. 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'
  347. 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'
  348. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  349. 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
  350. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1019'
  351. 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'
  352. 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'
  353. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  354. 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
  355. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1164'
  356. 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'
  357. 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'
  358. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  359. 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
  360. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1164'
  361. 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'
  362. 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'
  363. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  364. 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
  365. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '361'
  366. 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'
  367. 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'
  368. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  369. 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
  370. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '361'
  371. 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'
  372. 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'
  373. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  374. 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
  375. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '68'
  376. 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'
  377. 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'
  378. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  379. 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
  380. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '68'
  381. 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'
  382. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  383. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  384. 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;
  385. 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=48&page=shop.browse'

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

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

Нет

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

Нет