Интерет-магазин мотозапчастей. Украина

motoring2013@gmail.com

мотозапчасти оптом и розницу. Доставка по Украине

Каталог

Запчасти для мотоцикла VIPER V250VXR



Сортировать по:

Cиденье VIPER V250VXR (MOD)

583.74 грн


Cиденье VIPER V250VXR (MOD)
[Подробнее...]


Амортизатор передний пара VIPER V250VXR (MUS)

8 916.20 грн


Амортизатор передний пара VIPER V250VXR (MUS)
[Подробнее...]


Бардачок VIPER V250VXR (MUS)

216.00 грн


Бардачок VIPER V250VXR (MUS)
[Подробнее...]



Бензобак VIPER V250VXR (MUS)

1 291.68 грн


Бензобак VIPER V250VXR (MUS)
[Подробнее...]


Блок кнопок пара VIPER V250VXR (MUS)

1 034.41 грн


Блок кнопок пара VIPER V250VXR (MUS)
[Подробнее...]


Боковая стояночная опора VIPER V250VXR (MUS)

268.55 грн


Боковая стояночная опора VIPER V250VXR (MUS)
[Подробнее...]



Вал кик-стартера VIPER V250VXR (MUS)

559.00 грн


Вал кик-стартера VIPER V250VXR (MUS)
[Подробнее...]


Вал переключения передач VIPER V250VXR (MUS)

718.70 грн


Вал переключения передач VIPER V250VXR (MUS)
[Подробнее...]


Верхняя пластина траверсы VIPER V250VXR (MUS)

1 844.76 грн


Верхняя пластина траверсы VIPER V250VXR (MUS)
[Подробнее...]



Ветровое стекло VIPER V250VXR (MUS)

1 269.36 грн


Ветровое стекло VIPER V250VXR (MUS)
[Подробнее...]


Вилка пролинга VIPER V250VXR (MUS)

628.88 грн


Вилка пролинга VIPER V250VXR (MUS)
[Подробнее...]


Вилки переключения передач в сборе VIPER V250VXR (MUS)

559.00 грн


Вилки переключения передач в сборе VIPER V250VXR (MUS)
[Подробнее...]



Винт M10×1.25×90+Гайка M10×1.5 (верх. винт крепл. заднего аморт.

91.73 грн


Винт M10×1.25×90+Гайка M10×1.5 (верх. винт крепл. заднего аморт.) VIPER V250VXR (MUS)
[Подробнее...]


Винт M8×25+Гайка M8+Шайба М8 (ведомой звезды) VIPER V250VXR (MUS

146.80 грн


Винт M8×25+Гайка M8+Шайба М8 (ведомой звезды) VIPER V250VXR (MUS)
[Подробнее...]


Винты крепления пролинга (комплект) VIPER V250VXR (MUS)

146.80 грн


Винты крепления пролинга (комплект) VIPER V250VXR (MUS)
[Подробнее...]



Воздушный фильтр VIPER V250-VXR (Original Mod)

282.24 грн


Фильтр Воздушный VIPER V250-VXR (Original Mod)
[Подробнее...]


Воздушный фильтр в сборе VIPER V250VXR (MUS)

464.82 грн


Воздушный фильтр в сборе VIPER V250VXR (MUS)
[Подробнее...]


Вторичный вал КПП в сборе VIPER V250VXR (MUS)

898.40 грн


Вторичный вал КПП в сборе VIPER V250VXR (MUS)
[Подробнее...]



Генератор VIPER V250VXR (MUS)

895.16 грн


Генератор VIPER V250VXR (MUS)
[Подробнее...]


Гидравлика заднего тормоза в сборе VIPER V250VXR (MUS)

1 588.93 грн


Гидравлика заднего тормоза в сборе VIPER V250VXR (MUS)
[Подробнее...]





Показать #  
Результаты 1 - 20 из 177

Во многих голливудских фильмах с экшеном и погонями можно встретить мотоциклы эндуро. Они, может, не такие быстрые, как спортбайки, зато способны ехать там, где и пройти можно с трудом. Ярким представителем кроссовых байков является ViperV250VXR. МотоциклViperV250VXRкитайского производства, и он в сравнение с топовыми моделями намного дешевле, но характеристики вполне на уровне. Нельзя не заметить крутые обводы мотоцикла, и он хорошо смотрится в городе и на трассе, в пригороде и посреди вспаханного поля или на лесных проселках. Большой клиренс, неплохая для китайца скорость (125 км в час), нагрузка в полтора центнера, передняя подвеска-перевертыш, пятиступенчатая коробка – вот часть характеристик ViperV250VXR, которые позволят ему считаться неплохим середнячком. Если учитывать низкую стоимость, то для поклонников эндуро модель крайне привлекательна.

Запчасти для мотоцикловViperV250VXR могут потребоваться достаточно быстро, если за рулем любитель экстремального вождения.

Конечно, мотобайк создавался для преодоления преград, для езды по бездорожью, но шины при этом снашиваются весьма быстро, то же относится к тормозам. Не хочется никому этого желать, но на кроссовом мотоцикле можно влететь в овраг или не рассчитать и задеть кусты или деревья. Движок защищают металлические дуги, а вот пластику может хорошо достаться, и придется ставить новый обвес. Хорошо, если замена запчастей не нужна долгое время, но лучше знать авторитетного продавца и желательно с низкими ценами на товары.

Купить запчасти для мотоцикловViperV250VXR недорого можно в интернет-магазине Motoring, который уже много лет специализируется только на мотозапчастях и может похвастать лучшими ценами и превосходным качеством.

Корзина

Ваша корзина пуста.

Товар по группам




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

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.018 seconds, 3.88 MB
Application afterRoute: 0.024 seconds, 5.48 MB
Application afterDispatch: 0.289 seconds, 16.13 MB
Application afterRender: 0.411 seconds, 18.15 MB

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

19153928

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'anmdltlti06m5rpggu2coqs5u1'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1775747508' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'anmdltlti06m5rpggu2coqs5u1'
  4. UPDATE `jos_session`
      SET `time`='1775749608',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1775749607;s:18:\"session.timer.last\";i:1775749607;s:17:\"session.timer.now\";i:1775749607;s:24:\"session.client.forwarded\";s:13:\"216.73.216.32\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/home/motoring/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}VMCHECK|s:2:\"OK\";'
      WHERE session_id='anmdltlti06m5rpggu2coqs5u1'
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  9. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  10. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  11. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  12. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  13. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  14. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft
  15. 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 (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_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`);
  16. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  17. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  18. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  19. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  20. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=246
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  21. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='246'
  22. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='246'
  23. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='246'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  24. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='246'
      AND jos_vm_category.category_id='246'
  25. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  26. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_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`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=246
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 20
  27. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7194
  28. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7194'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7194
  30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  31. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7194'
  32. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  33. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7194
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  34. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7194
  35. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  36. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7194'
  37. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7194
  38. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7194
      AND `file_is_image`=1
      AND `file_published`=1
  39. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7194
      AND `file_is_image`=0
      AND `file_published`=1
  40. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7194'
  41. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  42. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7194
  43. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7194
  44. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5206
  45. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5206'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5206
  47. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  48. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5206'
  49. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5206
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  50. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5206
  51. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5206'
  52. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5206
  53. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5206
      AND `file_is_image`=1
      AND `file_published`=1
  54. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5206
  55. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  56. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5206
      AND `file_is_image`=0
      AND `file_published`=1
  57. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5206'
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  59. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5206
  60. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5206
  61. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5208
  62. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5208'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  63. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5208
  64. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  65. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5208'
  66. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5208
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  67. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5208
  68. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5208'
  69. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5208
  70. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5208
      AND `file_is_image`=1
      AND `file_published`=1
  71. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5208
  72. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  73. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5208
      AND `file_is_image`=0
      AND `file_published`=1
  74. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5208'
  75. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  76. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5208
  77. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5208
  78. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5207
  79. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5207'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  80. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5207
  81. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5207'
  83. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5207
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  84. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5207
  85. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5207'
  86. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5207
  87. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5207
      AND `file_is_image`=1
      AND `file_published`=1
  88. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5207
  89. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  90. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5207
      AND `file_is_image`=0
      AND `file_published`=1
  91. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5207'
  92. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  93. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5207
  94. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5207
  95. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5209
  96. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5209'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  97. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5209
  98. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5209'
  100. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5209
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  101. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5209
  102. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5209'
  103. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5209
  104. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5209
      AND `file_is_image`=1
      AND `file_published`=1
  105. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5209
  106. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  107. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5209
      AND `file_is_image`=0
      AND `file_published`=1
  108. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5209'
  109. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  110. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5209
  111. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5209
  112. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5210
  113. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5210'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  114. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5210
  115. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5210'
  117. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5210
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  118. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5210
  119. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5210'
  120. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5210
  121. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5210
      AND `file_is_image`=1
      AND `file_published`=1
  122. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5210
  123. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  124. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5210
      AND `file_is_image`=0
      AND `file_published`=1
  125. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5210'
  126. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  127. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5210
  128. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5210
  129. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5211
  130. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5211'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5211
  132. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  133. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5211'
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5211
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  135. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5211
  136. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5211'
  137. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5211
  138. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5211
      AND `file_is_image`=1
      AND `file_published`=1
  139. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5211
  140. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  141. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5211
      AND `file_is_image`=0
      AND `file_published`=1
  142. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5211'
  143. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  144. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5211
  145. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5211
  146. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5212
  147. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5212'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  148. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5212
  149. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5212'
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5212
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  152. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5212
  153. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5212'
  154. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5212
  155. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5212
      AND `file_is_image`=1
      AND `file_published`=1
  156. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5212
  157. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  158. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5212
      AND `file_is_image`=0
      AND `file_published`=1
  159. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5212'
  160. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  161. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5212
  162. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5212
  163. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5314
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5314'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5314
  166. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5314'
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5314
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5314
  170. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5314'
  171. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5314
  172. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5314
      AND `file_is_image`=1
      AND `file_published`=1
  173. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5314
  174. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  175. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5314
      AND `file_is_image`=0
      AND `file_published`=1
  176. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5314'
  177. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  178. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5314
  179. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5314
  180. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5214
  181. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5214'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5214
  183. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5214'
  185. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5214
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  186. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5214
  187. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5214'
  188. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5214
  189. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5214
      AND `file_is_image`=1
      AND `file_published`=1
  190. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5214
  191. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5214
      AND `file_is_image`=0
      AND `file_published`=1
  193. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5214'
  194. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  195. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5214
  196. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5214
  197. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5217
  198. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5217'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  199. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5217
  200. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  201. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5217'
  202. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5217
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  203. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5217
  204. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5217'
  205. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5217
  206. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5217
      AND `file_is_image`=1
      AND `file_published`=1
  207. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5217
  208. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  209. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5217
      AND `file_is_image`=0
      AND `file_published`=1
  210. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5217'
  211. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  212. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5217
  213. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5217
  214. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5216
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5216'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5216
  217. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  218. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5216'
  219. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5216
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  220. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5216
  221. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5216'
  222. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5216
  223. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5216
      AND `file_is_image`=1
      AND `file_published`=1
  224. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5216
  225. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  226. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5216
      AND `file_is_image`=0
      AND `file_published`=1
  227. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5216'
  228. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  229. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5216
  230. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5216
  231. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5218
  232. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5218'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  233. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5218
  234. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  235. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5218'
  236. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5218
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  237. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5218
  238. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5218'
  239. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5218
  240. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5218
      AND `file_is_image`=1
      AND `file_published`=1
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5218
  242. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  243. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5218
      AND `file_is_image`=0
      AND `file_published`=1
  244. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5218'
  245. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  246. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5218
  247. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5218
  248. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5219
  249. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5219'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  250. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5219
  251. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  252. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5219'
  253. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5219
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  254. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5219
  255. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5219'
  256. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5219
  257. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5219
      AND `file_is_image`=1
      AND `file_published`=1
  258. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5219
  259. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  260. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5219
      AND `file_is_image`=0
      AND `file_published`=1
  261. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5219'
  262. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  263. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5219
  264. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5219
  265. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5222
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5222'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5222
  268. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  269. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5222'
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5222
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  271. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5222
  272. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5222'
  273. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5222
  274. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5222
      AND `file_is_image`=1
      AND `file_published`=1
  275. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5222
  276. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  277. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5222
      AND `file_is_image`=0
      AND `file_published`=1
  278. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5222'
  279. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  280. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5222
  281. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5222
  282. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6383
  283. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6383'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  284. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6383
  285. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  286. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6383'
  287. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6383
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  288. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6383
  289. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6383'
  290. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6383
  291. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=6383
      AND `file_is_image`=1
      AND `file_published`=1
  292. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6383
  293. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  294. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=6383
      AND `file_is_image`=0
      AND `file_published`=1
  295. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='6383'
  296. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  297. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6383
  298. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6383
  299. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5220
  300. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5220'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  301. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5220
  302. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  303. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5220'
  304. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5220
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  305. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5220
  306. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5220'
  307. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5220
  308. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5220
      AND `file_is_image`=1
      AND `file_published`=1
  309. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5220
  310. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  311. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5220
      AND `file_is_image`=0
      AND `file_published`=1
  312. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5220'
  313. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  314. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5220
  315. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5220
  316. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5221
  317. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5221'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  318. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5221
  319. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5221'
  321. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5221
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  322. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5221
  323. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5221'
  324. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5221
  325. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5221
      AND `file_is_image`=1
      AND `file_published`=1
  326. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5221
  327. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  328. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5221
      AND `file_is_image`=0
      AND `file_published`=1
  329. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5221'
  330. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  331. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5221
  332. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5221
  333. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5303
  334. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5303'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  335. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5303
  336. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  337. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5303'
  338. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  339. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5303
  340. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5303'
  341. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5303
  342. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5303
      AND `file_is_image`=1
      AND `file_published`=1
  343. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5303
  344. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  345. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5303
      AND `file_is_image`=0
      AND `file_published`=1
  346. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5303'
  347. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  348. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5303
  349. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5303
  350. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5223
  351. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5223'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  352. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5223
  353. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  354. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5223'
  355. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5223
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  356. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5223
  357. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5223'
  358. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5223
  359. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5223
      AND `file_is_image`=1
      AND `file_published`=1
  360. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5223
  361. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  362. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5223
      AND `file_is_image`=0
      AND `file_published`=1
  363. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5223'
  364. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  365. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5223
  366. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5223
  367. SELECT DISTINCT product_sku,jos_vm_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE
    (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')

      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id

      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id

      AND jos_vm_category.category_id='246'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  368. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 302)
      ORDER BY menuid DESC
      LIMIT 0, 1
  369. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 302 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  370. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  371. SELECT DISTINCT m.manufacturer_id, m.mf_name
                                           
      FROM jos_vm_manufacturer m
                                           
      LEFT JOIN jos_vm_product_mf_xref mx
      ON mx.manufacturer_id = m.manufacturer_id
                                           
      LEFT JOIN jos_vm_product p
      ON p.product_id = mx.product_id
                                           
      LEFT JOIN jos_vm_product_category_xref cx
      ON cx.product_id = p.product_id
                                           
      WHERE cx.category_id =246
      ORDER BY m.mf_name ASC

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'anmdltlti06m5rpggu2coqs5u1'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1775747508' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'anmdltlti06m5rpggu2coqs5u1'
  4. UPDATE `jos_session`
      SET `time`='1775749608',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1775749607;s:18:\"session.timer.last\";i:1775749607;s:17:\"session.timer.now\";i:1775749607;s:24:\"session.client.forwarded\";s:13:\"216.73.216.32\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/home/motoring/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}VMCHECK|s:2:\"OK\";'
      WHERE session_id='anmdltlti06m5rpggu2coqs5u1'
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  9. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  10. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  11. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  12. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  13. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  14. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft
  15. 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 (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_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`);
  16. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  17. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  18. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  19. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  20. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=246
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  21. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='246'
  22. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='246'
  23. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='246'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  24. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='246'
      AND jos_vm_category.category_id='246'
  25. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  26. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_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`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=246
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 20
  27. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7194
  28. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7194'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7194
  30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  31. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7194'
  32. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  33. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7194
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  34. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7194
  35. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  36. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7194'
  37. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7194
  38. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7194
      AND `file_is_image`=1
      AND `file_published`=1
  39. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7194
      AND `file_is_image`=0
      AND `file_published`=1
  40. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7194'
  41. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  42. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7194
  43. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7194
  44. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5206
  45. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5206'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5206
  47. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  48. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5206'
  49. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5206
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  50. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5206
  51. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5206'
  52. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5206
  53. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5206
      AND `file_is_image`=1
      AND `file_published`=1
  54. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5206
  55. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  56. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5206
      AND `file_is_image`=0
      AND `file_published`=1
  57. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5206'
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  59. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5206
  60. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5206
  61. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5208
  62. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5208'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  63. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5208
  64. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  65. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5208'
  66. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5208
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  67. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5208
  68. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5208'
  69. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5208
  70. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5208
      AND `file_is_image`=1
      AND `file_published`=1
  71. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5208
  72. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  73. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5208
      AND `file_is_image`=0
      AND `file_published`=1
  74. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5208'
  75. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  76. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5208
  77. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5208
  78. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5207
  79. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5207'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  80. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5207
  81. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5207'
  83. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5207
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  84. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5207
  85. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5207'
  86. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5207
  87. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5207
      AND `file_is_image`=1
      AND `file_published`=1
  88. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5207
  89. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  90. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5207
      AND `file_is_image`=0
      AND `file_published`=1
  91. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5207'
  92. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  93. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5207
  94. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5207
  95. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5209
  96. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5209'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  97. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5209
  98. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5209'
  100. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5209
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  101. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5209
  102. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5209'
  103. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5209
  104. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5209
      AND `file_is_image`=1
      AND `file_published`=1
  105. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5209
  106. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  107. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5209
      AND `file_is_image`=0
      AND `file_published`=1
  108. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5209'
  109. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  110. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5209
  111. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5209
  112. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5210
  113. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5210'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  114. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5210
  115. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5210'
  117. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5210
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  118. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5210
  119. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5210'
  120. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5210
  121. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5210
      AND `file_is_image`=1
      AND `file_published`=1
  122. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5210
  123. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  124. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5210
      AND `file_is_image`=0
      AND `file_published`=1
  125. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5210'
  126. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  127. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5210
  128. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5210
  129. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5211
  130. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5211'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5211
  132. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  133. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5211'
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5211
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  135. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5211
  136. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5211'
  137. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5211
  138. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5211
      AND `file_is_image`=1
      AND `file_published`=1
  139. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5211
  140. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  141. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5211
      AND `file_is_image`=0
      AND `file_published`=1
  142. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5211'
  143. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  144. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5211
  145. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5211
  146. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5212
  147. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5212'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  148. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5212
  149. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5212'
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5212
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  152. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5212
  153. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5212'
  154. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5212
  155. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5212
      AND `file_is_image`=1
      AND `file_published`=1
  156. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5212
  157. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  158. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5212
      AND `file_is_image`=0
      AND `file_published`=1
  159. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5212'
  160. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  161. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5212
  162. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5212
  163. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5314
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5314'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5314
  166. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5314'
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5314
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5314
  170. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5314'
  171. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5314
  172. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5314
      AND `file_is_image`=1
      AND `file_published`=1
  173. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5314
  174. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  175. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5314
      AND `file_is_image`=0
      AND `file_published`=1
  176. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5314'
  177. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  178. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5314
  179. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5314
  180. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5214
  181. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5214'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5214
  183. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  184. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5214'
  185. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5214
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  186. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5214
  187. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5214'
  188. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5214
  189. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5214
      AND `file_is_image`=1
      AND `file_published`=1
  190. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5214
  191. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5214
      AND `file_is_image`=0
      AND `file_published`=1
  193. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5214'
  194. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  195. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5214
  196. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5214
  197. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5217
  198. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5217'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  199. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5217
  200. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  201. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5217'
  202. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5217
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  203. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5217
  204. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5217'
  205. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5217
  206. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5217
      AND `file_is_image`=1
      AND `file_published`=1
  207. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5217
  208. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  209. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5217
      AND `file_is_image`=0
      AND `file_published`=1
  210. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5217'
  211. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  212. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5217
  213. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5217
  214. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5216
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5216'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5216
  217. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  218. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5216'
  219. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5216
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  220. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5216
  221. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5216'
  222. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5216
  223. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5216
      AND `file_is_image`=1
      AND `file_published`=1
  224. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5216
  225. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  226. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5216
      AND `file_is_image`=0
      AND `file_published`=1
  227. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5216'
  228. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  229. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5216
  230. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5216
  231. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5218
  232. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5218'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  233. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5218
  234. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  235. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5218'
  236. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5218
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  237. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5218
  238. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5218'
  239. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5218
  240. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5218
      AND `file_is_image`=1
      AND `file_published`=1
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5218
  242. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  243. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5218
      AND `file_is_image`=0
      AND `file_published`=1
  244. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5218'
  245. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  246. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5218
  247. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5218
  248. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5219
  249. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5219'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  250. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5219
  251. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  252. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5219'
  253. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5219
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  254. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5219
  255. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5219'
  256. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5219
  257. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5219
      AND `file_is_image`=1
      AND `file_published`=1
  258. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5219
  259. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  260. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5219
      AND `file_is_image`=0
      AND `file_published`=1
  261. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5219'
  262. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  263. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5219
  264. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5219
  265. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5222
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5222'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5222
  268. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  269. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5222'
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5222
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  271. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5222
  272. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5222'
  273. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5222
  274. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5222
      AND `file_is_image`=1
      AND `file_published`=1
  275. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5222
  276. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  277. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5222
      AND `file_is_image`=0
      AND `file_published`=1
  278. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5222'
  279. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  280. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5222
  281. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5222
  282. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6383
  283. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6383'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  284. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6383
  285. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  286. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6383'
  287. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6383
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  288. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6383
  289. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6383'
  290. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6383
  291. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=6383
      AND `file_is_image`=1
      AND `file_published`=1
  292. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6383
  293. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  294. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=6383
      AND `file_is_image`=0
      AND `file_published`=1
  295. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='6383'
  296. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  297. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6383
  298. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6383
  299. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5220
  300. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5220'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  301. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5220
  302. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  303. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5220'
  304. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5220
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  305. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5220
  306. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5220'
  307. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5220
  308. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5220
      AND `file_is_image`=1
      AND `file_published`=1
  309. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5220
  310. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  311. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5220
      AND `file_is_image`=0
      AND `file_published`=1
  312. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5220'
  313. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  314. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5220
  315. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5220
  316. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5221
  317. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5221'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  318. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5221
  319. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5221'
  321. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5221
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  322. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5221
  323. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5221'
  324. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5221
  325. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5221
      AND `file_is_image`=1
      AND `file_published`=1
  326. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5221
  327. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  328. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5221
      AND `file_is_image`=0
      AND `file_published`=1
  329. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5221'
  330. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  331. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5221
  332. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5221
  333. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5303
  334. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5303'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  335. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5303
  336. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  337. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5303'
  338. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  339. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5303
  340. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5303'
  341. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5303
  342. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5303
      AND `file_is_image`=1
      AND `file_published`=1
  343. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5303
  344. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  345. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5303
      AND `file_is_image`=0
      AND `file_published`=1
  346. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5303'
  347. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  348. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5303
  349. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5303
  350. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5223
  351. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5223'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  352. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5223
  353. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749608' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  354. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5223'
  355. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5223
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  356. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5223
  357. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5223'
  358. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5223
  359. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5223
      AND `file_is_image`=1
      AND `file_published`=1
  360. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5223
  361. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  362. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5223
      AND `file_is_image`=0
      AND `file_published`=1
  363. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5223'
  364. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  365. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5223
  366. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5223
  367. SELECT DISTINCT product_sku,jos_vm_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE
    (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')

      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id

      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id

      AND jos_vm_category.category_id='246'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  368. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 302)
      ORDER BY menuid DESC
      LIMIT 0, 1
  369. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 302 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  370. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  371. SELECT DISTINCT m.manufacturer_id, m.mf_name
                                           
      FROM jos_vm_manufacturer m
                                           
      LEFT JOIN jos_vm_product_mf_xref mx
      ON mx.manufacturer_id = m.manufacturer_id
                                           
      LEFT JOIN jos_vm_product p
      ON p.product_id = mx.product_id
                                           
      LEFT JOIN jos_vm_product_category_xref cx
      ON cx.product_id = p.product_id
                                           
      WHERE cx.category_id =246
      ORDER BY m.mf_name ASC

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

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

Нет

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

Нет