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

motoring2013@gmail.com

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

Каталог

Запчасти для мотоциклов SHINERAY XY250-3A (Z1)



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

Амортизатор передний (пара) SHINERAY XY250-3A (Z1)

2 767.08 грн


Амортизатор передний (пара) SHINERAY XY250-3A (Z1)
[Подробнее...]


Блок управления (пара) SHINERAY XY250-3A (Z1)

754.26 грн


Блок управления (пара) SHINERAY XY250-3A (Z1)
[Подробнее...]


Болт крепления задней звезды (4шт) SHINERAY XY250-3A (Z1)

165.12 грн


Болт крепления задней звезды (4шт) SHINERAY XY250-3A (Z1)
[Подробнее...]



Верхняя пластина траверсы SHINERAY XY250-3A (Z1)

1 260.58 грн


Верхняя пластина траверсы SHINERAY XY250-3A (Z1)
[Подробнее...]


Вилка(подвеска) VIPER F2

1 749.10 грн


Вилка(подвеска) Viper F2 (Вайпер Ф2), Mustang MT 200-10 (Мустанг МТ 200-10), Spike ZZ CBR250RR-3 (Спайке зз 250).
[Подробнее...]


Гайка сцепления SHINERAY XY250-3A (Z1)

348.61 грн


Гайка сцепления SHINERAY XY250-3A (Z1)
[Подробнее...]



Гидравлика заднего тормоза в сборе SHINERAY XY250-3A (Z1)

1 364.27 грн


Гидравлика заднего тормоза в сборе SHINERAY XY250-3A (Z1)
[Подробнее...]


Гидравлика переднего тормоза в сборе SHINERAY XY250-3A (Z1)

1 214.51 грн


Гидравлика переднего тормоза в сборе SHINERAY XY250-3A (Z1)
[Подробнее...]


Глушитель в сборе SHINERAY XY250-3A (Z1)

3 728.58 грн


Глушитель в сборе SHINERAY XY250-3A (Z1)
[Подробнее...]



Датчик топлива SHINERAY XY250-3A (Z1)

295.12 грн


Датчик топлива SHINERAY XY250-3A (Z1)
[Подробнее...]


Демпфер+звезда 520*41 SHINERAY XY250-3A (Z1)

687.37 грн


Демпфер+звезда 520*41 SHINERAY XY250-3A (Z1)
[Подробнее...]


Диск задний R17*4,0J SHINERAY XY250-3A (Z1)

3 579.43 грн


Диск задний R17*4,0J SHINERAY XY250-3A (Z1)
[Подробнее...]



Диск передний R17*3,0J SHINERAY XY250-3A (Z1)

3 384.89 грн


Диск передний R17*3,0J SHINERAY XY250-3A (Z1)
[Подробнее...]


Заглушки руля (пара) SHINERAY XY250-3A (Z1)

284.83 грн


Заглушки руля (пара) SHINERAY XY250-3A (Z1)
[Подробнее...]


Замок зажигания SHINERAY XY250-3A (Z1)

1 058.11 грн


Замок зажигания SHINERAY XY250-3A (Z1)
[Подробнее...]



Зеркала заднего вида (л+п) SHINERAY XY250-3A (Z1)

1 020.19 грн


Зеркала заднего вида (л+п) SHINERAY XY250-3A (Z1)
[Подробнее...]


Игольчатый подшипник HK101410 SHINERAY XY250-3A (Z1)

76.04 грн


Игольчатый подшипник HK101410 SHINERAY XY250-3A (Z1)
[Подробнее...]


Игольчатый подшипник KK263124 SHINERAY XY250-3A (Z1)

76.04 грн


Игольчатый подшипник KK263124 SHINERAY XY250-3A (Z1)
[Подробнее...]



Игольчатый подшипник рычага сцепления HK121610 SHINERAY XY250-3A

76.04 грн


Игольчатый подшипник рычага сцепления HK121610 SHINERAY XY250-3A (Z1)
[Подробнее...]


Карбюратор SHINERAY XY250-3A (Z1)

1 455.77 грн


Карбюратор SHINERAY XY250-3A (Z1)
[Подробнее...]





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

Стремительная двухколесная техника, похоже, никогда не перестанет волновать сердца людей. Да, все знают, что на мотоцикле менее комфортно ездить, чем на автомобиле, он открыт для дождя или снега, но скоростные, динамические, маневренные возможности в разы лучше у небольших юрких машин. Что говорить, если даже в многочисленных фильмах о будущем самый быстрый наземный транспорт в том или ином виде повторяет современные мотоциклы, только перемещается он, в основном, над землей, при помощи «антигравитации». То, что будет происходить в будущем, всерьез мало кого волнует, зато сейчас можно получить массу удовольствия от быстрой езды при помощи таких недорогих мотобайков, как SHINERAY XY250-3A (Z1).

Спортивный мотоцикл SHINERAY XY250-3A стал ожидаемой и популярной новинкой 2018 года, и хоть изменения не кардинальные, все же качественный пластик, улучшенная оптика, удобная посадка пилота – все это понравилось потенциальным покупателям. Спортбайк способен развивать скорость до 150 км в час, чего недостаточно для соревнований с японскими или немецкими машинами, но вполне хватает для езды по городу и пригородным трассам. Особенную актуальность для спортивных мотобайков представляют запасные детали. Если есть возможность купить запчасти для мотоциклов SHINERAY XY250-3A (Z1) хорошего качества и по низкой цене, можно смело рассекать на мотоцикле по любым дорогам.

Возможность купить запчасти для мотоциклов SHINERAY XY250-3A (Z1) представляет интернет-магазин Motoring, в котором собраны все существующие мотодетали.

Ассортимент интернет-магазина огромный, цены – низкие, есть опция доставки по всей Украине, что сейчас особенно актуально. Подобрать мотозапчасти можно самостоятельно или же доверить вопрос выбора менеджерам компании Motoring.

 

Интернет-магазин MotoRing предлагает новые мотоциклы Venom. Компания Venom выпускает копии японских мотоциклов Honda, Yamaha, Syzuki которые выпускались с 2002 по 2009 год . Купить новый мотоцикл Вы всегда можете в нашем магазине по низким ценам. Мотоцикл Honda, Yamaha, Syzuki купить в Харькове!

Компания Venom делает производит очень качественные мотоциклы 200 и 250 куб.см. Мотоциклы завода Venom ценятся не только надежными двигателями (гарантия 30000 км), а также качественной подвеской, и в целом техническими и динамическими качествами кроссовых и спортивных мотоциклов. На мотоциклах VENOM установленные сертифицированные двигателя с балансировочным валом завода Zongshen. Завод Zongshen один из немногих заводов китая, которая пользуеться популярностью как в Европе так и в Америке. Также можно отметить тот факт что на мотоциклах Venom установлены шины компании Deli Tire (Индонезия), которая также очень плотно работает на рынок Европы и Америки. Интернет магазин МотоРинг предлагает купить по самым низким ценам в Украине такие мотоциклы как: Мотоцикл VIPER ZS200N, Мотоцикл Viper ZS125A, Мотоцикл Viper ZS150A, Мотоцикл Viper F5, Мотоцикл Viper ZS200-R2, Мотоцикл Viper MX200R, Мотоцикл Viper ZS200N, Мотоцикл Viper ZUBR, Мотоцикл Viper ZS200GY-2C, Мотоцикл Viper ZS250GY-2C, Мотоцикл Vipr R1, Мотоцикл Vipr R2, Мотоцикл Vipr R3, Мотоцикл Zongshen ZS200GS, Мотоцикл Zongshen ZS250GS, Мотоцикл Zongshen ZS250GY, Мотоцикл SPIKE ZZ CBR250RR, Мотоцикл VENOM VM200-19, Мотоцикл VENOM VM - 250CBF, Мотоцикл VENOM VM - 200CBP, Мотоцикл VENOM VM250-21, Мотоцикл VENOM X-CROSS 250GY-7.

Заказать новый мотоцикл Вы можете позвонив нам по номерам указанным на нашем сайте или сделав заказ онлайн!

Корзина

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

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




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

Application afterLoad: 0.000 seconds, 0.89 MB
Application afterInitialise: 0.025 seconds, 3.95 MB
Application afterRoute: 0.036 seconds, 5.56 MB
Application afterDispatch: 0.498 seconds, 16.19 MB
Application afterRender: 0.723 seconds, 18.21 MB

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

19210280

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = '2313lil66qkrvtlsnq43ldvgg7'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1770689200' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '2313lil66qkrvtlsnq43ldvgg7'
  4. UPDATE `jos_session`
      SET `time`='1770691300',`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:1770691296;s:18:\"session.timer.last\";i:1770691299;s:17:\"session.timer.now\";i:1770691299;s:24:\"session.client.forwarded\";s:14:\"216.73.216.185\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/home/motoring/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}VMCHECK|s:2:\"OK\";auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:6:\"грн\";userstate|a:1:{s:10:\"product_id\";i:0;}last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:3:\"242\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";product_sess|a:40:{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:1770691297;}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:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4529;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2618;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3798;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4530;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4531;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2619;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2620;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3523;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2163;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3514;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4532;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2665;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4533;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4534;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4535;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4536;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4537;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4538;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4457;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6567;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4432;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6568;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4512;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4433;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4431;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6569;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4434;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4515;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4435;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6570;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4436;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4437;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4438;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6571;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6572;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4439;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4440;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6573;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}'
      WHERE session_id='2313lil66qkrvtlsnq43ldvgg7'
  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`=21
     
      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='21'
  21. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='21'
  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='21'
      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='21'
      AND jos_vm_category.category_id='21'
  24. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=21
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 20
  26. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5524
  27. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5524'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  28. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5524
  29. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  30. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5524'
  31. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  32. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5524
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  33. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5524
  34. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5524'
  35. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5524
  36. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5524
      AND `file_is_image`=1
      AND `file_published`=1
  37. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5524
      AND `file_is_image`=0
      AND `file_published`=1
  38. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5524'
  39. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  40. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5524
  41. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5524
  42. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5525
  43. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5525'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  44. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5525
  45. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  46. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5525'
  47. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5525
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  48. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5525
  49. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5525'
  50. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5525
  51. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5525
      AND `file_is_image`=1
      AND `file_published`=1
  52. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5525
      AND `file_is_image`=0
      AND `file_published`=1
  53. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5525'
  54. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  55. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5525
  56. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5525
  57. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5526
  58. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5526'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5526
  60. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  61. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5526'
  62. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5526
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  63. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5526
  64. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5526'
  65. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5526
  66. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5526
      AND `file_is_image`=1
      AND `file_published`=1
  67. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5526
  68. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  69. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5526
      AND `file_is_image`=0
      AND `file_published`=1
  70. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5526'
  71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  72. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5526
  73. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5526
  74. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5527
  75. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5527'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  76. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5527
  77. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  78. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5527'
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5527
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  80. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5527
  81. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5527'
  82. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5527
  83. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5527
      AND `file_is_image`=1
      AND `file_published`=1
  84. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5527
  85. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  86. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5527
      AND `file_is_image`=0
      AND `file_published`=1
  87. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5527'
  88. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  89. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5527
  90. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5527
  91. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2554
  92. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2554'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  93. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2554
  94. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  95. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2554'
  96. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2554
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  97. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2554
  98. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2554'
  99. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2554
  100. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2554
      AND `file_is_image`=1
      AND `file_published`=1
  101. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2554
  102. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  103. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2554
      AND `file_is_image`=0
      AND `file_published`=1
  104. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2554'
  105. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  106. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2554
  107. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2554
  108. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5528
  109. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5528'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  110. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5528
  111. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  112. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5528'
  113. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5528
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  114. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5528
  115. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5528'
  116. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5528
  117. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5528
      AND `file_is_image`=1
      AND `file_published`=1
  118. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5528
  119. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  120. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5528
      AND `file_is_image`=0
      AND `file_published`=1
  121. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5528'
  122. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  123. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5528
  124. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5528
  125. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5529
  126. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5529'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  127. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5529
  128. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5529'
  130. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5529
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  131. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5529
  132. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5529'
  133. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5529
  134. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5529
      AND `file_is_image`=1
      AND `file_published`=1
  135. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5529
      AND `file_is_image`=0
      AND `file_published`=1
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5529'
  137. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  138. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5529
  139. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5529
  140. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5530
  141. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5530'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  142. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5530
  143. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  144. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5530'
  145. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5530
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  146. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5530
  147. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5530'
  148. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5530
  149. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5530
      AND `file_is_image`=1
      AND `file_published`=1
  150. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5530
      AND `file_is_image`=0
      AND `file_published`=1
  151. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5530'
  152. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  153. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5530
  154. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5530
  155. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5531
  156. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5531'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  157. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5531
  158. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  159. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5531'
  160. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5531
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  161. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5531
  162. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5531'
  163. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5531
  164. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5531
      AND `file_is_image`=1
      AND `file_published`=1
  165. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5531
      AND `file_is_image`=0
      AND `file_published`=1
  166. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5531'
  167. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  168. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5531
  169. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5531
  170. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5532
  171. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5532'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  172. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5532
  173. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5532'
  175. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5532
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  176. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5532
  177. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5532'
  178. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5532
  179. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5532
      AND `file_is_image`=1
      AND `file_published`=1
  180. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5532
  181. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  182. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5532
      AND `file_is_image`=0
      AND `file_published`=1
  183. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5532'
  184. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  185. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5532
  186. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5532
  187. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5533
  188. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5533'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  189. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5533
  190. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  191. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5533'
  192. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5533
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  193. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5533
  194. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5533'
  195. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5533
  196. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5533
      AND `file_is_image`=1
      AND `file_published`=1
  197. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5533
      AND `file_is_image`=0
      AND `file_published`=1
  198. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5533'
  199. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  200. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5533
  201. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5533
  202. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5534
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5534'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5534
  205. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5534'
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5534
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5534
  209. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5534'
  210. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5534
  211. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5534
      AND `file_is_image`=1
      AND `file_published`=1
  212. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5534
  213. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  214. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5534
      AND `file_is_image`=0
      AND `file_published`=1
  215. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5534'
  216. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  217. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5534
  218. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5534
  219. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5535
  220. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5535'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  221. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5535
  222. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  223. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5535'
  224. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5535
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  225. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5535
  226. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5535'
  227. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5535
  228. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5535
      AND `file_is_image`=1
      AND `file_published`=1
  229. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5535
  230. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  231. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5535
      AND `file_is_image`=0
      AND `file_published`=1
  232. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5535'
  233. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  234. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5535
  235. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5535
  236. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5536
  237. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5536'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  238. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5536
  239. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  240. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5536'
  241. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5536
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  242. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5536
  243. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5536'
  244. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5536
  245. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5536
      AND `file_is_image`=1
      AND `file_published`=1
  246. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5536
  247. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  248. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5536
      AND `file_is_image`=0
      AND `file_published`=1
  249. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5536'
  250. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  251. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5536
  252. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5536
  253. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5537
  254. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5537'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5537
  256. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  257. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5537'
  258. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5537
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  259. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5537
  260. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5537'
  261. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5537
  262. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5537
      AND `file_is_image`=1
      AND `file_published`=1
  263. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5537
      AND `file_is_image`=0
      AND `file_published`=1
  264. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5537'
  265. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  266. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5537
  267. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5537
  268. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5538
  269. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5538'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  270. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5538
  271. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  272. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5538'
  273. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5538
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  274. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5538
  275. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5538'
  276. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5538
  277. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5538
      AND `file_is_image`=1
      AND `file_published`=1
  278. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5538
  279. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  280. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5538
      AND `file_is_image`=0
      AND `file_published`=1
  281. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5538'
  282. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  283. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5538
  284. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5538
  285. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5539
  286. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5539'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5539
  288. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  289. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5539'
  290. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5539
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  291. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5539
  292. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5539'
  293. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5539
  294. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5539
      AND `file_is_image`=1
      AND `file_published`=1
  295. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5539
  296. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  297. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5539
      AND `file_is_image`=0
      AND `file_published`=1
  298. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5539'
  299. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  300. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5539
  301. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5539
  302. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5540
  303. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5540'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  304. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5540
  305. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  306. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5540'
  307. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5540
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  308. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5540
  309. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5540'
  310. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5540
  311. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5540
      AND `file_is_image`=1
      AND `file_published`=1
  312. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5540
  313. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  314. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5540
      AND `file_is_image`=0
      AND `file_published`=1
  315. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5540'
  316. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  317. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5540
  318. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5540
  319. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5541
  320. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5541'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  321. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5541
  322. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  323. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5541'
  324. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5541
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  325. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5541
  326. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5541'
  327. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5541
  328. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5541
      AND `file_is_image`=1
      AND `file_published`=1
  329. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5541
  330. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  331. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5541
      AND `file_is_image`=0
      AND `file_published`=1
  332. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5541'
  333. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  334. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5541
  335. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5541
  336. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5542
  337. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5542'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  338. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5542
  339. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  340. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5542'
  341. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5542
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  342. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5542
  343. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5542'
  344. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5542
  345. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5542
      AND `file_is_image`=1
      AND `file_published`=1
  346. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5542
  347. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  348. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5542
      AND `file_is_image`=0
      AND `file_published`=1
  349. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5542'
  350. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  351. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5542
  352. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5542
  353. 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='21'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

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

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = '2313lil66qkrvtlsnq43ldvgg7'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1770689200' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '2313lil66qkrvtlsnq43ldvgg7'
  4. UPDATE `jos_session`
      SET `time`='1770691300',`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:1770691296;s:18:\"session.timer.last\";i:1770691299;s:17:\"session.timer.now\";i:1770691299;s:24:\"session.client.forwarded\";s:14:\"216.73.216.185\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/home/motoring/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}VMCHECK|s:2:\"OK\";auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:6:\"грн\";userstate|a:1:{s:10:\"product_id\";i:0;}last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:3:\"242\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";product_sess|a:40:{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:1770691297;}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:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4529;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2618;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3798;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4530;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4531;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2619;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2620;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3523;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2163;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:3514;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4532;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:2665;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4533;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4534;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4535;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4536;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4537;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4538;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691297;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4457;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6567;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4432;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6568;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4512;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4433;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4431;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6569;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4434;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4515;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4435;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6570;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4436;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4437;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4438;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6571;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6572;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4439;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:4440;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:6573;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1770691299;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}'
      WHERE session_id='2313lil66qkrvtlsnq43ldvgg7'
  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`=21
     
      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='21'
  21. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='21'
  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='21'
      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='21'
      AND jos_vm_category.category_id='21'
  24. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=21
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 20
  26. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5524
  27. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5524'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  28. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5524
  29. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  30. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5524'
  31. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  32. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5524
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  33. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5524
  34. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5524'
  35. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5524
  36. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5524
      AND `file_is_image`=1
      AND `file_published`=1
  37. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5524
      AND `file_is_image`=0
      AND `file_published`=1
  38. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5524'
  39. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  40. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5524
  41. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5524
  42. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5525
  43. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5525'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  44. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5525
  45. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  46. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5525'
  47. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5525
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  48. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5525
  49. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5525'
  50. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5525
  51. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5525
      AND `file_is_image`=1
      AND `file_published`=1
  52. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5525
      AND `file_is_image`=0
      AND `file_published`=1
  53. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5525'
  54. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  55. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5525
  56. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5525
  57. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5526
  58. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5526'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5526
  60. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  61. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5526'
  62. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5526
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  63. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5526
  64. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5526'
  65. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5526
  66. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5526
      AND `file_is_image`=1
      AND `file_published`=1
  67. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5526
  68. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  69. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5526
      AND `file_is_image`=0
      AND `file_published`=1
  70. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5526'
  71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  72. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5526
  73. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5526
  74. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5527
  75. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5527'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  76. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5527
  77. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  78. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5527'
  79. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5527
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  80. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5527
  81. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5527'
  82. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5527
  83. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5527
      AND `file_is_image`=1
      AND `file_published`=1
  84. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5527
  85. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  86. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5527
      AND `file_is_image`=0
      AND `file_published`=1
  87. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5527'
  88. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  89. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5527
  90. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5527
  91. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2554
  92. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2554'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  93. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2554
  94. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  95. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2554'
  96. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2554
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  97. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2554
  98. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2554'
  99. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2554
  100. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2554
      AND `file_is_image`=1
      AND `file_published`=1
  101. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2554
  102. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  103. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2554
      AND `file_is_image`=0
      AND `file_published`=1
  104. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2554'
  105. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  106. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2554
  107. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2554
  108. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5528
  109. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5528'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  110. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5528
  111. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  112. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5528'
  113. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5528
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  114. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5528
  115. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5528'
  116. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5528
  117. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5528
      AND `file_is_image`=1
      AND `file_published`=1
  118. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5528
  119. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  120. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5528
      AND `file_is_image`=0
      AND `file_published`=1
  121. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5528'
  122. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  123. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5528
  124. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5528
  125. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5529
  126. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5529'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  127. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5529
  128. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5529'
  130. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5529
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  131. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5529
  132. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5529'
  133. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5529
  134. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5529
      AND `file_is_image`=1
      AND `file_published`=1
  135. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5529
      AND `file_is_image`=0
      AND `file_published`=1
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5529'
  137. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  138. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5529
  139. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5529
  140. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5530
  141. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5530'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  142. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5530
  143. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691300' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  144. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5530'
  145. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5530
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  146. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5530
  147. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5530'
  148. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5530
  149. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5530
      AND `file_is_image`=1
      AND `file_published`=1
  150. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5530
      AND `file_is_image`=0
      AND `file_published`=1
  151. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5530'
  152. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  153. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5530
  154. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5530
  155. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5531
  156. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5531'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  157. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5531
  158. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  159. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5531'
  160. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5531
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  161. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5531
  162. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5531'
  163. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5531
  164. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5531
      AND `file_is_image`=1
      AND `file_published`=1
  165. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5531
      AND `file_is_image`=0
      AND `file_published`=1
  166. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5531'
  167. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  168. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5531
  169. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5531
  170. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5532
  171. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5532'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  172. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5532
  173. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5532'
  175. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5532
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  176. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5532
  177. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5532'
  178. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5532
  179. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5532
      AND `file_is_image`=1
      AND `file_published`=1
  180. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5532
  181. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  182. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5532
      AND `file_is_image`=0
      AND `file_published`=1
  183. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5532'
  184. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  185. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5532
  186. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5532
  187. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5533
  188. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5533'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  189. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5533
  190. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  191. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5533'
  192. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5533
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  193. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5533
  194. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5533'
  195. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5533
  196. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5533
      AND `file_is_image`=1
      AND `file_published`=1
  197. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5533
      AND `file_is_image`=0
      AND `file_published`=1
  198. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5533'
  199. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  200. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5533
  201. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5533
  202. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5534
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5534'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5534
  205. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5534'
  207. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5534
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  208. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5534
  209. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5534'
  210. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5534
  211. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5534
      AND `file_is_image`=1
      AND `file_published`=1
  212. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5534
  213. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  214. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5534
      AND `file_is_image`=0
      AND `file_published`=1
  215. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5534'
  216. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  217. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5534
  218. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5534
  219. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5535
  220. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5535'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  221. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5535
  222. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  223. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5535'
  224. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5535
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  225. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5535
  226. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5535'
  227. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5535
  228. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5535
      AND `file_is_image`=1
      AND `file_published`=1
  229. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5535
  230. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  231. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5535
      AND `file_is_image`=0
      AND `file_published`=1
  232. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5535'
  233. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  234. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5535
  235. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5535
  236. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5536
  237. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5536'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  238. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5536
  239. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  240. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5536'
  241. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5536
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  242. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5536
  243. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5536'
  244. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5536
  245. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5536
      AND `file_is_image`=1
      AND `file_published`=1
  246. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5536
  247. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  248. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5536
      AND `file_is_image`=0
      AND `file_published`=1
  249. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5536'
  250. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  251. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5536
  252. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5536
  253. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5537
  254. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5537'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5537
  256. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  257. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5537'
  258. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5537
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  259. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5537
  260. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5537'
  261. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5537
  262. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5537
      AND `file_is_image`=1
      AND `file_published`=1
  263. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5537
      AND `file_is_image`=0
      AND `file_published`=1
  264. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5537'
  265. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  266. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5537
  267. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5537
  268. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5538
  269. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5538'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  270. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5538
  271. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  272. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5538'
  273. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5538
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  274. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5538
  275. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5538'
  276. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5538
  277. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5538
      AND `file_is_image`=1
      AND `file_published`=1
  278. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5538
  279. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  280. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5538
      AND `file_is_image`=0
      AND `file_published`=1
  281. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5538'
  282. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  283. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5538
  284. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5538
  285. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5539
  286. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5539'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  287. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5539
  288. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  289. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5539'
  290. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5539
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  291. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5539
  292. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5539'
  293. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5539
  294. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5539
      AND `file_is_image`=1
      AND `file_published`=1
  295. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5539
  296. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  297. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5539
      AND `file_is_image`=0
      AND `file_published`=1
  298. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5539'
  299. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  300. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5539
  301. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5539
  302. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5540
  303. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5540'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  304. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5540
  305. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  306. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5540'
  307. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5540
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  308. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5540
  309. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5540'
  310. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5540
  311. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5540
      AND `file_is_image`=1
      AND `file_published`=1
  312. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5540
  313. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  314. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5540
      AND `file_is_image`=0
      AND `file_published`=1
  315. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5540'
  316. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  317. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5540
  318. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5540
  319. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5541
  320. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5541'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  321. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5541
  322. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  323. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5541'
  324. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5541
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  325. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5541
  326. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5541'
  327. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5541
  328. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5541
      AND `file_is_image`=1
      AND `file_published`=1
  329. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5541
  330. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  331. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5541
      AND `file_is_image`=0
      AND `file_published`=1
  332. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5541'
  333. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  334. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5541
  335. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5541
  336. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5542
  337. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5542'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  338. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5542
  339. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770691301' OR start_date=0)
      AND (end_date>='1770680160' OR end_date=0)
      AND product_discount_id=discount_id
  340. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5542'
  341. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5542
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  342. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5542
  343. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5542'
  344. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5542
  345. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5542
      AND `file_is_image`=1
      AND `file_published`=1
  346. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5542
  347. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  348. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=5542
      AND `file_is_image`=0
      AND `file_published`=1
  349. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='5542'
  350. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  351. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5542
  352. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5542
  353. 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='21'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'

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

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

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

Нет

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

Нет