Камины


Как мы строим камины - мастер класс Изразцовые камины
Мраморные камины Камины Дворцовые и Замковые
Чугунные камины Малахитовые камины
Камины с облицовкой из камня Камины с облицовкой из дерева
Камины металлические Камины в стиле Минимализм
Английские камины Каминные топки BRUNNER
Каминные топки RUEGG Каминные топки SPARTHERM
Аксессуары для каминов

Английский камин АК40
Артикул АК40
Цена 1910 €
Ширина 710 мм.
Высота 1000 мм.
Глубина 140 мм.

Стиль: Модерн
Отделка: Черный

Подробнее
Английский камин АК41
Артикул АК41
Цена 1887 €
Ширина 710 мм.
Высота 1000 мм.
Глубина 140 мм.

Стиль: Модерн
Отделка: Полированный

Подробнее
Английский камин АК42
Артикул АК42
Цена 1775 €
Ширина 720 мм.
Высота 870 мм.
Глубина 150 мм.

Стиль: Модерн
Отделка: Частично полированный

Подробнее
Английский камин АК43
Артикул АК43
Цена 1877 €
Ширина 720 мм.
Высота 870 мм.
Глубина 150 мм.

Стиль: Модерн
Отделка: Полированный

Подробнее
Английский камин АК44
Артикул АК44
Цена 2100 €
Ширина 1040 мм.
Высота 1140 мм.
Глубина 160 мм.

Стиль: Викторианский
Отделка: Полированный

Подробнее
Английский камин АК45
Артикул АК45
Цена 1965 €
Ширина 1040 мм.
Высота 1140 мм.
Глубина 160 мм.

Стиль: Викторианский
Отделка: Черный

Подробнее
Английский камин АК47
Артикул АК47
Цена 2750 €
Ширина 1360 мм.
Высота 1310 мм.
Глубина 180 мм.

Стиль: Георгианский
Отделка: Черный

Подробнее
Английский камин АК46
Артикул АК46
Цена 2780 €
Ширина 1360 мм.
Высота 1310 мм.
Глубина 180 мм.

Стиль: Георгианский
Отделка: Полированный

Подробнее
Английский камин АК48
Артикул АК48
Цена 2548 €
Ширина 1510 мм.
Высота 1220 мм.
Глубина 280 мм.

Стиль: Георгианский
Отделка: Черный

Подробнее
Английский камин АК49
Артикул АК49
Цена 2388 €
Ширина 1510 мм.
Высота 1220 мм.
Глубина 280 мм.

Стиль: Георгианский
Отделка: Частично полированный

Подробнее
Английский камин АК50
Артикул АК50
Цена 2399 €
Ширина 1510 мм.
Высота 1220 мм.
Глубина 280 мм.

Стиль: Георгианский
Отделка: Полированный

Подробнее
Английский камин АК52
Артикул АК52
Цена 2750 €
Ширина 1360 мм.
Высота 1310 мм.
Глубина 220 мм.

Стиль: Ранний викторианский
Отделка: Черный

Подробнее

Страница 35 из 37

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

Изразцовый камин ИК44
Артикул ИК44

Подробнее
Английский камин АК70
Артикул АК70

Подробнее
Топка Architektur-Kamine 53/121 f
Артикул 53/121 f

Подробнее
Топка Architektur-Kamine 53/135 f
Артикул 53/135 f

Подробнее
Топка Eck-Kamine 53/121/50 R
Артикул 53/121/50 R

Подробнее
Топка EllipseR
Артикул EllipseR

Подробнее
Малахитовый камин МЛ1
Артикул МЛ1

Подробнее
Топка Architektur-Kamine 53/121 t
Артикул 53/121 t

Подробнее
Топка Jupiter HK
Артикул Jupiter HK

Подробнее
Английский камин АК12
Артикул АК12

Подробнее

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

Application afterLoad: 0.000 seconds, 0.45 MB
Application afterInitialise: 0.039 seconds, 5.41 MB
Application afterRoute: 0.074 seconds, 9.03 MB
Application afterDispatch: 0.703 seconds, 22.22 MB
Application afterRender: 0.705 seconds, 22.38 MB

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

23802368

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'o8ag9v7saa6a2dor4g3molq4i2'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1787645842' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'o8ag9v7saa6a2dor4g3molq4i2'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'o8ag9v7saa6a2dor4g3molq4i2','1787649442','','0','1','0' )
  5. SELECT *
      FROM glenrich_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM glenrich_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT oldurl, newurl
      FROM glenrich_redirection
      WHERE oldurl = 'kaminy.html'
      ORDER BY rank ASC
      LIMIT 1
  8. UPDATE glenrich_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'kaminy.html'
  9. SELECT m.*, c.`option` AS component
      FROM glenrich_menu AS m
      LEFT JOIN glenrich_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  10. SELECT m.*, c.`option` AS component
      FROM glenrich_menu AS m
      LEFT JOIN glenrich_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  11. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  12. SELECT glenrich_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `glenrich_vm_shopper_group`
      WHERE glenrich_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  13. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`glenrich_vm_vendor` v, `glenrich_vm_country` c)
                                   
      LEFT JOIN glenrich_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  14. SELECT module_perms
      FROM glenrich_vm_module
      WHERE module_name='shop'
  15. SELECT id
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  16. SELECT COUNT(*) AS parentcnt
      FROM glenrich_vm_product
      WHERE product_parent_id>0
  17. SELECT COUNT(DISTINCT `glenrich_vm_product`.`product_sku`) AS num_rows
      FROM (`glenrich_vm_product`, `glenrich_vm_category`, `glenrich_vm_product_category_xref`,`glenrich_vm_shopper_group`)
      LEFT JOIN `glenrich_vm_product_price`
      ON `glenrich_vm_product`.`product_id` = `glenrich_vm_product_price`.`product_id`
      WHERE `glenrich_vm_product_category_xref`.`product_id`=`glenrich_vm_product`.`product_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=`glenrich_vm_category`.`category_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=1
     
      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='1'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='1'
  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='1'
      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=133&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=133&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=11&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=11&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=12&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=12&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=13&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=13&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=162&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=162&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=125&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=125&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=14&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=14&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=15&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=15&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=24&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=24&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=25&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=25&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=56&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=56&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=60&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=60&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=61&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=61&lang=ru&limitstart=0&page=shop.browse'
  62. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  63. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  64. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  65. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
  66. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  67. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
  68. 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='1'
      AND glenrich_vm_category.category_id='1'
  69. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  70. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  71. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  72. 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`=1
     
      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 408, 12
  73. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=152
  74. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='152'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  75. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=152
  76. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  77. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='152'
  78. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=152
      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=152
  81. SELECT `tax_rate`
      FROM glenrich_vm_vendor, glenrich_vm_tax_rate
      WHERE tax_country=vendor_country
      AND glenrich_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  82. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='152'
  83. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=152
  84. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=152
      AND `file_is_image`=1
      AND `file_published`=1
  85. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=152
      AND `file_is_image`=0
  86. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='152'
  87. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=153
  88. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='153'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  89. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=153
  90. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  91. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='153'
  92. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=153
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  93. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=153
  94. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='153'
  95. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=153
  96. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=153
      AND `file_is_image`=1
      AND `file_published`=1
  97. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=153
      AND `file_is_image`=0
  98. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='153'
  99. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=154
  100. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='154'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=154
  102. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  103. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='154'
  104. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=154
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  105. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=154
  106. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='154'
  107. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=154
  108. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=154
      AND `file_is_image`=1
      AND `file_published`=1
  109. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=154
      AND `file_is_image`=0
  110. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='154'
  111. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=155
  112. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='155'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  113. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=155
  114. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='155'
  116. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=155
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  117. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=155
  118. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='155'
  119. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=155
  120. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=155
      AND `file_is_image`=1
      AND `file_published`=1
  121. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=155
      AND `file_is_image`=0
  122. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='155'
  123. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=156
  124. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='156'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  125. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=156
  126. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  127. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='156'
  128. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=156
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  129. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=156
  130. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='156'
  131. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=156
  132. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=156
      AND `file_is_image`=1
      AND `file_published`=1
  133. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=156
      AND `file_is_image`=0
  134. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='156'
  135. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=157
  136. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='157'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  137. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=157
  138. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='157'
  140. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=157
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  141. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=157
  142. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='157'
  143. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=157
  144. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=157
      AND `file_is_image`=1
      AND `file_published`=1
  145. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=157
      AND `file_is_image`=0
  146. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='157'
  147. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=159
  148. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='159'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=159
  150. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='159'
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=159
  154. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='159'
  155. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=159
  156. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=159
      AND `file_is_image`=1
      AND `file_published`=1
  157. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=159
      AND `file_is_image`=0
  158. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='159'
  159. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=158
  160. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='158'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  161. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=158
  162. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  163. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='158'
  164. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=158
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  165. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=158
  166. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='158'
  167. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=158
  168. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=158
      AND `file_is_image`=1
      AND `file_published`=1
  169. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=158
      AND `file_is_image`=0
  170. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='158'
  171. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=160
  172. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='160'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  173. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=160
  174. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  175. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='160'
  176. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=160
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  177. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=160
  178. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='160'
  179. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=160
  180. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=160
      AND `file_is_image`=1
      AND `file_published`=1
  181. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=160
      AND `file_is_image`=0
  182. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='160'
  183. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=161
  184. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='161'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=161
  186. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  187. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='161'
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=161
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=161
  190. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='161'
  191. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=161
  192. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=161
      AND `file_is_image`=1
      AND `file_published`=1
  193. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=161
      AND `file_is_image`=0
  194. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='161'
  195. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=162
  196. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='162'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  197. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=162
  198. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  199. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='162'
  200. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=162
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  201. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=162
  202. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='162'
  203. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=162
  204. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=162
      AND `file_is_image`=1
      AND `file_published`=1
  205. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=162
      AND `file_is_image`=0
  206. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='162'
  207. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=164
  208. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='164'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  209. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=164
  210. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  211. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='164'
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=164
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=164
  214. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='164'
  215. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=164
  216. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=164
      AND `file_is_image`=1
      AND `file_published`=1
  217. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=164
      AND `file_is_image`=0
  218. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='164'
  219. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  220. 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='1'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  221. 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`='1354'
  222. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1354
  223. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1354'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  224. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1354
  225. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  226. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1354'
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1354
      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=1354
      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=1354
      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=1354
      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='1354'
  232. 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`='182'
  233. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=182
  234. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='182'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  235. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=182
  236. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  237. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='182'
  238. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=182
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  239. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  240. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  241. 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`='408'
  242. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=408
  243. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='408'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=408
  245. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  246. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='408'
  247. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      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=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  251. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='408'
  252. 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`='412'
  253. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=412
  254. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='412'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=412
  256. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  257. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='412'
  258. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=412
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  259. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=412
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  260. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=412
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  261. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=412
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  262. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='412'
  263. 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`='439'
  264. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=439
  265. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='439'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  266. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=439
  267. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='439'
  269. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      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=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  273. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='439'
  274. 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`='610'
  275. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=610
  276. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='610'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  277. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=610
  278. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  279. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='610'
  280. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=610
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  281. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=610
  282. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='610'
  283. 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`='1013'
  284. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1013
  285. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1013'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  286. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1013
  287. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  288. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1013'
  289. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  290. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      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=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  292. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  293. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1013'
  294. 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`='411'
  295. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=411
  296. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='411'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  297. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=411
  298. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  299. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='411'
  300. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=411
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  301. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=411
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  302. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=411
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  303. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=411
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  304. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='411'
  305. 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`='614'
  306. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=614
  307. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='614'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  308. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=614
  309. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  310. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='614'
  311. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=614
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  312. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=614
  313. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='614'
  314. 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`='124'
  315. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=124
  316. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='124'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  317. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=124
  318. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='124'
  320. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  321. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  322. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  323. 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=1354'
  324. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  325. 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 = 1354
  326. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1354'
  327. 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=1354'
  328. 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=1354'
  329. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  330. 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 = 1354
  331. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1354'
  332. 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=1354'
  333. 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=182'
  334. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  335. 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 = 182
  336. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  337. 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=182'
  338. 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=182'
  339. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  340. 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 = 182
  341. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  342. 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=182'
  343. 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=408'
  344. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  345. 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 = 408
  346. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '408'
  347. 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=408'
  348. 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=408'
  349. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  350. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 408
  351. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '408'
  352. 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=408'
  353. 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=412'
  354. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  355. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 412
  356. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '412'
  357. 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=412'
  358. 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=412'
  359. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  360. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 412
  361. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '412'
  362. 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=412'
  363. 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=439'
  364. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  365. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 439
  366. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '439'
  367. 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=439'
  368. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=439'
  369. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  370. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 439
  371. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '439'
  372. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=439'
  373. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=610'
  374. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  375. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  376. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  377. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=610'
  378. 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=610'
  379. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  380. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  381. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  382. 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=610'
  383. 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=1013'
  384. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  385. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1013
  386. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1013'
  387. 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=1013'
  388. 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=1013'
  389. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  390. 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 = 1013
  391. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1013'
  392. 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=1013'
  393. 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=411'
  394. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  395. 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 = 411
  396. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '411'
  397. 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=411'
  398. 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=411'
  399. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  400. 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 = 411
  401. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '411'
  402. 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=411'
  403. 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=614'
  404. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  405. 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 = 614
  406. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  407. 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=614'
  408. 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=614'
  409. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  410. 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 = 614
  411. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  412. 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=614'
  413. 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=124'
  414. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  415. 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 = 124
  416. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  417. 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=124'
  418. 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=124'
  419. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  420. 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 = 124
  421. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  422. 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=124'
  423. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  424. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  425. 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;
  426. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=408&page=shop.browse'

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'o8ag9v7saa6a2dor4g3molq4i2'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1787645842' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'o8ag9v7saa6a2dor4g3molq4i2'
  4. INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'o8ag9v7saa6a2dor4g3molq4i2','1787649442','','0','1','0' )
  5. SELECT *
      FROM glenrich_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM glenrich_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT oldurl, newurl
      FROM glenrich_redirection
      WHERE oldurl = 'kaminy.html'
      ORDER BY rank ASC
      LIMIT 1
  8. UPDATE glenrich_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'kaminy.html'
  9. SELECT m.*, c.`option` AS component
      FROM glenrich_menu AS m
      LEFT JOIN glenrich_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  10. SELECT m.*, c.`option` AS component
      FROM glenrich_menu AS m
      LEFT JOIN glenrich_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  11. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  12. SELECT glenrich_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `glenrich_vm_shopper_group`
      WHERE glenrich_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  13. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`glenrich_vm_vendor` v, `glenrich_vm_country` c)
                                   
      LEFT JOIN glenrich_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  14. SELECT module_perms
      FROM glenrich_vm_module
      WHERE module_name='shop'
  15. SELECT id
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  16. SELECT COUNT(*) AS parentcnt
      FROM glenrich_vm_product
      WHERE product_parent_id>0
  17. SELECT COUNT(DISTINCT `glenrich_vm_product`.`product_sku`) AS num_rows
      FROM (`glenrich_vm_product`, `glenrich_vm_category`, `glenrich_vm_product_category_xref`,`glenrich_vm_shopper_group`)
      LEFT JOIN `glenrich_vm_product_price`
      ON `glenrich_vm_product`.`product_id` = `glenrich_vm_product_price`.`product_id`
      WHERE `glenrich_vm_product_category_xref`.`product_id`=`glenrich_vm_product`.`product_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=`glenrich_vm_category`.`category_id`
     
      AND `glenrich_vm_product_category_xref`.`category_id`=1
     
      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='1'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='1'
  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='1'
      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=133&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=133&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=11&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=11&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=12&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=12&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=13&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=13&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=162&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=162&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=125&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=125&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=14&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=14&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=15&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=15&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=24&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=24&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=25&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=25&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=56&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=56&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=60&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=60&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=61&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=61&lang=ru&limitstart=0&page=shop.browse'
  62. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  63. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  64. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  65. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
  66. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  67. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
  68. 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='1'
      AND glenrich_vm_category.category_id='1'
  69. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  70. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  71. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  72. 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`=1
     
      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 408, 12
  73. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=152
  74. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='152'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  75. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=152
  76. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  77. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='152'
  78. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=152
      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=152
  81. SELECT `tax_rate`
      FROM glenrich_vm_vendor, glenrich_vm_tax_rate
      WHERE tax_country=vendor_country
      AND glenrich_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  82. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='152'
  83. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=152
  84. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=152
      AND `file_is_image`=1
      AND `file_published`=1
  85. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=152
      AND `file_is_image`=0
  86. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='152'
  87. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=153
  88. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='153'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  89. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=153
  90. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  91. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='153'
  92. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=153
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  93. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=153
  94. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='153'
  95. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=153
  96. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=153
      AND `file_is_image`=1
      AND `file_published`=1
  97. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=153
      AND `file_is_image`=0
  98. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='153'
  99. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=154
  100. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='154'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=154
  102. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  103. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='154'
  104. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=154
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  105. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=154
  106. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='154'
  107. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=154
  108. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=154
      AND `file_is_image`=1
      AND `file_published`=1
  109. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=154
      AND `file_is_image`=0
  110. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='154'
  111. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=155
  112. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='155'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  113. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=155
  114. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='155'
  116. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=155
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  117. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=155
  118. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='155'
  119. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=155
  120. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=155
      AND `file_is_image`=1
      AND `file_published`=1
  121. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=155
      AND `file_is_image`=0
  122. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='155'
  123. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=156
  124. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='156'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  125. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=156
  126. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  127. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='156'
  128. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=156
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  129. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=156
  130. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='156'
  131. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=156
  132. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=156
      AND `file_is_image`=1
      AND `file_published`=1
  133. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=156
      AND `file_is_image`=0
  134. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='156'
  135. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=157
  136. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='157'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  137. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=157
  138. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649442' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='157'
  140. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=157
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  141. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=157
  142. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='157'
  143. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=157
  144. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=157
      AND `file_is_image`=1
      AND `file_published`=1
  145. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=157
      AND `file_is_image`=0
  146. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='157'
  147. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=159
  148. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='159'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=159
  150. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='159'
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=159
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=159
  154. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='159'
  155. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=159
  156. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=159
      AND `file_is_image`=1
      AND `file_published`=1
  157. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=159
      AND `file_is_image`=0
  158. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='159'
  159. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=158
  160. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='158'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  161. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=158
  162. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  163. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='158'
  164. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=158
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  165. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=158
  166. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='158'
  167. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=158
  168. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=158
      AND `file_is_image`=1
      AND `file_published`=1
  169. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=158
      AND `file_is_image`=0
  170. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='158'
  171. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=160
  172. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='160'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  173. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=160
  174. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  175. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='160'
  176. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=160
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  177. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=160
  178. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='160'
  179. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=160
  180. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=160
      AND `file_is_image`=1
      AND `file_published`=1
  181. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=160
      AND `file_is_image`=0
  182. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='160'
  183. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=161
  184. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='161'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=161
  186. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  187. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='161'
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=161
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=161
  190. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='161'
  191. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=161
  192. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=161
      AND `file_is_image`=1
      AND `file_published`=1
  193. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=161
      AND `file_is_image`=0
  194. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='161'
  195. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=162
  196. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='162'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  197. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=162
  198. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  199. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='162'
  200. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=162
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  201. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=162
  202. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='162'
  203. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=162
  204. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=162
      AND `file_is_image`=1
      AND `file_published`=1
  205. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=162
      AND `file_is_image`=0
  206. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='162'
  207. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=164
  208. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='164'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  209. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=164
  210. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  211. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='164'
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=164
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=164
  214. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='164'
  215. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=164
  216. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=164
      AND `file_is_image`=1
      AND `file_published`=1
  217. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=164
      AND `file_is_image`=0
  218. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='164'
  219. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  220. 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='1'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  221. 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`='1354'
  222. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1354
  223. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1354'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  224. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1354
  225. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  226. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1354'
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1354
      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=1354
      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=1354
      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=1354
      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='1354'
  232. 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`='182'
  233. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=182
  234. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='182'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  235. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=182
  236. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  237. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='182'
  238. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=182
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  239. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  240. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  241. 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`='408'
  242. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=408
  243. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='408'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=408
  245. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  246. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='408'
  247. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      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=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=408
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  251. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='408'
  252. 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`='412'
  253. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=412
  254. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='412'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=412
  256. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  257. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='412'
  258. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=412
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  259. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=412
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  260. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=412
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  261. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=412
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  262. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='412'
  263. 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`='439'
  264. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=439
  265. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='439'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  266. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=439
  267. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='439'
  269. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      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=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=439
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  273. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='439'
  274. 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`='610'
  275. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=610
  276. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='610'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  277. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=610
  278. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  279. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='610'
  280. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=610
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  281. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=610
  282. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='610'
  283. 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`='1013'
  284. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1013
  285. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1013'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  286. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1013
  287. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  288. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1013'
  289. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  290. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      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=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  292. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  293. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1013'
  294. 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`='411'
  295. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=411
  296. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='411'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  297. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=411
  298. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  299. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='411'
  300. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=411
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  301. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=411
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  302. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=411
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  303. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=411
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  304. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='411'
  305. 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`='614'
  306. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=614
  307. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='614'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  308. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=614
  309. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  310. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='614'
  311. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=614
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  312. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=614
  313. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='614'
  314. 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`='124'
  315. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=124
  316. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='124'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  317. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=124
  318. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1787649443' OR start_date=0)
      AND (end_date>='1787614560' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='124'
  320. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  321. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  322. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  323. 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=1354'
  324. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  325. 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 = 1354
  326. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1354'
  327. 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=1354'
  328. 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=1354'
  329. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  330. 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 = 1354
  331. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1354'
  332. 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=1354'
  333. 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=182'
  334. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  335. 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 = 182
  336. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  337. 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=182'
  338. 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=182'
  339. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  340. 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 = 182
  341. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  342. 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=182'
  343. 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=408'
  344. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  345. 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 = 408
  346. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '408'
  347. 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=408'
  348. 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=408'
  349. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  350. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 408
  351. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '408'
  352. 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=408'
  353. 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=412'
  354. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  355. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 412
  356. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '412'
  357. 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=412'
  358. 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=412'
  359. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  360. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 412
  361. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '412'
  362. 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=412'
  363. 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=439'
  364. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  365. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 439
  366. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '439'
  367. 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=439'
  368. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=439'
  369. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  370. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 439
  371. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '439'
  372. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=439'
  373. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=610'
  374. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  375. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  376. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  377. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=610'
  378. 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=610'
  379. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  380. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 610
  381. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '610'
  382. 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=610'
  383. 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=1013'
  384. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  385. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1013
  386. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1013'
  387. 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=1013'
  388. 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=1013'
  389. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  390. 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 = 1013
  391. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1013'
  392. 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=1013'
  393. 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=411'
  394. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  395. 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 = 411
  396. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '411'
  397. 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=411'
  398. 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=411'
  399. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  400. 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 = 411
  401. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '411'
  402. 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=411'
  403. 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=614'
  404. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  405. 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 = 614
  406. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  407. 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=614'
  408. 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=614'
  409. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  410. 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 = 614
  411. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '614'
  412. 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=614'
  413. 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=124'
  414. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  415. 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 = 124
  416. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  417. 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=124'
  418. 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=124'
  419. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  420. 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 = 124
  421. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  422. 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=124'
  423. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND menuid = 0
  424. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  425. 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;
  426. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=408&page=shop.browse'

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

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

Нет

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

Нет