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

motoring2013@gmail.com

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

Каталог

Шины с диаметром диска 8 дюймов



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

Мотошина 3,00-8 Cascen F 580

338.24 грн


Мотошина 3,00-8 Cascen F 580
[Подробнее...]


Мотошина 3,00-8 Cascen F 580 (Бескамерная шина)

480.65 грн


Мотошина 3,00-8 Cascen F 580 (Бескамерная шина)
[Подробнее...]


Мотошина 3,00-8 Cascen F-572

338.24 грн


Мотошина 3,00-8 Cascen F-572
[Подробнее...]



Мотошина 3,00-8 Cascen F-572 (Бескамерная шина)

480.65 грн


Мотошина 3,00-8 Cascen F-572 (Бескамерная шина)
[Подробнее...]


Мотошина 3,00-8 Deli TIRE S-369

231.43 грн


Мотошина 3,00-8 Deli TIRE S-369 ТТ 4PR
[Подробнее...]


Мотошина 3,00-8 GAMA

391.64 грн


Мотошина 3,00-8 GAMA
[Подробнее...]



Мотошина 3,00-8 Китай

391.64 грн


Мотошина 3,00-8 Китай
[Подробнее...]


Мотошина 3,50-8 GAMA

409.45 грн


Мотошина 3,50-8 GAMA
[Подробнее...]


Мотошина 3,50-8 GAMA

427.25 грн


Мотошина 3,50-8 GAMA
[Подробнее...]



Мотошина 3,50-8 GLAMOUR

320.44 грн


Мотошина 3,50-8 GLAMOUR
[Подробнее...]


Мотошина 4,00-8 DURO (бескамерная шина)

640.87 грн


Мотошина 4,00-8 DURO для прицепов (бескамерная шина)
[Подробнее...]


Мотошина 4,00-8 Китай ТТ прицепы

640.87 грн


Мотошина 4,00-8 Китай толстая ТТ прицепы
[Подробнее...]



Мотошины Chao Yang Н-883 (4,00-8)

725.52 грн


Мотошины Chao Yang Н-883 в размере 4,00-8
[Подробнее...]


Мотошины Chao Yang Н-607 (4.00-8)

762.73 грн


Мотошины Chao Yang Н-607 в размере 4.00-8
[Подробнее...]


Мотошины Chao Yang H-609 (3,00-8).

465.08 грн


Мотошины Chao Yang H-609 в размере 3,00-8.
[Подробнее...]







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

Шины с диаметром диска 8 дюймов применяются для тачек, тележек, прицепов, детских квадроциклов. Купить качественые шины Deli Tire, Swallow, Naidun, DSI по оптовым ценам Вы можете в Интернет магазине MotoRing.

Недавно шины хранили годами и даже десятилетиями, но не из-за особенной любви к такой продукции, а благодаря банальному дефициту. Сейчас сложностей с приобретением покрышек нет, но каждый мотовладелец старается купить шины подешевле, но более высокого качества. Ясно, что сильно дешевые шины особо качественными вряд ли будут, но есть возможность сэкономить существенные средства, пользуясь услугами интернет-магазинов. Недаром говорят, что зачем платить больше, если есть возможность купить, например, шины по сниженной цене того же качества, как и дорогие товары в обычных автомагазинах. Экономия возможна при покупках в интернет-магазинах, а купить конкретно шины с диаметром диска 8 дюймов можно в интернет-магазине Motoring.

Шины с диаметром диска 8 дюймов предназначаются для мопедов, скутеров, мотоблоков, и в продаже есть все виды протекторов и рисунков. Только в интернет-магазине Motoring можно подобрать моторезину с различной износоустойчивостью, многослойную и бескамерную. Ассортимент покрышек большой, и потребители без проблем находят шины с диаметром диска 8 дюймов конкретно для тачек, мопедов, скутеров и даже мотоблоков. Если отыскать нужный товар самостоятельно не получается, следует не терять время, и сразу обратиться к менеджерам компании. Сотрудники интернет-магазина Motoring знают о мототоварах все, что может только разузнать грамотный специалист, и своими знаниями охотно делятся с потенциальными клиентами.

Купить шины с диаметром диска 8 дюймов легко – для этого следует дать знать сотруднику магазина о возникшей потребности или самостоятельно полистать каталог. Каталог разделяется на многочисленные категории и подкатегории, внутри есть удобная навигация по цене, популярности товара и другим параметрам.

Корзина

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

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




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

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.027 seconds, 3.95 MB
Application afterRoute: 0.036 seconds, 5.56 MB
Application afterDispatch: 0.238 seconds, 16.16 MB
Application afterRender: 0.350 seconds, 18.15 MB

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

19154392

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'r1hts46cv9o54s4lmbl3ddd3j2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1770694959' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'r1hts46cv9o54s4lmbl3ddd3j2'
  4. UPDATE `jos_session`
      SET `time`='1770697059',`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:1770697057;s:18:\"session.timer.last\";i:1770697057;s:17:\"session.timer.now\";i:1770697058;s:24:\"session.client.forwarded\";s:14:\"216.73.216.185\";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:\"106\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}product_sess|a:40:{i:5331;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:9510;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5332;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5334;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5333;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5335;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5336;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5337;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5339;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5421;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5340;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5341;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5343;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5417;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5344;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5345;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5346;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5347;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5348;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:9321;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7340;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7341;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4992;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4994;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7337;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7338;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4993;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7339;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4995;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:893;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1263;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1267;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1268;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1264;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1265;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1266;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:900;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:891;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:896;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:899;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";'
      WHERE session_id='r1hts46cv9o54s4lmbl3ddd3j2'
  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`=211
     
      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='211'
  21. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='211'
  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='211'
      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='211'
      AND jos_vm_category.category_id='211'
  24. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='16'
      AND jos_vm_category.category_id='16'
  25. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  26. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=211
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 20
  27. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7373
  28. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7373'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7373
  30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  31. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7373'
  32. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  33. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7373
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  34. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7373
  35. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7373'
  36. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7373
  37. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7373
      AND `file_is_image`=1
      AND `file_published`=1
  38. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7373
  39. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  40. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7373
      AND `file_is_image`=0
      AND `file_published`=1
  41. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7373'
  42. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  43. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7373
  44. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7373
  45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7375
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7375'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7375
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  49. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7375'
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7375
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  51. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7375
  52. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7375'
  53. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7375
  54. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7375
      AND `file_is_image`=1
      AND `file_published`=1
  55. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7375
  56. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  57. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7375
      AND `file_is_image`=0
      AND `file_published`=1
  58. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7375'
  59. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  60. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7375
  61. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7375
  62. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7374
  63. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7374'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  64. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7374
  65. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  66. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7374'
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7374
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  68. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7374
  69. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7374'
  70. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7374
  71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7374
      AND `file_is_image`=1
      AND `file_published`=1
  72. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7374
  73. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  74. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7374
      AND `file_is_image`=0
      AND `file_published`=1
  75. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7374'
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  77. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7374
  78. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7374
  79. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7376
  80. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7376'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  81. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7376
  82. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  83. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7376'
  84. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7376
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  85. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7376
  86. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7376'
  87. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7376
  88. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7376
      AND `file_is_image`=1
      AND `file_published`=1
  89. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7376
  90. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  91. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7376
      AND `file_is_image`=0
      AND `file_published`=1
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7376'
  93. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  94. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7376
  95. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7376
  96. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7372
  97. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7372'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7372
  99. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  100. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7372'
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7372
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  102. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7372
  103. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7372'
  104. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7372
  105. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7372
      AND `file_is_image`=1
      AND `file_published`=1
  106. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7372
  107. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  108. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7372
      AND `file_is_image`=0
      AND `file_published`=1
  109. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7372'
  110. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  111. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7372
  112. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7372
  113. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7619
  114. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7619'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7619
  116. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  117. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7619'
  118. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  119. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7619
  120. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7619'
  121. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7619
  122. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7619
      AND `file_is_image`=1
      AND `file_published`=1
  123. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7619
  124. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  125. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7619
      AND `file_is_image`=0
      AND `file_published`=1
  126. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7619'
  127. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  128. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7619
  129. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7619
  130. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7590
  131. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7590'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7590
  133. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  134. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7590'
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  136. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7590
  137. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7590'
  138. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7590
  139. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7590
      AND `file_is_image`=1
      AND `file_published`=1
  140. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7590
  141. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  142. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7590
      AND `file_is_image`=0
      AND `file_published`=1
  143. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7590'
  144. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  145. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7590
  146. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7590
  147. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7378
  148. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7378'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7378
  150. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7378'
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7378
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7378
  154. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7378'
  155. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7378
  156. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7378
      AND `file_is_image`=1
      AND `file_published`=1
  157. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7378
  158. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  159. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7378
      AND `file_is_image`=0
      AND `file_published`=1
  160. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7378'
  161. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  162. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7378
  163. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7378
  164. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7620
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7620'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7620
  167. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  168. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7620'
  169. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  170. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7620
  171. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7620'
  172. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7620
  173. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7620
      AND `file_is_image`=1
      AND `file_published`=1
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7620
  175. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  176. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7620
      AND `file_is_image`=0
      AND `file_published`=1
  177. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7620'
  178. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  179. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7620
  180. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7620
  181. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7377
  182. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7377'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  183. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7377
  184. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7377'
  186. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7377
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  187. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7377
  188. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7377'
  189. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7377
  190. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7377
      AND `file_is_image`=1
      AND `file_published`=1
  191. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7377
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  193. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7377
      AND `file_is_image`=0
      AND `file_published`=1
  194. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7377'
  195. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  196. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7377
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7377
  198. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7379
  199. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7379'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7379
  201. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7379'
  203. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7379
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  204. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7379
  205. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7379'
  206. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7379
  207. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7379
      AND `file_is_image`=1
      AND `file_published`=1
  208. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7379
  209. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  210. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7379
      AND `file_is_image`=0
      AND `file_published`=1
  211. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7379'
  212. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  213. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7379
  214. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7379
  215. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7592
  216. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7592'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7592
  218. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7592'
  220. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7592
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  221. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7592
  222. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7592'
  223. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7592
  224. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7592
      AND `file_is_image`=1
      AND `file_published`=1
  225. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7592
  226. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  227. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7592
      AND `file_is_image`=0
      AND `file_published`=1
  228. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7592'
  229. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  230. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7592
  231. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7592
  232. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1312
  233. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1312'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  234. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1312
  235. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  236. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1312'
  237. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1312
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  238. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1312
  239. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1312'
  240. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1312
  241. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1312
      AND `file_is_image`=1
      AND `file_published`=1
  242. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1312
  243. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  244. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1312
      AND `file_is_image`=0
      AND `file_published`=1
  245. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1312'
  246. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  247. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1312
  248. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1312
  249. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1311
  250. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1311'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  251. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1311
  252. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  253. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1311'
  254. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1311
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  255. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1311
  256. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1311'
  257. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1311
  258. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1311
      AND `file_is_image`=1
      AND `file_published`=1
  259. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1311
  260. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  261. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1311
      AND `file_is_image`=0
      AND `file_published`=1
  262. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1311'
  263. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  264. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1311
  265. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1311
  266. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1308
  267. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1308'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1308
  269. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  270. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1308'
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1308
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1308
  273. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1308'
  274. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1308
  275. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1308
      AND `file_is_image`=1
      AND `file_published`=1
  276. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1308
  277. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  278. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1308
      AND `file_is_image`=0
      AND `file_published`=1
  279. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1308'
  280. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  281. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1308
  282. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1308
  283. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=23
  284. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='23'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  285. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
  286. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='23'
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  289. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=23
  290. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='23'
  291. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=23
  292. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=23
      AND `file_is_image`=1
      AND `file_published`=1
  293. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
  294. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  295. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=23
      AND `file_is_image`=0
      AND `file_published`=1
  296. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='23'
  297. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  298. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=23
  299. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=23
  300. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=22
  301. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='22'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  302. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=22
  303. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  304. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='22'
  305. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  306. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=22
  307. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='22'
  308. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=22
  309. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=22
      AND `file_is_image`=1
      AND `file_published`=1
  310. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=22
  311. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  312. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=22
      AND `file_is_image`=0
      AND `file_published`=1
  313. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='22'
  314. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  315. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=22
  316. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=22
  317. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=26
  318. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='26'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=26
  320. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  321. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='26'
  322. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=26
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  323. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=26
  324. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='26'
  325. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=26
  326. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=26
      AND `file_is_image`=1
      AND `file_published`=1
  327. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=26
  328. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  329. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=26
      AND `file_is_image`=0
      AND `file_published`=1
  330. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='26'
  331. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  332. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=26
  333. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=26
  334. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=25
  335. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='25'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  336. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=25
  337. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  338. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='25'
  339. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=25
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  340. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=25
  341. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='25'
  342. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=25
  343. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=25
      AND `file_is_image`=1
      AND `file_published`=1
  344. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=25
  345. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  346. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=25
      AND `file_is_image`=0
      AND `file_published`=1
  347. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='25'
  348. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  349. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=25
  350. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=25
  351. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=24
  352. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='24'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  353. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=24
  354. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  355. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='24'
  356. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  357. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=24
  358. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='24'
  359. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=24
  360. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=24
      AND `file_is_image`=1
      AND `file_published`=1
  361. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=24
  362. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  363. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=24
      AND `file_is_image`=0
      AND `file_published`=1
  364. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='24'
  365. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  366. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=24
  367. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=24
  368. 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='211'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  369. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 266)
      ORDER BY menuid DESC
      LIMIT 0, 1
  370. 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 = 266 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  371. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  372. 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 =211
      ORDER BY m.mf_name ASC

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'r1hts46cv9o54s4lmbl3ddd3j2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1770694959' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'r1hts46cv9o54s4lmbl3ddd3j2'
  4. UPDATE `jos_session`
      SET `time`='1770697059',`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:1770697057;s:18:\"session.timer.last\";i:1770697057;s:17:\"session.timer.now\";i:1770697058;s:24:\"session.client.forwarded\";s:14:\"216.73.216.185\";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:\"106\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}product_sess|a:40:{i:5331;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:9510;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5332;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5334;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5333;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5335;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5336;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5337;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5339;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5421;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5340;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5341;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5343;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5417;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5344;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5345;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5346;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5347;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5348;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:9321;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697057;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7340;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7341;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4992;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4994;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7337;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7338;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4993;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7339;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4995;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:893;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1263;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1267;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1268;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1264;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1265;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1266;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:900;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:891;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:896;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:899;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770697058;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";'
      WHERE session_id='r1hts46cv9o54s4lmbl3ddd3j2'
  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`=211
     
      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='211'
  21. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='211'
  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='211'
      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='211'
      AND jos_vm_category.category_id='211'
  24. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='16'
      AND jos_vm_category.category_id='16'
  25. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  26. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=211
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 20
  27. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7373
  28. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7373'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7373
  30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  31. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7373'
  32. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  33. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7373
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  34. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7373
  35. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7373'
  36. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7373
  37. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7373
      AND `file_is_image`=1
      AND `file_published`=1
  38. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7373
  39. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  40. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7373
      AND `file_is_image`=0
      AND `file_published`=1
  41. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7373'
  42. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  43. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7373
  44. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7373
  45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7375
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7375'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7375
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  49. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7375'
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7375
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  51. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7375
  52. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7375'
  53. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7375
  54. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7375
      AND `file_is_image`=1
      AND `file_published`=1
  55. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7375
  56. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  57. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7375
      AND `file_is_image`=0
      AND `file_published`=1
  58. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7375'
  59. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  60. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7375
  61. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7375
  62. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7374
  63. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7374'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  64. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7374
  65. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  66. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7374'
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7374
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  68. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7374
  69. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7374'
  70. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7374
  71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7374
      AND `file_is_image`=1
      AND `file_published`=1
  72. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7374
  73. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  74. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7374
      AND `file_is_image`=0
      AND `file_published`=1
  75. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7374'
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  77. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7374
  78. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7374
  79. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7376
  80. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7376'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  81. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7376
  82. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  83. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7376'
  84. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7376
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  85. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7376
  86. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7376'
  87. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7376
  88. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7376
      AND `file_is_image`=1
      AND `file_published`=1
  89. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7376
  90. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  91. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7376
      AND `file_is_image`=0
      AND `file_published`=1
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7376'
  93. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  94. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7376
  95. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7376
  96. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7372
  97. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7372'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7372
  99. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  100. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7372'
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7372
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  102. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7372
  103. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7372'
  104. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7372
  105. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7372
      AND `file_is_image`=1
      AND `file_published`=1
  106. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7372
  107. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  108. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7372
      AND `file_is_image`=0
      AND `file_published`=1
  109. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7372'
  110. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  111. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7372
  112. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7372
  113. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7619
  114. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7619'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7619
  116. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  117. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7619'
  118. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  119. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7619
  120. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7619'
  121. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7619
  122. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7619
      AND `file_is_image`=1
      AND `file_published`=1
  123. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7619
  124. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  125. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7619
      AND `file_is_image`=0
      AND `file_published`=1
  126. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7619'
  127. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  128. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7619
  129. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7619
  130. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7590
  131. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7590'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7590
  133. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  134. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7590'
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7590
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  136. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7590
  137. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7590'
  138. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7590
  139. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7590
      AND `file_is_image`=1
      AND `file_published`=1
  140. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7590
  141. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  142. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7590
      AND `file_is_image`=0
      AND `file_published`=1
  143. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7590'
  144. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  145. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7590
  146. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7590
  147. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7378
  148. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7378'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7378
  150. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7378'
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7378
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7378
  154. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7378'
  155. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7378
  156. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7378
      AND `file_is_image`=1
      AND `file_published`=1
  157. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7378
  158. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  159. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7378
      AND `file_is_image`=0
      AND `file_published`=1
  160. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7378'
  161. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  162. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7378
  163. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7378
  164. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7620
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7620'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7620
  167. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  168. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7620'
  169. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7620
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  170. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7620
  171. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7620'
  172. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7620
  173. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7620
      AND `file_is_image`=1
      AND `file_published`=1
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7620
  175. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  176. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7620
      AND `file_is_image`=0
      AND `file_published`=1
  177. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7620'
  178. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  179. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7620
  180. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7620
  181. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7377
  182. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7377'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  183. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7377
  184. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7377'
  186. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7377
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  187. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7377
  188. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7377'
  189. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7377
  190. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7377
      AND `file_is_image`=1
      AND `file_published`=1
  191. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7377
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  193. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7377
      AND `file_is_image`=0
      AND `file_published`=1
  194. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7377'
  195. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  196. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7377
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7377
  198. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7379
  199. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7379'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7379
  201. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7379'
  203. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7379
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  204. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7379
  205. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7379'
  206. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7379
  207. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7379
      AND `file_is_image`=1
      AND `file_published`=1
  208. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7379
  209. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  210. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7379
      AND `file_is_image`=0
      AND `file_published`=1
  211. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7379'
  212. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  213. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7379
  214. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7379
  215. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7592
  216. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7592'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7592
  218. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7592'
  220. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7592
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  221. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7592
  222. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7592'
  223. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7592
  224. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7592
      AND `file_is_image`=1
      AND `file_published`=1
  225. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7592
  226. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  227. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7592
      AND `file_is_image`=0
      AND `file_published`=1
  228. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7592'
  229. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  230. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7592
  231. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7592
  232. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1312
  233. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1312'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  234. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1312
  235. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  236. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1312'
  237. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1312
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  238. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1312
  239. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1312'
  240. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1312
  241. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1312
      AND `file_is_image`=1
      AND `file_published`=1
  242. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1312
  243. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  244. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1312
      AND `file_is_image`=0
      AND `file_published`=1
  245. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1312'
  246. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  247. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1312
  248. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1312
  249. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1311
  250. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1311'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  251. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1311
  252. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  253. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1311'
  254. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1311
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  255. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1311
  256. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1311'
  257. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1311
  258. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1311
      AND `file_is_image`=1
      AND `file_published`=1
  259. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1311
  260. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  261. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1311
      AND `file_is_image`=0
      AND `file_published`=1
  262. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1311'
  263. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  264. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1311
  265. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1311
  266. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1308
  267. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1308'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1308
  269. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  270. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1308'
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1308
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1308
  273. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1308'
  274. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1308
  275. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1308
      AND `file_is_image`=1
      AND `file_published`=1
  276. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1308
  277. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  278. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1308
      AND `file_is_image`=0
      AND `file_published`=1
  279. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1308'
  280. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  281. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1308
  282. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1308
  283. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=23
  284. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='23'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  285. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
  286. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='23'
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  289. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=23
  290. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='23'
  291. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=23
  292. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=23
      AND `file_is_image`=1
      AND `file_published`=1
  293. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
  294. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  295. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=23
      AND `file_is_image`=0
      AND `file_published`=1
  296. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='23'
  297. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  298. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=23
  299. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=23
  300. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=22
  301. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='22'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  302. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=22
  303. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  304. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='22'
  305. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  306. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=22
  307. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='22'
  308. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=22
  309. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=22
      AND `file_is_image`=1
      AND `file_published`=1
  310. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=22
  311. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  312. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=22
      AND `file_is_image`=0
      AND `file_published`=1
  313. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='22'
  314. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  315. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=22
  316. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=22
  317. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=26
  318. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='26'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=26
  320. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  321. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='26'
  322. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=26
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  323. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=26
  324. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='26'
  325. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=26
  326. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=26
      AND `file_is_image`=1
      AND `file_published`=1
  327. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=26
  328. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  329. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=26
      AND `file_is_image`=0
      AND `file_published`=1
  330. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='26'
  331. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  332. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=26
  333. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=26
  334. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=25
  335. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='25'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  336. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=25
  337. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  338. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='25'
  339. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=25
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  340. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=25
  341. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='25'
  342. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=25
  343. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=25
      AND `file_is_image`=1
      AND `file_published`=1
  344. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=25
  345. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  346. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=25
      AND `file_is_image`=0
      AND `file_published`=1
  347. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='25'
  348. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  349. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=25
  350. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=25
  351. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=24
  352. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='24'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  353. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=24
  354. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770697059' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  355. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='24'
  356. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  357. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=24
  358. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='24'
  359. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=24
  360. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=24
      AND `file_is_image`=1
      AND `file_published`=1
  361. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=24
  362. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  363. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=24
      AND `file_is_image`=0
      AND `file_published`=1
  364. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='24'
  365. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  366. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=24
  367. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=24
  368. 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='211'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  369. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 266)
      ORDER BY menuid DESC
      LIMIT 0, 1
  370. 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 = 266 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  371. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  372. 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 =211
      ORDER BY m.mf_name ASC

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

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

Нет

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

Нет