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

motoring2013@gmail.com

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

Каталог

Шины для кроссовых мотоциклов с диаметом диска от 10 до 21 дюймов



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

Мотошина 100/100-18 DELI TIRE SB-119 (Мотокросс)

2 047.23 грн


Мотошина 100/100-18 DELI TIRE SB-119 (Мотокросс)
[Подробнее...]


Мотошина 100/90-19 E 90 TL (SPORT)

1 210.54 грн


Мотошина 100/90-19 E 90 TL (SPORT)
[Подробнее...]


Мотошина 80/90-21 DELI TIRE SB-107 KROSS

1 477.57 грн


Мотошина 80/90-21 DELI TIRE SB-107 KROSS
[Подробнее...]



Мотошина 90/90-21 DELI TIRE SB-139 KROSS TT

1 637.78 грн


Мотошина 90/90-21 DELI TIRE SB-139 KROSS TT
[Подробнее...]


Мотошины DELI TIRE SB-114(110/90-19).

2 306.78 грн


Резина DELI TIRE SB-114(110/90-19)мотокросс.
[Подробнее...]


Мотошины DELI TIRE SB-114(90/100-16).

1 758.00 грн


Резина DELI TIRE SB-114(90/100-16)мотокросс.
[Подробнее...]



Мотошины DELI TIRE SB-114F(70/100-19).

1 265.01 грн


Резина DELI TIRE SB-114F(70/100-19)мотокросс.
[Подробнее...]


Мотошины DELI TIRE SB-117 (100/80-17).

1 571.97 грн


Резина DELI TIRE SB-117 (100/80-17).
[Подробнее...]


Мотошины DELI TIRE SB-120 (3,00-21).

1 646.38 грн


Шины DELI TIRE SB-120 (3,00-21). Производитель Индонезия.
[Подробнее...]



Мотошины DELI TIRE SB-120(90/90-21).

1 646.38 грн


Резина DELI TIRE SB-120(90/90-21)мотокросс.
[Подробнее...]


Мотошины KTO-1207 110/90-16

1 748.70 грн


Мотошины KTO-1207 110/90-16
[Подробнее...]


Мотошины MARELI F-897 KROSS в размере 100/100-17.

2 443.65 грн


Резина MARELI F-897 KROSS в размере (100/100-17).
[Подробнее...]



Мотошины 2,75-21 CROSS MOD 70E

801.09 грн


Мотошины 2,75-21 CROSS MOD 70E
[Подробнее...]


Мотошины 2,75-21 ENDURO Mod YX-P126

801.09 грн


Мотошины 2,75-21 ENDURO Mod YX-P126
[Подробнее...]


Мотошины 2,75-21 ENDURO Mod YX-P61

801.09 грн


Мотошины2,75-21 ENDURO Mod YX-P61
[Подробнее...]



Мотошины DELI TIRE S-114 (2.50-10).

530.19 грн


Резина DELI TIRE S-114 (2.50-10)мотокросс.
[Подробнее...]


Мотошины DELI TIRE SB-107(110/80-18).

1 851.02 грн


Шины DELI TIRE SB-107(110/80-18). Производитель Индонезия.
[Подробнее...]


Мотошины DELI TIRE SB-111 (2,75-17).

892.95 грн


Шины DELI TIRE SB-111 (2,75-17). Производитель Индонезия.
[Подробнее...]



Мотошины DELI TIRE SB-111 (3,00-14).

1 395.23 грн


Шины DELI TIRE SB-111 (3,00-14). Производитель Индонезия.
[Подробнее...]


Мотошины DELI TIRE SB-111 (3.50-17).

1 897.53 грн


Резина DELI TIRE SB-111 (3.50-17).
[Подробнее...]





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

Интернет-магазин "Моторинг" предлагает Вам купить резину  мотокросс по оптимальным ценам.

Шины мотокросс DELI TIRE производство Индонезия, цениться высоким качеством за минимальную стоимость для данного класса шин. Интернет магазин предлагает купить шины мотокросс таких размеров как: 2.50-10 DELI TIRE S-114 KROSS, 80/100-14 DELI TIRE SB-111 KROSS, 90/100-16 DELI TIRE SB-114F KROSS, 2.75-17 DELI TIRE SB-111 KROSS, 3.50-17 DELI TIRE SB-111 KROSS, 100/100-17 MARELI F-897 KROSS, 110/100-17 MARELI F-897 KROSS, 3.00-18 DELI TIRE S-111 KROSS, 3.50-18 DELI TIRE S-111 KROSS, 100/100-18 DELI TIRE SB-114 TERRA CROSS, 110/100-18 DELI TIRE SB-114 TERRA CROSS, 120/90-18 SEDONA Н-888 KROSS, 70/100-19 DELI TIRE SB-114F KROSS, 110/90-19 SEDONA Н-888 KROSS, 100/90-19 DELI TIRE SB-114R KROSS, 110/90-19 DELI TIRE SB-114R KROSS, 120/80-19 CHAO-YANG SEDONA Н-888 KROSS, 80/100-21 DELI TIRE SB-114F KROSS, 90/90-21 DELI TIRE SB-117 ЭНДУРО, 90/90-21 DELI TIRE SB-120 KROSS

< Доставка по Украине.

< Каталог в стадии наполнения.

< Не нашли то, что Вам нужно Звоните в салон. По вопросам покупки запчастей, звоните по телефонам в Украине: Тел. 095-72-346-44, 096-42-084-14, 063-93-093-44

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

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

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

Процесс покупки прост и понятен даже новичку интернет-торговли, он состоит из этапов выбора, оплаты и получения товара. Выбирать шины для кроссовых мотоциклов можно самому или при помощи консультанта, оплата проводится различными способами, а получение возможно в Харькове лично или по всей Украине в отделениях автоперевозчиков. Важно то, что почти все операции с товарами можно осуществить самостоятельно, но также можно поручить все сделать сотрудникам интернет-магазина Motoring.

Корзина

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

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




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

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.020 seconds, 3.98 MB
Application afterRoute: 0.028 seconds, 5.58 MB
Application afterDispatch: 0.219 seconds, 16.19 MB
Application afterRender: 0.325 seconds, 18.19 MB

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

19189688

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = '4p3rqet0nqe8un5digbrhdtl36'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1769602722' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '4p3rqet0nqe8un5digbrhdtl36'
  4. UPDATE `jos_session`
      SET `time`='1769604822',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1769604817;s:18:\"session.timer.last\";i:1769604820;s:17:\"session.timer.now\";i:1769604821;s:24:\"session.client.forwarded\";s:14:\"216.73.216.187\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";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:\"237\";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:53:{i:3391;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4024;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7441;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7440;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1379;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1381;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1380;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1378;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:52;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1208;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1207;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1216;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5093;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8099;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7829;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8101;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8102;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8103;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8104;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8105;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8106;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8107;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8109;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8110;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8111;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8112;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8113;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8114;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8115;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8116;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8117;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8128;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8118;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1692;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1687;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2949;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3048;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3303;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5796;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5797;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2953;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5798;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7200;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2950;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2951;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2952;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3050;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2954;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3049;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2955;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3683;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2956;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3365;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}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='4p3rqet0nqe8un5digbrhdtl36'
  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`=90
     
      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='90'
  21. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='90'
  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='90'
      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='90'
      AND jos_vm_category.category_id='90'
  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`=90
     
      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`=7546
  28. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7546'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7546
  30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  31. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7546'
  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=7546
      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=7546
  35. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7546'
  36. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7546
  37. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7546
      AND `file_is_image`=1
      AND `file_published`=1
  38. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7546
  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`=7546
      AND `file_is_image`=0
      AND `file_published`=1
  41. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7546'
  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`=7546
  44. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7546
  45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7554
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7554'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7554
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  49. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7554'
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7554
      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=7554
  52. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7554'
  53. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7554
  54. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7554
      AND `file_is_image`=1
      AND `file_published`=1
  55. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7554
  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`=7554
      AND `file_is_image`=0
      AND `file_published`=1
  58. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7554'
  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`=7554
  61. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7554
  62. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7557
  63. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7557'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  64. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7557
  65. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  66. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7557'
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7557
      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=7557
  69. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7557'
  70. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7557
  71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7557
      AND `file_is_image`=1
      AND `file_published`=1
  72. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7557
  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`=7557
      AND `file_is_image`=0
      AND `file_published`=1
  75. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7557'
  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`=7557
  78. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7557
  79. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7558
  80. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7558'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  81. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7558
  82. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  83. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7558'
  84. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7558
      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=7558
  86. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7558'
  87. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7558
  88. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7558
      AND `file_is_image`=1
      AND `file_published`=1
  89. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7558
  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`=7558
      AND `file_is_image`=0
      AND `file_published`=1
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7558'
  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`=7558
  95. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7558
  96. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=113
  97. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='113'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=113
  99. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  100. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='113'
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=113
      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=113
  103. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='113'
  104. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=113
  105. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=113
      AND `file_is_image`=1
      AND `file_published`=1
  106. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=113
  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`=113
      AND `file_is_image`=0
      AND `file_published`=1
  109. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='113'
  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`=113
  112. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=113
  113. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=108
  114. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='108'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=108
  116. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  117. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='108'
  118. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=108
      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=108
  120. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='108'
  121. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=108
  122. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=108
      AND `file_is_image`=1
      AND `file_published`=1
  123. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=108
  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`=108
      AND `file_is_image`=0
      AND `file_published`=1
  126. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='108'
  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`=108
  129. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=108
  130. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=111
  131. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='111'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=111
  133. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  134. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='111'
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=111
      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=111
  137. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='111'
  138. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=111
  139. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=111
      AND `file_is_image`=1
      AND `file_published`=1
  140. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=111
  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`=111
      AND `file_is_image`=0
      AND `file_published`=1
  143. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='111'
  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`=111
  146. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=111
  147. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=97
  148. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='97'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=97
  150. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='97'
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=97
      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=97
  154. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='97'
  155. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=97
  156. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=97
      AND `file_is_image`=1
      AND `file_published`=1
  157. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=97
  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`=97
      AND `file_is_image`=0
      AND `file_published`=1
  160. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='97'
  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`=97
  163. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=97
  164. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1884
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1884'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1884
  167. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  168. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1884'
  169. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1884
      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=1884
  171. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1884'
  172. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1884
  173. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1884
      AND `file_is_image`=1
      AND `file_published`=1
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1884
  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`=1884
      AND `file_is_image`=0
      AND `file_published`=1
  177. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1884'
  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`=1884
  180. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1884
  181. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=115
  182. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='115'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  183. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=115
  184. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='115'
  186. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=115
      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=115
  188. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='115'
  189. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=115
  190. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=115
      AND `file_is_image`=1
      AND `file_published`=1
  191. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=115
  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`=115
      AND `file_is_image`=0
      AND `file_published`=1
  194. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='115'
  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`=115
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=115
  198. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5859
  199. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5859'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5859
  201. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5859'
  203. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5859
      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=5859
  205. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5859'
  206. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5859
  207. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5859
      AND `file_is_image`=1
      AND `file_published`=1
  208. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5859
  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`=5859
      AND `file_is_image`=0
      AND `file_published`=1
  211. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5859'
  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`=5859
  214. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5859
  215. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1467
  216. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1467'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1467
  218. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1467'
  220. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1467
      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=1467
  222. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1467'
  223. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1467
  224. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1467
      AND `file_is_image`=1
      AND `file_published`=1
  225. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1467
  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`=1467
      AND `file_is_image`=0
      AND `file_published`=1
  228. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1467'
  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`=1467
  231. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1467
  232. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7280
  233. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7280'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  234. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7280
  235. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  236. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7280'
  237. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7280
      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=7280
  239. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7280'
  240. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7280
  241. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7280
      AND `file_is_image`=1
      AND `file_published`=1
  242. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7280
  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`=7280
      AND `file_is_image`=0
      AND `file_published`=1
  245. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7280'
  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`=7280
  248. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7280
  249. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7282
  250. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7282'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  251. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7282
  252. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  253. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7282'
  254. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7282
      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=7282
  256. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7282'
  257. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7282
  258. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7282
      AND `file_is_image`=1
      AND `file_published`=1
  259. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7282
  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`=7282
      AND `file_is_image`=0
      AND `file_published`=1
  262. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7282'
  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`=7282
  265. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7282
  266. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7281
  267. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7281'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7281
  269. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  270. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7281'
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7281
      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=7281
  273. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7281'
  274. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7281
  275. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7281
      AND `file_is_image`=1
      AND `file_published`=1
  276. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7281
  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`=7281
      AND `file_is_image`=0
      AND `file_published`=1
  279. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7281'
  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`=7281
  282. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7281
  283. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=107
  284. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='107'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  285. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=107
  286. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='107'
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=107
      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=107
  290. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='107'
  291. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=107
  292. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=107
      AND `file_is_image`=1
      AND `file_published`=1
  293. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=107
  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`=107
      AND `file_is_image`=0
      AND `file_published`=1
  296. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='107'
  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`=107
  299. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=107
  300. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1874
  301. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1874'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  302. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1874
  303. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  304. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1874'
  305. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1874
      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=1874
  307. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1874'
  308. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1874
  309. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1874
      AND `file_is_image`=1
      AND `file_published`=1
  310. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1874
  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`=1874
      AND `file_is_image`=0
      AND `file_published`=1
  313. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1874'
  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`=1874
  316. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1874
  317. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1877
  318. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1877'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1877
  320. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  321. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1877'
  322. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1877
      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=1877
  324. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1877'
  325. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1877
  326. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1877
      AND `file_is_image`=1
      AND `file_published`=1
  327. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1877
  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`=1877
      AND `file_is_image`=0
      AND `file_published`=1
  330. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1877'
  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`=1877
  333. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1877
  334. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1878
  335. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1878'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  336. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1878
  337. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  338. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1878'
  339. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1878
      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=1878
  341. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1878'
  342. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1878
  343. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1878
      AND `file_is_image`=1
      AND `file_published`=1
  344. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1878
  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`=1878
      AND `file_is_image`=0
      AND `file_published`=1
  347. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1878'
  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`=1878
  350. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1878
  351. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=70
  352. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='70'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  353. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=70
  354. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  355. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='70'
  356. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=70
      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=70
  358. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='70'
  359. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=70
  360. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=70
      AND `file_is_image`=1
      AND `file_published`=1
  361. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=70
  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`=70
      AND `file_is_image`=0
      AND `file_published`=1
  364. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='70'
  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`=70
  367. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=70
  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='90'

      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 = 143)
      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 = 143 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 =90
      ORDER BY m.mf_name ASC

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = '4p3rqet0nqe8un5digbrhdtl36'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1769602722' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '4p3rqet0nqe8un5digbrhdtl36'
  4. UPDATE `jos_session`
      SET `time`='1769604822',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1769604817;s:18:\"session.timer.last\";i:1769604820;s:17:\"session.timer.now\";i:1769604821;s:24:\"session.client.forwarded\";s:14:\"216.73.216.187\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";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:\"237\";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:53:{i:3391;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4024;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7441;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7440;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1379;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1381;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1380;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1378;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:52;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1208;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1207;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1216;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5093;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604817;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8099;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7829;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8101;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8102;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8103;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8104;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8105;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8106;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8107;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8109;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8110;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8111;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8112;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8113;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8114;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8115;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8116;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8117;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8128;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8118;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604819;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1692;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1687;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2949;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3048;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3303;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5796;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5797;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2953;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:5798;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:7200;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2950;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2951;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2952;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3050;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2954;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3049;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2955;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3683;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2956;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3365;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1769604821;}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='4p3rqet0nqe8un5digbrhdtl36'
  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`=90
     
      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='90'
  21. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='90'
  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='90'
      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='90'
      AND jos_vm_category.category_id='90'
  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`=90
     
      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`=7546
  28. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7546'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7546
  30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  31. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7546'
  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=7546
      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=7546
  35. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7546'
  36. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7546
  37. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7546
      AND `file_is_image`=1
      AND `file_published`=1
  38. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7546
  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`=7546
      AND `file_is_image`=0
      AND `file_published`=1
  41. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7546'
  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`=7546
  44. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7546
  45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7554
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7554'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7554
  48. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  49. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7554'
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7554
      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=7554
  52. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7554'
  53. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7554
  54. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7554
      AND `file_is_image`=1
      AND `file_published`=1
  55. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7554
  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`=7554
      AND `file_is_image`=0
      AND `file_published`=1
  58. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7554'
  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`=7554
  61. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7554
  62. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7557
  63. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7557'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  64. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7557
  65. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  66. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7557'
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7557
      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=7557
  69. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7557'
  70. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7557
  71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7557
      AND `file_is_image`=1
      AND `file_published`=1
  72. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7557
  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`=7557
      AND `file_is_image`=0
      AND `file_published`=1
  75. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7557'
  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`=7557
  78. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7557
  79. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7558
  80. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7558'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  81. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7558
  82. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  83. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7558'
  84. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7558
      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=7558
  86. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7558'
  87. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7558
  88. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7558
      AND `file_is_image`=1
      AND `file_published`=1
  89. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7558
  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`=7558
      AND `file_is_image`=0
      AND `file_published`=1
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7558'
  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`=7558
  95. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7558
  96. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=113
  97. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='113'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=113
  99. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  100. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='113'
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=113
      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=113
  103. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='113'
  104. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=113
  105. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=113
      AND `file_is_image`=1
      AND `file_published`=1
  106. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=113
  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`=113
      AND `file_is_image`=0
      AND `file_published`=1
  109. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='113'
  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`=113
  112. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=113
  113. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=108
  114. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='108'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=108
  116. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  117. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='108'
  118. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=108
      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=108
  120. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='108'
  121. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=108
  122. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=108
      AND `file_is_image`=1
      AND `file_published`=1
  123. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=108
  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`=108
      AND `file_is_image`=0
      AND `file_published`=1
  126. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='108'
  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`=108
  129. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=108
  130. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=111
  131. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='111'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=111
  133. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  134. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='111'
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=111
      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=111
  137. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='111'
  138. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=111
  139. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=111
      AND `file_is_image`=1
      AND `file_published`=1
  140. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=111
  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`=111
      AND `file_is_image`=0
      AND `file_published`=1
  143. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='111'
  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`=111
  146. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=111
  147. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=97
  148. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='97'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=97
  150. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='97'
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=97
      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=97
  154. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='97'
  155. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=97
  156. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=97
      AND `file_is_image`=1
      AND `file_published`=1
  157. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=97
  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`=97
      AND `file_is_image`=0
      AND `file_published`=1
  160. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='97'
  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`=97
  163. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=97
  164. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1884
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1884'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1884
  167. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  168. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1884'
  169. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1884
      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=1884
  171. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1884'
  172. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1884
  173. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1884
      AND `file_is_image`=1
      AND `file_published`=1
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1884
  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`=1884
      AND `file_is_image`=0
      AND `file_published`=1
  177. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1884'
  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`=1884
  180. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1884
  181. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=115
  182. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='115'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  183. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=115
  184. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='115'
  186. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=115
      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=115
  188. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='115'
  189. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=115
  190. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=115
      AND `file_is_image`=1
      AND `file_published`=1
  191. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=115
  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`=115
      AND `file_is_image`=0
      AND `file_published`=1
  194. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='115'
  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`=115
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=115
  198. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5859
  199. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5859'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5859
  201. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5859'
  203. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5859
      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=5859
  205. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5859'
  206. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5859
  207. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5859
      AND `file_is_image`=1
      AND `file_published`=1
  208. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5859
  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`=5859
      AND `file_is_image`=0
      AND `file_published`=1
  211. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5859'
  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`=5859
  214. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5859
  215. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1467
  216. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1467'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1467
  218. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1467'
  220. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1467
      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=1467
  222. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1467'
  223. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1467
  224. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1467
      AND `file_is_image`=1
      AND `file_published`=1
  225. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1467
  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`=1467
      AND `file_is_image`=0
      AND `file_published`=1
  228. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1467'
  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`=1467
  231. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1467
  232. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7280
  233. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7280'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  234. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7280
  235. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  236. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7280'
  237. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7280
      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=7280
  239. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7280'
  240. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7280
  241. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7280
      AND `file_is_image`=1
      AND `file_published`=1
  242. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7280
  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`=7280
      AND `file_is_image`=0
      AND `file_published`=1
  245. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7280'
  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`=7280
  248. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7280
  249. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7282
  250. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7282'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  251. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7282
  252. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  253. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7282'
  254. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7282
      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=7282
  256. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7282'
  257. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7282
  258. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7282
      AND `file_is_image`=1
      AND `file_published`=1
  259. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7282
  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`=7282
      AND `file_is_image`=0
      AND `file_published`=1
  262. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7282'
  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`=7282
  265. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7282
  266. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7281
  267. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7281'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7281
  269. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  270. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7281'
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7281
      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=7281
  273. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7281'
  274. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7281
  275. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=7281
      AND `file_is_image`=1
      AND `file_published`=1
  276. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7281
  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`=7281
      AND `file_is_image`=0
      AND `file_published`=1
  279. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='7281'
  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`=7281
  282. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7281
  283. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=107
  284. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='107'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  285. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=107
  286. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='107'
  288. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=107
      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=107
  290. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='107'
  291. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=107
  292. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=107
      AND `file_is_image`=1
      AND `file_published`=1
  293. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=107
  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`=107
      AND `file_is_image`=0
      AND `file_published`=1
  296. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='107'
  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`=107
  299. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=107
  300. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1874
  301. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1874'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  302. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1874
  303. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  304. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1874'
  305. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1874
      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=1874
  307. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1874'
  308. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1874
  309. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1874
      AND `file_is_image`=1
      AND `file_published`=1
  310. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1874
  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`=1874
      AND `file_is_image`=0
      AND `file_published`=1
  313. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1874'
  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`=1874
  316. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1874
  317. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1877
  318. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1877'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1877
  320. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  321. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1877'
  322. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1877
      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=1877
  324. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1877'
  325. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1877
  326. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1877
      AND `file_is_image`=1
      AND `file_published`=1
  327. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1877
  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`=1877
      AND `file_is_image`=0
      AND `file_published`=1
  330. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1877'
  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`=1877
  333. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1877
  334. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1878
  335. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1878'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  336. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1878
  337. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  338. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1878'
  339. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1878
      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=1878
  341. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1878'
  342. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1878
  343. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1878
      AND `file_is_image`=1
      AND `file_published`=1
  344. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1878
  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`=1878
      AND `file_is_image`=0
      AND `file_published`=1
  347. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1878'
  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`=1878
  350. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1878
  351. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=70
  352. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='70'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  353. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=70
  354. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1769604822' OR start_date=0)
      AND (end_date>='1769556960' OR end_date=0)
      AND product_discount_id=discount_id
  355. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='70'
  356. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=70
      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=70
  358. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='70'
  359. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=70
  360. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=70
      AND `file_is_image`=1
      AND `file_published`=1
  361. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=70
  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`=70
      AND `file_is_image`=0
      AND `file_published`=1
  364. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='70'
  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`=70
  367. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=70
  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='90'

      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 = 143)
      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 = 143 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 =90
      ORDER BY m.mf_name ASC

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

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

Нет

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

Нет