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

motoring2013@gmail.com

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

Каталог

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



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

Аккумулятор OUTDO 12v 7.0ah гелевый.

878.16 грн


Аккумулятор OUTDO 12v 7.0ah гелевый.
[Подробнее...]


Аккумулятор OUTDO 12v 7.0ah сухозаряженый с оксидом.

878.87 грн


Аккумулятор OUTDO 12v 7.0ah сухозаряженый с оксидом.
[Подробнее...]


Аккумулятор VIPER V250 R1 (ORIGINAL)

1 400.75 грн


Аккумулятор VIPER V250 R1 (ORIGINAL)
[Подробнее...]



Амортизатор передний (Вилка) VIPER V250 R1 (ORIGINAL)

3 920.06 грн


Амортизатор передний (Вилка) VIPER V250 R1 (ORIGINAL)
[Подробнее...]


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

4 304.38 грн


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


Бендикс (обгонная муфта) VIPER R1 (G-MAX Racer 250)

514.74 грн


Бендикс (обгонная муфта) Viper R1 (Вайпер Р1), Viper 250-R1, G-max Racer 250 (Дж-макс рейсер 250), XGJAO 250 (хджао 250), Genata 250cc (Джената 250)
[Подробнее...]



Бендикс (обгонная муфта) VIPER R1 (G-MAX Racer 250)

514.74 грн


Бендикс (обгонная муфта) Viper R1 (Вайпер Р1), Viper 250-R1, G-max Racer 250 (Дж-макс рейсер 250), XGJAO 250 (хджао 250), Genata 250cc (Джената 250)
[Подробнее...]


Бендикс (обгонная муфта+звезда) VIPER R1 (G-MAX Racer 250)

514.74 грн


Бендикс (обгонная муфта+звезда) Viper R1 (Вайпер Р1), Viper 250-R1, G-max Racer 250 (Дж-макс рейсер 250), XGJAO 250 (хджао 250), Genata 250cc (Джената 250)
[Подробнее...]


Бензобак VIPER V250 R1 (ORIGINAL)

1 887.84 грн


Бензобак VIPER V250 R1 (ORIGINAL)
[Подробнее...]



Блок кнопок VIPER V250 R1 (ORIGINAL)

775.80 грн


Блок кнопок VIPER V250 R1 (ORIGINAL)
[Подробнее...]


Блок кнопок VIPER V250-R1 (MOD)

881.58 грн


Блок кнопок VIPER V250-R1 (MOD)
[Подробнее...]


Блок кнопок управления л+п VIPER R1 (G-MAX Racer 250) .

1 030.35 грн


Блок кнопок управления л+п VIPER R1 (G-MAX Racer 250).
[Подробнее...]



Боковая накладка на бак VIPER R1 (G-MAX Racer 250)

1 530.00 грн


Боковая накладка на бак Viper R1 (Вайпер Р1), Viper 250-R1, G-max Racer 250 (Дж-макс рейсер 250), XGJAO 250 (хджао 250), Genata 250cc (Джената 250)
[Подробнее...]


Боковая накладка на бак VIPER R1 (G-MAX Racer 250)

1 530.00 грн


Боковая накладка на бак Viper R1 (Вайпер Р1), Viper 250-R1, G-max Racer 250 (Дж-макс рейсер 250), XGJAO 250 (хджао 250), Genata 250cc (Джената 250)
[Подробнее...]


Боковая парковочная ножка VIPER V250 R1 (ORIGINAL)

208.87 грн


Боковая парковочная ножка VIPER V250 R1 (ORIGINAL)
[Подробнее...]



Боковая стояночная опора VIPER R1 (G-MAX Racer 250)

545.50 грн


Боковая стояночная опора Viper R1 (Вайпер Р1), Viper 250-R1, G-max Racer 250 (Дж-макс рейсер 250), XGJAO 250 (хджао 250), Genata 250cc (Джената 250)
[Подробнее...]


Боковой глянцевый пластик нижней части VIPER R1(G-MAX Racer 250)

2 160.00 грн


Боковой глянцевый пластик нижней части Viper R1 (Вайпер Р1), Viper 250-R1, G-max Racer 250 (Дж-макс рейсер 250), XGJAO 250 (хджао 250), Genata 250cc (Джената 250)
[Подробнее...]


Боковой матовый пластик нижней части VIPER R1 (G-MAX Racer 250)

2 160.00 грн


Боковой матовый пластик нижней части Viper R1 (Вайпер Р1), Viper 250-R1, G-max Racer 250 (Дж-макс рейсер 250), XGJAO 250 (хджао 250), Genata 250cc (Джената 250)
[Подробнее...]



Боковые подножки VIPER R1 (G-MAX Racer 250)

461.59 грн


Боковые подножки (скобы крепления)подножка VIPER R1 (G-MAX Racer 250). Страна производитель Тайвань.
[Подробнее...]


Бокс для АКБ VIPER V250 R1 (ORIGINAL)

216.00 грн


Бокс для АКБ VIPER V250 R1 (ORIGINAL)
[Подробнее...]





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

Мотоцикл Viper R1 – внешне гоночный болид, вот только динамические показатели у него скорее средние.

Агрессивный дизайн не уступает самым именитым коллегам, но рекомендуемая скорость – в районе сотни, поэтому угнаться за резвой машиной на трассе будет непросто. С другой стороны, любитель быстрой езды на двухколесных машинах получает в свое распоряжение отлично выглядящий спортбайк, внушающий уважение самим звуком работы выпускной системы. Обвес выглядит хищно, пластик корпуса – довольно качественный, но стоит озаботиться тем, чтобы была возможность оперативно заменить отработавшие свое запчасти. Покупать и устанавливать запчасти для мотоциклов Viper R1 следует вовремя, тогда не будут ломаться другие узлы, и цена ремонта окажется приемлемой.

Покупать сейчас запчасти, конечно же, лучше всего в интернет-магазинах, только следует отдавать предпочтение тем компаниям, чьи представительства давно работают как в реальности, так и в виртуальности. В Украине один из самых проверенных годами интернет-магазинов принадлежит компании Motoring. Интернет-магазин Motoring – продажа мотоциклов, скутеров, мопедов, квадроциклов и запчастей к ним. Тут можно купить запчасти для мотоциклов Viper R1, причем цена будет самая низкая, а качество – высочайшее! Так получается благодаря прямым поставкам практически с заводов компаний-изготовителей, так как Motoring сотрудничает с ведущими поставщиками.

Чтобы купить запчасти для мотоциклов Viper R1, надо зайти в соответствующий раздел каталога, найти там необходимую деталь и отправить ее в корзину.

При отсутствии оной следует сразу же уточнить этот вопрос у сотрудников интернет-магазина, возможно, есть аналог в другом разделе, посвященном другим мотоциклам этой же марки.

Корзина

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

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




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

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.021 seconds, 3.88 MB
Application afterRoute: 0.032 seconds, 5.48 MB
Application afterDispatch: 0.644 seconds, 16.13 MB
Application afterRender: 0.767 seconds, 18.15 MB

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

19152096

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'vsjkaf945vdruer03plnevmj90'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1769602977' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'vsjkaf945vdruer03plnevmj90'
  4. UPDATE `jos_session`
      SET `time`='1769605077',`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:1769605077;s:18:\"session.timer.last\";i:1769605077;s:17:\"session.timer.now\";i:1769605077;s:24:\"session.client.forwarded\";s:14:\"216.73.216.187\";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='vsjkaf945vdruer03plnevmj90'
  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`=229
     
      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='229'
  22. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='229'
  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='229'
      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='229'
      AND jos_vm_category.category_id='229'
  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`=229
     
      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`=1692
  28. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1692'
      AND (start_date<='1769605077' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1692
  30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605077' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  31. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1692'
  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=1692
      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=1692
  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='1692'
  37. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1692
  38. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1692
      AND `file_is_image`=1
      AND `file_published`=1
  39. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1692
  40. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  41. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1692
      AND `file_is_image`=0
      AND `file_published`=1
  42. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1692'
  43. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  44. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1692
  45. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1692
  46. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1687
  47. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1687'
      AND (start_date<='1769605077' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  48. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1687
  49. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605077' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  50. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1687'
  51. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1687
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  52. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1687
  53. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1687'
  54. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1687
  55. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1687
      AND `file_is_image`=1
      AND `file_published`=1
  56. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1687
  57. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1687
      AND `file_is_image`=0
      AND `file_published`=1
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1687'
  60. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  61. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1687
  62. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1687
  63. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4314
  64. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4314'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  65. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4314
  66. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  67. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4314'
  68. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4314
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  69. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4314
  70. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4314'
  71. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4314
  72. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4314
      AND `file_is_image`=1
      AND `file_published`=1
  73. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4314
  74. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  75. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4314
      AND `file_is_image`=0
      AND `file_published`=1
  76. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4314'
  77. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  78. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4314
  79. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4314
  80. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4315
  81. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4315'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4315
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4315'
  85. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4315
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  86. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4315
  87. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4315'
  88. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4315
  89. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4315
      AND `file_is_image`=1
      AND `file_published`=1
  90. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4315
  91. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  92. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4315
      AND `file_is_image`=0
      AND `file_published`=1
  93. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4315'
  94. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  95. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4315
  96. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4315
  97. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3821
  98. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3821'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3821
  100. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3821'
  102. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3821
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  103. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3821
  104. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3821'
  105. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3821
  106. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3821
      AND `file_is_image`=1
      AND `file_published`=1
  107. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3821
  108. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  109. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3821
      AND `file_is_image`=0
      AND `file_published`=1
  110. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='3821'
  111. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  112. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3821
  113. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3821
  114. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2476
  115. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2476'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2476
  117. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  118. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2476'
  119. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2476
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  120. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2476
  121. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2476'
  122. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2476
  123. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2476
      AND `file_is_image`=1
      AND `file_published`=1
  124. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2476
      AND `file_is_image`=0
      AND `file_published`=1
  125. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2476'
  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`=2476
  128. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2476
  129. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2531
  130. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2531'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2531
  132. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  133. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2531'
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2531
      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=2531
  136. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2531'
  137. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2531
  138. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2531
      AND `file_is_image`=1
      AND `file_published`=1
  139. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2531
      AND `file_is_image`=0
      AND `file_published`=1
  140. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2531'
  141. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  142. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2531
  143. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2531
  144. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2477
  145. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2477'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  146. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2477
  147. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  148. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2477'
  149. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2477
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  150. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2477
  151. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2477'
  152. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2477
  153. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2477
      AND `file_is_image`=1
      AND `file_published`=1
  154. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2477
  155. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  156. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2477
      AND `file_is_image`=0
      AND `file_published`=1
  157. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2477'
  158. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  159. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2477
  160. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2477
  161. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4316
  162. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4316'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  163. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4316
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4316'
  166. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4316
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  167. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4316
  168. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4316'
  169. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4316
  170. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4316
      AND `file_is_image`=1
      AND `file_published`=1
  171. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4316
  172. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  173. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4316
      AND `file_is_image`=0
      AND `file_published`=1
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4316'
  175. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  176. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4316
  177. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4316
  178. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4317
  179. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4317'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  180. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4317
  181. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4317'
  183. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  184. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4317
  185. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4317'
  186. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4317
  187. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4317
      AND `file_is_image`=1
      AND `file_published`=1
  188. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4317
  189. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  190. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4317
      AND `file_is_image`=0
      AND `file_published`=1
  191. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4317'
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  193. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4317
  194. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4317
  195. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7203
  196. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7203'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  197. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7203
  198. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  199. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7203'
  200. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7203
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  201. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7203
  202. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7203'
  203. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7203
  204. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7203
      AND `file_is_image`=1
      AND `file_published`=1
  205. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7203
  206. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  207. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7203
      AND `file_is_image`=0
      AND `file_published`=1
  208. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7203'
  209. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  210. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7203
  211. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7203
  212. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2125
  213. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2125'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  214. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2125
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2125'
  217. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  218. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2125
  219. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2125'
  220. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2125
  221. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2125
      AND `file_is_image`=1
      AND `file_published`=1
  222. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2125
  223. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  224. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2125
      AND `file_is_image`=0
      AND `file_published`=1
  225. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2125'
  226. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  227. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2125
  228. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2125
  229. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2524
  230. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2524'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  231. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2524
  232. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  233. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2524'
  234. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2524
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  235. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2524
  236. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2524'
  237. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2524
  238. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2524
      AND `file_is_image`=1
      AND `file_published`=1
  239. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2524
      AND `file_is_image`=0
      AND `file_published`=1
  240. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2524'
  241. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  242. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2524
  243. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2524
  244. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2525
  245. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2525'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  246. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2525
  247. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  248. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2525'
  249. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2525
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2525
  251. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2525'
  252. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2525
  253. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2525
      AND `file_is_image`=1
      AND `file_published`=1
  254. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2525
      AND `file_is_image`=0
      AND `file_published`=1
  255. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2525'
  256. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  257. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2525
  258. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2525
  259. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4318
  260. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4318'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  261. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4318
  262. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  263. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4318'
  264. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4318
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  265. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4318
  266. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4318'
  267. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4318
  268. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4318
      AND `file_is_image`=1
      AND `file_published`=1
  269. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4318
  270. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  271. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4318
      AND `file_is_image`=0
      AND `file_published`=1
  272. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4318'
  273. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  274. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4318
  275. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4318
  276. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2505
  277. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2505'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  278. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2505
  279. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  280. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2505'
  281. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2505
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  282. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2505
  283. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2505'
  284. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2505
  285. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2505
      AND `file_is_image`=1
      AND `file_published`=1
  286. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2505
  287. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  288. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2505
      AND `file_is_image`=0
      AND `file_published`=1
  289. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2505'
  290. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  291. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2505
  292. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2505
  293. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2526
  294. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2526'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  295. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2526
  296. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  297. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2526'
  298. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2526
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  299. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2526
  300. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2526'
  301. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2526
  302. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2526
      AND `file_is_image`=1
      AND `file_published`=1
  303. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2526
      AND `file_is_image`=0
      AND `file_published`=1
  304. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2526'
  305. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  306. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2526
  307. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2526
  308. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2527
  309. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2527'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  310. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2527
  311. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  312. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2527'
  313. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2527
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  314. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2527
  315. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2527'
  316. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2527
  317. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2527
      AND `file_is_image`=1
      AND `file_published`=1
  318. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2527
  319. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  320. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2527
      AND `file_is_image`=0
      AND `file_published`=1
  321. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2527'
  322. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  323. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2527
  324. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2527
  325. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2122
  326. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2122'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  327. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2122
  328. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  329. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2122'
  330. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2122
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  331. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2122
  332. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2122'
  333. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2122
  334. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2122
      AND `file_is_image`=1
      AND `file_published`=1
  335. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2122
  336. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  337. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2122
      AND `file_is_image`=0
      AND `file_published`=1
  338. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2122'
  339. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  340. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2122
  341. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2122
  342. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4319
  343. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4319'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  344. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4319
  345. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  346. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4319'
  347. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4319
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  348. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4319
  349. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4319'
  350. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4319
  351. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4319
      AND `file_is_image`=1
      AND `file_published`=1
  352. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4319
  353. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  354. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4319
      AND `file_is_image`=0
      AND `file_published`=1
  355. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4319'
  356. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  357. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4319
  358. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4319
  359. 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='229'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  360. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 284)
      ORDER BY menuid DESC
      LIMIT 0, 1
  361. 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 = 284 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  362. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  363. 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 =229
      ORDER BY m.mf_name ASC

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'vsjkaf945vdruer03plnevmj90'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1769602977' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'vsjkaf945vdruer03plnevmj90'
  4. UPDATE `jos_session`
      SET `time`='1769605077',`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:1769605077;s:18:\"session.timer.last\";i:1769605077;s:17:\"session.timer.now\";i:1769605077;s:24:\"session.client.forwarded\";s:14:\"216.73.216.187\";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='vsjkaf945vdruer03plnevmj90'
  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`=229
     
      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='229'
  22. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='229'
  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='229'
      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='229'
      AND jos_vm_category.category_id='229'
  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`=229
     
      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`=1692
  28. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1692'
      AND (start_date<='1769605077' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1692
  30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605077' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  31. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1692'
  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=1692
      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=1692
  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='1692'
  37. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1692
  38. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1692
      AND `file_is_image`=1
      AND `file_published`=1
  39. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1692
  40. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  41. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1692
      AND `file_is_image`=0
      AND `file_published`=1
  42. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1692'
  43. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  44. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1692
  45. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1692
  46. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1687
  47. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1687'
      AND (start_date<='1769605077' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  48. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1687
  49. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605077' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  50. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1687'
  51. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1687
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  52. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1687
  53. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1687'
  54. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1687
  55. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1687
      AND `file_is_image`=1
      AND `file_published`=1
  56. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1687
  57. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1687
      AND `file_is_image`=0
      AND `file_published`=1
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1687'
  60. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  61. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1687
  62. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1687
  63. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4314
  64. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4314'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  65. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4314
  66. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  67. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4314'
  68. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4314
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  69. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4314
  70. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4314'
  71. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4314
  72. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4314
      AND `file_is_image`=1
      AND `file_published`=1
  73. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4314
  74. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  75. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4314
      AND `file_is_image`=0
      AND `file_published`=1
  76. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4314'
  77. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  78. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4314
  79. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4314
  80. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4315
  81. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4315'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4315
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4315'
  85. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4315
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  86. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4315
  87. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4315'
  88. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4315
  89. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4315
      AND `file_is_image`=1
      AND `file_published`=1
  90. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4315
  91. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  92. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4315
      AND `file_is_image`=0
      AND `file_published`=1
  93. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4315'
  94. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  95. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4315
  96. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4315
  97. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3821
  98. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3821'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3821
  100. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3821'
  102. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3821
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  103. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3821
  104. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3821'
  105. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3821
  106. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3821
      AND `file_is_image`=1
      AND `file_published`=1
  107. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3821
  108. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  109. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3821
      AND `file_is_image`=0
      AND `file_published`=1
  110. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='3821'
  111. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  112. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3821
  113. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3821
  114. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2476
  115. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2476'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2476
  117. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  118. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2476'
  119. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2476
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  120. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2476
  121. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2476'
  122. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2476
  123. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2476
      AND `file_is_image`=1
      AND `file_published`=1
  124. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2476
      AND `file_is_image`=0
      AND `file_published`=1
  125. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2476'
  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`=2476
  128. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2476
  129. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2531
  130. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2531'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2531
  132. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  133. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2531'
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2531
      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=2531
  136. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2531'
  137. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2531
  138. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2531
      AND `file_is_image`=1
      AND `file_published`=1
  139. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2531
      AND `file_is_image`=0
      AND `file_published`=1
  140. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2531'
  141. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  142. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2531
  143. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2531
  144. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2477
  145. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2477'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  146. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2477
  147. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  148. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2477'
  149. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2477
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  150. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2477
  151. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2477'
  152. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2477
  153. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2477
      AND `file_is_image`=1
      AND `file_published`=1
  154. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2477
  155. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  156. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2477
      AND `file_is_image`=0
      AND `file_published`=1
  157. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2477'
  158. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  159. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2477
  160. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2477
  161. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4316
  162. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4316'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  163. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4316
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4316'
  166. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4316
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  167. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4316
  168. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4316'
  169. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4316
  170. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4316
      AND `file_is_image`=1
      AND `file_published`=1
  171. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4316
  172. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  173. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4316
      AND `file_is_image`=0
      AND `file_published`=1
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4316'
  175. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  176. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4316
  177. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4316
  178. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4317
  179. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4317'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  180. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4317
  181. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  182. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4317'
  183. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4317
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  184. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4317
  185. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4317'
  186. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4317
  187. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4317
      AND `file_is_image`=1
      AND `file_published`=1
  188. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4317
  189. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  190. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4317
      AND `file_is_image`=0
      AND `file_published`=1
  191. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4317'
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  193. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4317
  194. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4317
  195. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7203
  196. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7203'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  197. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7203
  198. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  199. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7203'
  200. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7203
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  201. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7203
  202. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7203'
  203. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7203
  204. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7203
      AND `file_is_image`=1
      AND `file_published`=1
  205. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7203
  206. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  207. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7203
      AND `file_is_image`=0
      AND `file_published`=1
  208. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7203'
  209. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  210. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7203
  211. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7203
  212. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2125
  213. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2125'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  214. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2125
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2125'
  217. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2125
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  218. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2125
  219. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2125'
  220. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2125
  221. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2125
      AND `file_is_image`=1
      AND `file_published`=1
  222. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2125
  223. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  224. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2125
      AND `file_is_image`=0
      AND `file_published`=1
  225. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2125'
  226. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  227. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2125
  228. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2125
  229. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2524
  230. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2524'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  231. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2524
  232. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  233. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2524'
  234. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2524
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  235. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2524
  236. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2524'
  237. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2524
  238. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2524
      AND `file_is_image`=1
      AND `file_published`=1
  239. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2524
      AND `file_is_image`=0
      AND `file_published`=1
  240. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2524'
  241. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  242. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2524
  243. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2524
  244. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2525
  245. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2525'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  246. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2525
  247. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  248. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2525'
  249. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2525
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2525
  251. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2525'
  252. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2525
  253. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2525
      AND `file_is_image`=1
      AND `file_published`=1
  254. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2525
      AND `file_is_image`=0
      AND `file_published`=1
  255. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2525'
  256. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  257. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2525
  258. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2525
  259. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4318
  260. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4318'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  261. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4318
  262. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  263. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4318'
  264. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4318
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  265. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4318
  266. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4318'
  267. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4318
  268. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4318
      AND `file_is_image`=1
      AND `file_published`=1
  269. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4318
  270. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  271. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4318
      AND `file_is_image`=0
      AND `file_published`=1
  272. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4318'
  273. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  274. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4318
  275. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4318
  276. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2505
  277. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2505'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  278. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2505
  279. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  280. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2505'
  281. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2505
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  282. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2505
  283. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2505'
  284. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2505
  285. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2505
      AND `file_is_image`=1
      AND `file_published`=1
  286. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2505
  287. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  288. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2505
      AND `file_is_image`=0
      AND `file_published`=1
  289. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2505'
  290. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  291. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2505
  292. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2505
  293. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2526
  294. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2526'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  295. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2526
  296. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  297. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2526'
  298. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2526
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  299. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2526
  300. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2526'
  301. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2526
  302. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2526
      AND `file_is_image`=1
      AND `file_published`=1
  303. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2526
      AND `file_is_image`=0
      AND `file_published`=1
  304. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2526'
  305. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  306. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2526
  307. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2526
  308. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2527
  309. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2527'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  310. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2527
  311. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  312. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2527'
  313. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2527
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  314. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2527
  315. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2527'
  316. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2527
  317. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2527
      AND `file_is_image`=1
      AND `file_published`=1
  318. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2527
  319. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  320. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2527
      AND `file_is_image`=0
      AND `file_published`=1
  321. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2527'
  322. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  323. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2527
  324. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2527
  325. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2122
  326. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2122'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  327. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2122
  328. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  329. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2122'
  330. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2122
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  331. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2122
  332. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2122'
  333. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2122
  334. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2122
      AND `file_is_image`=1
      AND `file_published`=1
  335. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2122
  336. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  337. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2122
      AND `file_is_image`=0
      AND `file_published`=1
  338. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2122'
  339. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  340. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2122
  341. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2122
  342. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4319
  343. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4319'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  344. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4319
  345. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769605078' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  346. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4319'
  347. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4319
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  348. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4319
  349. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4319'
  350. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4319
  351. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4319
      AND `file_is_image`=1
      AND `file_published`=1
  352. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4319
  353. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  354. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=4319
      AND `file_is_image`=0
      AND `file_published`=1
  355. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='4319'
  356. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  357. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4319
  358. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4319
  359. 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='229'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  360. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 284)
      ORDER BY menuid DESC
      LIMIT 0, 1
  361. 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 = 284 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  362. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  363. 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 =229
      ORDER BY m.mf_name ASC

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

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

Нет

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

Нет