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

motoring2013@gmail.com

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

Каталог

Запчасти для мотоциклов Loncin LX200GY-3



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

Loncin LX200GY-3 Амортизаторы передние (пара) 800mm шток 31мм

5 155.13 грн


Loncin LX200GY-3 Амортизаторы передние (пара) 800mm шток 31мм
[Подробнее...]


Loncin LX200GY-3 Блок кнопок (левый)

473.62 грн


Loncin LX200GY-3 Блок кнопок (левый)
[Подробнее...]


Loncin LX200GY-3 Блок кнопок (правый)

473.62 грн


Loncin LX200GY-3 Блок кнопок (правый)
[Подробнее...]



Loncin LX200GY-3 Болт М8*70ММ

82.80 грн


Loncin LX200GY-3 Болт М8*70ММ
[Подробнее...]


Loncin LX200GY-3 Болт коромысла прогрессии М8х90ММ

99.36 грн


Loncin LX200GY-3 Болт коромысла прогрессии М8х90ММ
[Подробнее...]


Loncin LX200GY-3 Болт М10*115ММ

99.36 грн


Loncin LX200GY-3 Болт М10*115ММ
[Подробнее...]



Loncin LX200GY-3 Болт М12*80ММ

132.48 грн


Loncin LX200GY-3 Болт М12*80ММ
[Подробнее...]


Loncin LX200GY-3 Верхняя пластина траверсы

1 184.04 грн


Loncin LX200GY-3 Верхняя пластина траверсы
[Подробнее...]


Loncin LX200GY-3 Вилочки переключения передач

556.42 грн


Loncin LX200GY-3 Вилочки переключения передач
[Подробнее...]



Loncin LX200GY-3 Генератор в сборе

2 003.76 грн


Loncin LX200GY-3 Генератор в сборе
[Подробнее...]


Loncin LX200GY-3 Глушитель

4 769.28 грн


Loncin LX200GY-3 Глушитель
[Подробнее...]


Loncin LX200GY-3 Двигатель в сборе 200 кубов

32 788.80 грн


Loncin LX200GY-3 Двигатель в сборе 200 кубов
[Подробнее...]



Loncin LX200GY-3 Демпферная резинка заднего колеса

172.80 грн


Loncin LX200GY-3 Демпферная резинка заднего колеса
[Подробнее...]


Loncin LX200GY-3 Жабка заднего тормоза

127.51 грн


Loncin LX200GY-3 Жабка заднего тормоза
[Подробнее...]


Loncin LX200GY-3 Заглушка двигателя

138.00 грн


Loncin LX200GY-3 Заглушка двигателя
[Подробнее...]



Loncin LX200GY-3 Замок зажигания (мама)

635.90 грн


Loncin LX200GY-3 Замок зажигания (мама)
[Подробнее...]


Loncin LX200GY-3 Замок зажигания (папа)

635.90 грн


Loncin LX200GY-3 Замок зажигания (папа)
[Подробнее...]


Loncin LX200GY-3 Защита цепи

236.81 грн


Loncin LX200GY-3 Защита цепи
[Подробнее...]



Loncin LX200GY-3 Звездочка ведущая 520х12

314.64 грн


Loncin LX200GY-3 Звездочка ведущая 520х12
[Подробнее...]


Loncin LX200GY-3 Звездочка ведущая 520х13

314.64 грн


Loncin LX200GY-3 Звездочка ведущая 520х13
[Подробнее...]





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

Мопеды VIPER ACTIVE обладают рядом преимуществ, среди которых плавность хода, низкий расход топлива, неприхотливость в обслуживании. Внешний вид мопедов уступает, возможно, мотоциклам, зато они выглядят лучше скутеров. Скоростные и динамические характеристики мопедов VIPER ACTIVE также весьма неплохие, учитывая низкий расход бензина. Два-три литра – и это в городском режиме, на трассе потребление сокращается примерно на треть. Конечно, чтобы мопеды бодро ехали по дорогам, расходовали мало топлива, необходимо следить за состоянием техники, меняя вовремя запчасти.

Запчасти для мопедов VIPER ACTIVE продаются в различных торговых точках, но выгоднее всего их покупать в интернет-магазинах.

Интернет-магазин Motoring занимается продажей обширнейшего количества мотозапчастей, само собой, тут есть запчасти для мопедов VIPER ACTIVE, как одних из наиболее востребованных

Преимущество интернет-магазина Motoring – низкие цены, совмещенные с высоким качеством, а купить мотозапчасти легко – оплатить покупку можно различными способами. В продаже есть кофры, багажники, седла, спидометры, пластик, двигатели и еще десятки всевозможных деталей для линейки мопедов VIPER ACTIVE. Даже если чего-то нет в наличии, менеджеры компании быстро организуют недостающего товара, причем цена из-за этого не станет чрезмерно высокой.

Чтобы купить запчасти для мопедов VIPER ACTIVE, надо зайти на сайт интернет-магазина Motoring, выбрать категорию с этими мотозапчастями и найти нужную деталь.

Товар можно искать в каталоге при помощи встроенной поисковой программы, а есть еще одна возможность – помощь сотрудника интернет-магазина. В любом случае потребитель получит то, что ему необходимо, сможет купить запчасти по низкой цене.

Корзина

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

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




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

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.019 seconds, 3.89 MB
Application afterRoute: 0.025 seconds, 5.49 MB
Application afterDispatch: 0.328 seconds, 16.10 MB
Application afterRender: 0.445 seconds, 18.13 MB

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

19124432

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = '53v07g3ch068bl6sa8od7qtqs0'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1775747800' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '53v07g3ch068bl6sa8od7qtqs0'
  4. UPDATE `jos_session`
      SET `time`='1775749900',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1775749899;s:18:\"session.timer.last\";i:1775749899;s:17:\"session.timer.now\";i:1775749899;s:24:\"session.client.forwarded\";s:13:\"216.73.216.32\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";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\";auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:6:\"грн\";userstate|a:1:{s:10:\"product_id\";i:0;}last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:3:\"153\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";'
      WHERE session_id='53v07g3ch068bl6sa8od7qtqs0'
  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 `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  11. 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
  12. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  13. 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
  14. 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`);
  15. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  16. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  17. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  18. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  19. 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`=248
     
      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'
  20. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='248'
  21. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='248'
  22. 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='248'
      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
  23. 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='248'
      AND jos_vm_category.category_id='248'
  24. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. 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`=248
     
      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
  26. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9047
  27. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9047'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  28. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9047
  29. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  30. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9047'
  31. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  32. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9047
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  33. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9047
  34. 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
  35. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9047'
  36. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9047
  37. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9047
      AND `file_is_image`=1
      AND `file_published`=1
  38. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9047
      AND `file_is_image`=0
      AND `file_published`=1
  39. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9047'
  40. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  41. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9047
  42. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9047
  43. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9044
  44. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9044'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  45. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9044
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9044'
  48. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9044
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  49. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9044
  50. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9044'
  51. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9044
  52. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9044
      AND `file_is_image`=1
      AND `file_published`=1
  53. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9044
      AND `file_is_image`=0
      AND `file_published`=1
  54. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9044'
  55. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  56. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9044
  57. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9044
  58. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9045
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9045'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9045
  61. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9045'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  64. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9045
  65. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9045'
  66. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9045
  67. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9045
      AND `file_is_image`=1
      AND `file_published`=1
  68. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9045
      AND `file_is_image`=0
      AND `file_published`=1
  69. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9045'
  70. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  71. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9045
  72. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9045
  73. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9008
  74. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9008'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  75. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9008
  76. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  77. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9008'
  78. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9008
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  79. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9008
  80. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9008'
  81. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9008
  82. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9008
      AND `file_is_image`=1
      AND `file_published`=1
  83. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9008
  84. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  85. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9008
      AND `file_is_image`=0
      AND `file_published`=1
  86. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9008'
  87. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  88. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9008
  89. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9008
  90. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9011
  91. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9011'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9011
  93. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  94. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9011'
  95. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9011
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  96. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9011
  97. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9011'
  98. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9011
  99. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9011
      AND `file_is_image`=1
      AND `file_published`=1
  100. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9011
  101. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  102. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9011
      AND `file_is_image`=0
      AND `file_published`=1
  103. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9011'
  104. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  105. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9011
  106. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9011
  107. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9009
  108. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9009'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  109. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9009
  110. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  111. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9009'
  112. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9009
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  113. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9009
  114. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9009'
  115. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9009
  116. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9009
      AND `file_is_image`=1
      AND `file_published`=1
  117. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9009
  118. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  119. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9009
      AND `file_is_image`=0
      AND `file_published`=1
  120. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9009'
  121. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  122. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9009
  123. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9009
  124. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9010
  125. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9010'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  126. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9010
  127. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  128. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9010'
  129. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9010
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  130. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9010
  131. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9010'
  132. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9010
  133. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9010
      AND `file_is_image`=1
      AND `file_published`=1
  134. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9010
  135. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  136. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9010
      AND `file_is_image`=0
      AND `file_published`=1
  137. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9010'
  138. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  139. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9010
  140. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9010
  141. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9012
  142. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9012'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  143. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9012
  144. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9012'
  146. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9012
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  147. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9012
  148. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9012'
  149. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9012
  150. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9012
      AND `file_is_image`=1
      AND `file_published`=1
  151. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9012
  152. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  153. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9012
      AND `file_is_image`=0
      AND `file_published`=1
  154. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9012'
  155. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  156. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9012
  157. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9012
  158. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9013
  159. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9013'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  160. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9013
  161. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  162. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9013'
  163. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  164. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9013
  165. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9013'
  166. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9013
  167. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9013
      AND `file_is_image`=1
      AND `file_published`=1
  168. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9013
  169. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  170. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9013
      AND `file_is_image`=0
      AND `file_published`=1
  171. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9013'
  172. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  173. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9013
  174. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9013
  175. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9015
  176. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9015'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  177. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9015
  178. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  179. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9015'
  180. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9015
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  181. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9015
  182. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9015'
  183. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9015
  184. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9015
      AND `file_is_image`=1
      AND `file_published`=1
  185. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9015
      AND `file_is_image`=0
      AND `file_published`=1
  186. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9015'
  187. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  188. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9015
  189. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9015
  190. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9016
  191. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9016'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  192. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9016
  193. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  194. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9016'
  195. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9016
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  196. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9016
  197. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9016'
  198. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9016
  199. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9016
      AND `file_is_image`=1
      AND `file_published`=1
  200. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9016
  201. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  202. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9016
      AND `file_is_image`=0
      AND `file_published`=1
  203. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9016'
  204. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  205. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9016
  206. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9016
  207. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9175
  208. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9175'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  209. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9175
  210. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  211. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9175'
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9175
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9175
  214. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9175'
  215. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9175
  216. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9175
      AND `file_is_image`=1
      AND `file_published`=1
  217. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9175
      AND `file_is_image`=0
      AND `file_published`=1
  218. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9175'
  219. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  220. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9175
  221. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9175
  222. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9161
  223. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9161'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  224. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9161
  225. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  226. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9161'
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9161
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9161
  229. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9161'
  230. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9161
  231. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9161
      AND `file_is_image`=1
      AND `file_published`=1
  232. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9161
      AND `file_is_image`=0
      AND `file_published`=1
  233. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9161'
  234. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  235. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9161
  236. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9161
  237. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9075
  238. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9075'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  239. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9075
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9075'
  242. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9075
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  243. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9075
  244. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9075'
  245. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9075
  246. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9075
      AND `file_is_image`=1
      AND `file_published`=1
  247. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9075
  248. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  249. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9075
      AND `file_is_image`=0
      AND `file_published`=1
  250. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9075'
  251. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  252. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9075
  253. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9075
  254. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9184
  255. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9184'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  256. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9184
  257. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  258. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9184'
  259. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9184
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  260. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9184
  261. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9184'
  262. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9184
  263. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9184
      AND `file_is_image`=1
      AND `file_published`=1
  264. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9184
      AND `file_is_image`=0
      AND `file_published`=1
  265. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9184'
  266. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  267. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9184
  268. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9184
  269. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9155
  270. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9155'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  271. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9155
  272. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  273. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9155'
  274. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9155
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  275. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9155
  276. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9155'
  277. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9155
  278. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9155
      AND `file_is_image`=1
      AND `file_published`=1
  279. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9155
  280. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  281. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9155
      AND `file_is_image`=0
      AND `file_published`=1
  282. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9155'
  283. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  284. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9155
  285. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9155
  286. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9154
  287. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9154'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  288. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9154
  289. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  290. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9154'
  291. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9154
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  292. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9154
  293. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9154'
  294. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9154
  295. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9154
      AND `file_is_image`=1
      AND `file_published`=1
  296. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9154
  297. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  298. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9154
      AND `file_is_image`=0
      AND `file_published`=1
  299. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9154'
  300. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  301. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9154
  302. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9154
  303. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9022
  304. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9022'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9022
  306. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  307. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9022'
  308. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9022
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  309. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9022
  310. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9022'
  311. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9022
  312. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9022
      AND `file_is_image`=1
      AND `file_published`=1
  313. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9022
  314. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  315. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9022
      AND `file_is_image`=0
      AND `file_published`=1
  316. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9022'
  317. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  318. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9022
  319. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9022
  320. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9176
  321. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9176'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  322. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9176
  323. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  324. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9176'
  325. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9176
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  326. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9176
  327. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9176'
  328. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9176
  329. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9176
      AND `file_is_image`=1
      AND `file_published`=1
  330. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9176
  331. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  332. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9176
      AND `file_is_image`=0
      AND `file_published`=1
  333. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9176'
  334. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  335. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9176
  336. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9176
  337. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9177
  338. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9177'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  339. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9177
  340. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  341. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9177'
  342. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9177
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  343. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9177
  344. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9177'
  345. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9177
  346. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9177
      AND `file_is_image`=1
      AND `file_published`=1
  347. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9177
  348. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  349. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9177
      AND `file_is_image`=0
      AND `file_published`=1
  350. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9177'
  351. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  352. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9177
  353. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9177
  354. 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='248'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  355. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 304)
      ORDER BY menuid DESC
      LIMIT 0, 1
  356. 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 = 304 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  357. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  358. 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 =248
      ORDER BY m.mf_name ASC

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = '53v07g3ch068bl6sa8od7qtqs0'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1775747800' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '53v07g3ch068bl6sa8od7qtqs0'
  4. UPDATE `jos_session`
      SET `time`='1775749900',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1775749899;s:18:\"session.timer.last\";i:1775749899;s:17:\"session.timer.now\";i:1775749899;s:24:\"session.client.forwarded\";s:13:\"216.73.216.32\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";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\";auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:6:\"грн\";userstate|a:1:{s:10:\"product_id\";i:0;}last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:3:\"153\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";'
      WHERE session_id='53v07g3ch068bl6sa8od7qtqs0'
  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 `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  11. 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
  12. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  13. 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
  14. 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`);
  15. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  16. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  17. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  18. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  19. 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`=248
     
      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'
  20. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='248'
  21. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='248'
  22. 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='248'
      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
  23. 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='248'
      AND jos_vm_category.category_id='248'
  24. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. 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`=248
     
      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
  26. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9047
  27. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9047'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  28. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9047
  29. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  30. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9047'
  31. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  32. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9047
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  33. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9047
  34. 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
  35. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9047'
  36. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9047
  37. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9047
      AND `file_is_image`=1
      AND `file_published`=1
  38. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9047
      AND `file_is_image`=0
      AND `file_published`=1
  39. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9047'
  40. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  41. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9047
  42. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9047
  43. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9044
  44. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9044'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  45. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9044
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9044'
  48. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9044
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  49. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9044
  50. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9044'
  51. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9044
  52. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9044
      AND `file_is_image`=1
      AND `file_published`=1
  53. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9044
      AND `file_is_image`=0
      AND `file_published`=1
  54. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9044'
  55. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  56. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9044
  57. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9044
  58. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9045
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9045'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9045
  61. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749900' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9045'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9045
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  64. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9045
  65. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9045'
  66. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9045
  67. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9045
      AND `file_is_image`=1
      AND `file_published`=1
  68. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9045
      AND `file_is_image`=0
      AND `file_published`=1
  69. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9045'
  70. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  71. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9045
  72. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9045
  73. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9008
  74. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9008'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  75. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9008
  76. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  77. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9008'
  78. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9008
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  79. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9008
  80. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9008'
  81. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9008
  82. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9008
      AND `file_is_image`=1
      AND `file_published`=1
  83. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9008
  84. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  85. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9008
      AND `file_is_image`=0
      AND `file_published`=1
  86. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9008'
  87. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  88. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9008
  89. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9008
  90. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9011
  91. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9011'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9011
  93. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  94. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9011'
  95. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9011
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  96. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9011
  97. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9011'
  98. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9011
  99. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9011
      AND `file_is_image`=1
      AND `file_published`=1
  100. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9011
  101. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  102. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9011
      AND `file_is_image`=0
      AND `file_published`=1
  103. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9011'
  104. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  105. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9011
  106. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9011
  107. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9009
  108. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9009'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  109. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9009
  110. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  111. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9009'
  112. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9009
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  113. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9009
  114. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9009'
  115. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9009
  116. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9009
      AND `file_is_image`=1
      AND `file_published`=1
  117. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9009
  118. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  119. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9009
      AND `file_is_image`=0
      AND `file_published`=1
  120. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9009'
  121. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  122. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9009
  123. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9009
  124. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9010
  125. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9010'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  126. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9010
  127. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  128. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9010'
  129. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9010
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  130. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9010
  131. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9010'
  132. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9010
  133. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9010
      AND `file_is_image`=1
      AND `file_published`=1
  134. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9010
  135. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  136. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9010
      AND `file_is_image`=0
      AND `file_published`=1
  137. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9010'
  138. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  139. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9010
  140. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9010
  141. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9012
  142. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9012'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  143. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9012
  144. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9012'
  146. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9012
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  147. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9012
  148. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9012'
  149. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9012
  150. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9012
      AND `file_is_image`=1
      AND `file_published`=1
  151. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9012
  152. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  153. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9012
      AND `file_is_image`=0
      AND `file_published`=1
  154. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9012'
  155. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  156. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9012
  157. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9012
  158. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9013
  159. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9013'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  160. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9013
  161. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  162. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9013'
  163. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9013
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  164. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9013
  165. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9013'
  166. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9013
  167. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9013
      AND `file_is_image`=1
      AND `file_published`=1
  168. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9013
  169. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  170. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9013
      AND `file_is_image`=0
      AND `file_published`=1
  171. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9013'
  172. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  173. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9013
  174. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9013
  175. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9015
  176. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9015'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  177. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9015
  178. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  179. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9015'
  180. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9015
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  181. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9015
  182. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9015'
  183. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9015
  184. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9015
      AND `file_is_image`=1
      AND `file_published`=1
  185. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9015
      AND `file_is_image`=0
      AND `file_published`=1
  186. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9015'
  187. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  188. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9015
  189. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9015
  190. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9016
  191. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9016'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  192. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9016
  193. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  194. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9016'
  195. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9016
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  196. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9016
  197. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9016'
  198. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9016
  199. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9016
      AND `file_is_image`=1
      AND `file_published`=1
  200. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9016
  201. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  202. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9016
      AND `file_is_image`=0
      AND `file_published`=1
  203. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9016'
  204. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  205. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9016
  206. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9016
  207. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9175
  208. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9175'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  209. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9175
  210. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  211. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9175'
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9175
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9175
  214. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9175'
  215. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9175
  216. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9175
      AND `file_is_image`=1
      AND `file_published`=1
  217. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9175
      AND `file_is_image`=0
      AND `file_published`=1
  218. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9175'
  219. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  220. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9175
  221. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9175
  222. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9161
  223. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9161'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  224. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9161
  225. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  226. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9161'
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9161
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9161
  229. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9161'
  230. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9161
  231. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9161
      AND `file_is_image`=1
      AND `file_published`=1
  232. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9161
      AND `file_is_image`=0
      AND `file_published`=1
  233. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9161'
  234. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  235. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9161
  236. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9161
  237. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9075
  238. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9075'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  239. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9075
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9075'
  242. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9075
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  243. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9075
  244. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9075'
  245. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9075
  246. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9075
      AND `file_is_image`=1
      AND `file_published`=1
  247. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9075
  248. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  249. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9075
      AND `file_is_image`=0
      AND `file_published`=1
  250. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9075'
  251. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  252. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9075
  253. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9075
  254. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9184
  255. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9184'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  256. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9184
  257. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  258. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9184'
  259. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9184
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  260. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9184
  261. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9184'
  262. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9184
  263. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9184
      AND `file_is_image`=1
      AND `file_published`=1
  264. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9184
      AND `file_is_image`=0
      AND `file_published`=1
  265. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9184'
  266. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  267. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9184
  268. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9184
  269. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9155
  270. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9155'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  271. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9155
  272. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  273. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9155'
  274. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9155
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  275. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9155
  276. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9155'
  277. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9155
  278. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9155
      AND `file_is_image`=1
      AND `file_published`=1
  279. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9155
  280. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  281. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9155
      AND `file_is_image`=0
      AND `file_published`=1
  282. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9155'
  283. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  284. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9155
  285. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9155
  286. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9154
  287. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9154'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  288. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9154
  289. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  290. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9154'
  291. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9154
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  292. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9154
  293. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9154'
  294. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9154
  295. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9154
      AND `file_is_image`=1
      AND `file_published`=1
  296. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9154
  297. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  298. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9154
      AND `file_is_image`=0
      AND `file_published`=1
  299. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9154'
  300. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  301. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9154
  302. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9154
  303. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9022
  304. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9022'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9022
  306. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  307. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9022'
  308. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9022
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  309. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9022
  310. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9022'
  311. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9022
  312. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9022
      AND `file_is_image`=1
      AND `file_published`=1
  313. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9022
  314. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  315. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9022
      AND `file_is_image`=0
      AND `file_published`=1
  316. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9022'
  317. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  318. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9022
  319. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9022
  320. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9176
  321. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9176'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  322. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9176
  323. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  324. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9176'
  325. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9176
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  326. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9176
  327. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9176'
  328. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9176
  329. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9176
      AND `file_is_image`=1
      AND `file_published`=1
  330. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9176
  331. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  332. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9176
      AND `file_is_image`=0
      AND `file_published`=1
  333. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9176'
  334. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  335. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9176
  336. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9176
  337. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9177
  338. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9177'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  339. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9177
  340. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775749901' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  341. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9177'
  342. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9177
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  343. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9177
  344. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9177'
  345. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9177
  346. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9177
      AND `file_is_image`=1
      AND `file_published`=1
  347. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9177
  348. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  349. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=9177
      AND `file_is_image`=0
      AND `file_published`=1
  350. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='9177'
  351. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  352. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9177
  353. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9177
  354. 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='248'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  355. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 304)
      ORDER BY menuid DESC
      LIMIT 0, 1
  356. 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 = 304 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  357. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  358. 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 =248
      ORDER BY m.mf_name ASC

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

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

Нет

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

Нет