Поиск...
Мы работаем: Пн-Пт: 10:00-19:00, Сб: 11:00-19:00, Вс: Выходной.
Наш телефон:+7(499)648-8884, Пишите в Whatsapp!(925)098-0396, (812)602-9984
Наш адрес... Кутузовский пр-т, 36, стр.3 (БЦ В.А.Казакова) вход 4, эт.4, оф.523
Каталог товаров
Распродажа до 50% КАБОШОНЫ    Авантюрин    Агаты    Аквамарин    Амазонит    Аметист    Аметрин    Аммониты    Анальцим    Апатит    Астрофиллит    Берилл    Бирюза    Бронзит    Бычий глаз    Варисцит    Гелиотроп    Гематит    Гиперстен    Говлит    Гранат    Дельхайелит    Диопсид    Дьюмортьерит    Жадеит    Жильбертит    Змеевик    Кальцит    Канкринит    Карфолит    Кахолонг    Кварц    Кианит    Коралл    Кошачий глаз    Кошачий глаз (стекло)    Кремень    Кремний    Ксонотлит    Кунцит    Лабрадор    Ларвикит    Лазурит    Ларимар    Лепидолит    Лизардит    Липарит    Лунный камень    Магнезит    Малахит    Мусковит    Натролит    Нефрит    Обсидиан    Опал    Опалит (стекло)    Офит    Парагонит    Пегматит    Переливт    Перламутр    Петалит    Петерсит    Пинолит    Пирит    Порфирит    Пренит    Пьемонтит    Пурпурит    Риолит    Роговик    Родонит    Родохрозит    Родусит    Розалит    Рубин    Сенгилит    Септария    Серафинит    Сердолик    Симбирцит    Симбирцитовые жеоды    Скарн    Слюдит    Содалит    Соколиный глаз    Солнечный камень    Спектролит    Стекло    Стекло дихроическое    Стекло матовое    Стихтит    Сфалерит    Сугилит    Танзанит    Тигровый глаз    Турмалин    Унакит    Флюорит    Фуксит    Хризоколла    Хризопраз    Хромдиопсид    Цитрин    Чароит    Шаттукит    Шунгит    Эвдиалит    Янтарь    Яшма    Lunasoft    В АССОРТИМЕНТЕ    Прочие    Pearl Cabochons(Чехия) Подвески Каменная крошка Окаменелости Kaboshon Box Swarovski Бисер Бусины Жемчуг Журналы и книги Иглы и нитки Инструменты Ленты, шнуры Манекены Основа для вышивки Пайетки Langlois-Martin Проволока Фурнитура Цепочки Разное

Список всех товаров


Расширенный поиск
Раздел закачек

Корзина

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


Оцените качество магазина на Яндекс.Маркете.

Лидер продаж

Бушева Наталья
Мой бисерный сад. Часть 3
 Бушева Наталья. Мой бисерный сад. Часть 3
300 руб





mc_vs_accpt_v_133_gif

Каталог товаров

Распродажа до 50% КАБОШОНЫ    Авантюрин    Агаты    Аквамарин    Амазонит    Аметист    Аметрин    Аммониты    Анальцим    Апатит    Астрофиллит    Берилл    Бирюза    Бронзит    Бычий глаз    Варисцит    Гелиотроп    Гематит    Гиперстен    Говлит    Гранат    Дельхайелит    Диопсид    Дьюмортьерит    Жадеит    Жильбертит    Змеевик    Кальцит    Канкринит    Карфолит    Кахолонг    Кварц    Кианит    Коралл    Кошачий глаз    Кошачий глаз (стекло)    Кремень    Кремний    Ксонотлит    Кунцит    Лабрадор    Ларвикит    Лазурит    Ларимар    Лепидолит    Лизардит    Липарит    Лунный камень    Магнезит    Малахит    Мусковит    Натролит    Нефрит    Обсидиан    Опал    Опалит (стекло)    Офит    Парагонит    Пегматит    Переливт    Перламутр    Петалит    Петерсит    Пинолит    Пирит    Порфирит    Пренит    Пьемонтит    Пурпурит    Риолит    Роговик    Родонит    Родохрозит    Родусит    Розалит    Рубин    Сенгилит    Септария    Серафинит    Сердолик    Симбирцит    Симбирцитовые жеоды    Скарн    Слюдит    Содалит    Соколиный глаз    Солнечный камень    Спектролит    Стекло    Стекло дихроическое    Стекло матовое    Стихтит    Сфалерит    Сугилит    Танзанит    Тигровый глаз    Турмалин    Унакит    Флюорит    Фуксит    Хризоколла    Хризопраз    Хромдиопсид    Цитрин    Чароит    Шаттукит    Шунгит    Эвдиалит    Янтарь    Яшма    Lunasoft    В АССОРТИМЕНТЕ    Прочие    Pearl Cabochons(Чехия) Подвески Каменная крошка Окаменелости Kaboshon Box Swarovski Бисер Бусины Жемчуг Журналы и книги Иглы и нитки Инструменты Ленты, шнуры Манекены Основа для вышивки Пайетки Langlois-Martin Проволока Фурнитура Цепочки Разное

Список всех товаров


Расширенный поиск
Раздел закачек

Новости на Email

Новости
Пожалуйста, зарегистрируйтесь на сайте перед тем, как Вы подпишетесь на рассылку.
No account yet? Register
Версия для печати

Кошачий глаз (стекло)

В данной категории представлены цветные стеклянные кабошоны - имитация "кошачьего глаза".

Их получают из синтетического титаната бария и волокнистого боросиликатного стекла.



Сортировать по:
Кошачий глаз (стекло) 20х15 мм черный
Артикул: 101156
25.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: черный.
Размер 20х15 мм.
Цена указана за 1 шт.
В ассортименте.
[Подробнее...]

Кошачий глаз (стекло) 11 мм светло-зеленый
Артикул: 101263
10.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: светло-зеленый (теплый).
Размер 11х3 мм.
Цена указана за 1 шт.
В ассортименте.
[Подробнее...]

Кошачий глаз (стекло) 11 мм горчично-желтый
Артикул: 101270
10.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: горчично-желтый.
Размер 11х3 мм.
Цена указана за 1 шт.
В ассортименте.
[Подробнее...]


Кошачий глаз (стекло) 20 мм желтый
Артикул: 101287
22.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: желтый.
Размер 20х4 мм.
Цена указана за 1 шт.
В ассортименте.
[Подробнее...]

Кошачий глаз (стекло) 20 мм темно-желтый
Артикул: 101288
22.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: темно-желтый.
Размер 20х4 мм.
Цена указана за 1 шт.
В ассортименте.
[Подробнее...]

Кошачий глаз (стекло) 25х18 мм рыжий
Артикул: 101334
38.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: рыжий.
Размер 25х18х5 мм.
Цена указана за 1 шт.
В ассортименте.
[Подробнее...]


Кошачий глаз (стекло) 18х13 мм светло-зеленый
Артикул: 101341
25.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: светло-зеленый.
Размер 18х13х3 мм.
Цена указана за 1 шт.
В ассортименте.
[Подробнее...]

Кошачий глаз (стекло) 18х13мм бледно-абрикосовый
Артикул: 101342
20.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: бледно-абрикосовый.
Размер 18х13 мм.
Цена указана за 1 шт.
В ассортименте: этот кабошон вы можете приобрести в любом количестве.
[Подробнее...]

Кошачий глаз (стекло) 18х13мм бледно-желтый
Артикул: 101343
20.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: бледно-желтый.
Размер 18х13 мм.
Цена указана за 1 шт.
В ассортименте: этот кабошон вы можете приобрести в любом количестве.
[Подробнее...]


Кошачий глаз (стекло) 18х13мм горчичный
Артикул: 101347
20.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: горчичный.
Размер 18х13 мм.
Цена указана за 1 шт.
В ассортименте: этот кабошон вы можете приобрести в любом количестве.
[Подробнее...]

Кошачий глаз (стекло) 18х13мм горчично-желтый
Артикул: 101348
20.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: горчично-желтый.
Размер 18х13 мм.
Цена указана за 1 шт.
В ассортименте: этот кабошон вы можете приобрести в любом количестве.
[Подробнее...]

Кошачий глаз (стекло) 18х13мм коричневый
Артикул: 101352
20.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: коричневый.
Размер 18х13 мм.
Цена указана за 1 шт.
В ассортименте: этот кабошон вы можете приобрести в любом количестве.
[Подробнее...]


Кошачий глаз (стекло) 18х13мм светло-оливковый
Артикул: 101353
20.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: светло-оливковый.
Размер 18х13 мм.
Цена указана за 1 шт.
В ассортименте: этот кабошон вы можете приобрести в любом количестве.
[Подробнее...]

Кошачий глаз (стекло) 18х13мм карамельно-коричневый
Артикул: 101354
20.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: карамельно-коричневый.
Размер 18х13 мм.
Цена указана за 1 шт.
В ассортименте: этот кабошон вы можете приобрести в любом количестве.
[Подробнее...]

Кошачий глаз (стекло) 15х7 мм светло-коричневый
Артикул: 101434
7.00 руб
Кабошон из стеклянного "кошачьего глаза".
Цвет: светло-коричневый.
Размер 15х7х2 мм.
Цена указана за 1 шт.
В ассортименте.
[Подробнее...]



  • «« В начало
  • « Предыдущая
  • 1
  • Следующая »
  • В конец »»


Показать #  
Результаты 1 - 15 из 15
Яндекс.Метрика

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

Application afterLoad: 0.000 seconds, 0.68 MB
Application afterInitialise: 0.017 seconds, 1.60 MB
Application afterRoute: 0.019 seconds, 1.81 MB
Application afterDispatch: 0.266 seconds, 3.74 MB
Application afterRender: 0.545 seconds, 7.95 MB

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

8395256

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

  1. DELETE
      FROM jos_session
      WHERE ( time < '1537942188' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'lue8miebh0geh43u07nhlatv22'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'lue8miebh0geh43u07nhlatv22','1537945788','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. 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
  7. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  8. 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'
  9. 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`);
  10. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  11. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  12. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  13. 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`=69
     
      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'
     
      AND product_in_stock > 0
  14. SELECT category_id, category_name, seo_title
      FROM jos_vm_category
      WHERE category_id='69'
  15. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='69'
  16. 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='69'
      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
  17. 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='69'
      AND jos_vm_category.category_id='69'
  18. 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='11'
      AND jos_vm_category.category_id='11'
  19. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  20. 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`=69
     
      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'
     
      AND product_in_stock > 0
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_sku` ASC
      LIMIT 0, 20
  21. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  22. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54778
  23. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='54778'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  24. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='54778'
  25. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  26. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=54778
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  27. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='54778'
  28. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54778
      AND `file_is_image`=1
      AND `file_published`=1
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=54778
  30. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  31. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54778
      AND `file_is_image`=0
      AND `file_published`=1
  32. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='54778'
  33. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  34. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=54778
  35. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=54778
  36. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='54778'
  37. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54778
  38. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41076
  39. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='41076'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  40. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='41076'
  41. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=41076
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  42. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='41076'
  43. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41076
      AND `file_is_image`=1
      AND `file_published`=1
  44. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=41076
  45. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  46. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41076
      AND `file_is_image`=0
      AND `file_published`=1
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='41076'
  48. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  49. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=41076
  50. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=41076
  51. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='41076'
  52. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41076
  53. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41083
  54. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='41083'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  55. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='41083'
  56. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=41083
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  57. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='41083'
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41083
      AND `file_is_image`=1
      AND `file_published`=1
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=41083
  60. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  61. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41083
      AND `file_is_image`=0
      AND `file_published`=1
  62. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='41083'
  63. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  64. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=41083
  65. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=41083
  66. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='41083'
  67. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41083
  68. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54785
  69. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='54785'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  70. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='54785'
  71. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=54785
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  72. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='54785'
  73. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54785
      AND `file_is_image`=1
      AND `file_published`=1
  74. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=54785
  75. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54785
      AND `file_is_image`=0
      AND `file_published`=1
  77. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='54785'
  78. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  79. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=54785
  80. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=54785
  81. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='54785'
  82. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54785
  83. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54786
  84. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='54786'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  85. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='54786'
  86. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=54786
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  87. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='54786'
  88. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54786
      AND `file_is_image`=1
      AND `file_published`=1
  89. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=54786
  90. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  91. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54786
      AND `file_is_image`=0
      AND `file_published`=1
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='54786'
  93. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  94. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=54786
  95. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=54786
  96. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='54786'
  97. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54786
  98. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41126
  99. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='41126'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  100. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='41126'
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=41126
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  102. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='41126'
  103. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41126
      AND `file_is_image`=1
      AND `file_published`=1
  104. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=41126
  105. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  106. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41126
      AND `file_is_image`=0
      AND `file_published`=1
  107. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='41126'
  108. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  109. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=41126
  110. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=41126
  111. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='41126'
  112. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41126
  113. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54796
  114. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='54796'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='54796'
  116. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=54796
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  117. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='54796'
  118. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54796
      AND `file_is_image`=1
      AND `file_published`=1
  119. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=54796
  120. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  121. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54796
      AND `file_is_image`=0
      AND `file_published`=1
  122. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='54796'
  123. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  124. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=54796
  125. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=54796
  126. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='54796'
  127. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58613
  128. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58613'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58613'
  130. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58613
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  131. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58613'
  132. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58613
      AND `file_is_image`=1
      AND `file_published`=1
  133. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58613
  134. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  135. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58613
      AND `file_is_image`=0
      AND `file_published`=1
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58613'
  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`=58613
  139. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58613
  140. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58613'
  141. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58613
  142. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58614
  143. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58614'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  144. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58614'
  145. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58614
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  146. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58614'
  147. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58614
      AND `file_is_image`=1
      AND `file_published`=1
  148. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58614
  149. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  150. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58614
      AND `file_is_image`=0
      AND `file_published`=1
  151. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58614'
  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`=58614
  154. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58614
  155. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58614'
  156. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58614
  157. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58618
  158. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58618'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  159. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58618'
  160. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58618
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  161. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58618'
  162. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58618
      AND `file_is_image`=1
      AND `file_published`=1
  163. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58618
  164. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  165. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58618
      AND `file_is_image`=0
      AND `file_published`=1
  166. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58618'
  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`=58618
  169. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58618
  170. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58618'
  171. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58618
  172. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58619
  173. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58619'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58619'
  175. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58619
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  176. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58619'
  177. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58619
      AND `file_is_image`=1
      AND `file_published`=1
  178. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58619
  179. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  180. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58619
      AND `file_is_image`=0
      AND `file_published`=1
  181. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58619'
  182. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  183. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=58619
  184. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58619
  185. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58619'
  186. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58619
  187. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58623
  188. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58623'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  189. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58623'
  190. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58623
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  191. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58623'
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58623
      AND `file_is_image`=1
      AND `file_published`=1
  193. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58623
  194. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  195. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58623
      AND `file_is_image`=0
      AND `file_published`=1
  196. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58623'
  197. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  198. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=58623
  199. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58623
  200. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58623'
  201. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58623
  202. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58624
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58624'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58624'
  205. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58624
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  206. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58624'
  207. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58624
      AND `file_is_image`=1
      AND `file_published`=1
  208. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58624
  209. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  210. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58624
      AND `file_is_image`=0
      AND `file_published`=1
  211. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58624'
  212. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  213. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=58624
  214. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58624
  215. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58624'
  216. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58624
  217. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58625
  218. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58625'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58625'
  220. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58625
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  221. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58625'
  222. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58625
      AND `file_is_image`=1
      AND `file_published`=1
  223. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58625
  224. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  225. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58625
      AND `file_is_image`=0
      AND `file_published`=1
  226. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58625'
  227. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  228. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=58625
  229. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58625
  230. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58625'
  231. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58625
  232. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41165
  233. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='41165'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  234. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='41165'
  235. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=41165
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  236. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='41165'
  237. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41165
      AND `file_is_image`=1
      AND `file_published`=1
  238. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=41165
  239. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  240. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41165
      AND `file_is_image`=0
      AND `file_published`=1
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='41165'
  242. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  243. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=41165
  244. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=41165
  245. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='41165'
  246. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41165
  247. 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='69'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'
     
      AND product_in_stock > 0

      ORDER BY RAND()
      LIMIT 0, 10
  248. 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 = 1 OR mm.menuid = 0 )
      ORDER BY position, ordering
  249. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE product_parent_id=''
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y' 
      AND product_in_stock > 0
      ORDER BY product_name DESC
  250. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1003212'
  251. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=124191
  252. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='124191'
  253. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=124191
  254. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='124191'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='124191'
  256. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124191
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  257. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='124191'
  258. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=124191
  259. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=124191
  260. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='181411'
  261. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=99563
  262. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='99563'
  263. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=99563
  264. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='99563'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  265. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='99563'
  266. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=99563
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  267. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='99563'
  268. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=99563
  269. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=99563
  270. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='TR-08-932'
  271. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=30166
  272. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='30166'
  273. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=30166
  274. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='30166'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  275. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='30166'
  276. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=30166
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  277. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='30166'
  278. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=30166
  279. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=30166
  280. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DB0693'
  281. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=122521
  282. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='122521'
  283. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=122521
  284. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='122521'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  285. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='122521'
  286. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=122521
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  287. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='122521'
  288. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=122521
  289. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=122521
  290. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='5328-4-723'
  291. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=44114
  292. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='44114'
  293. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=44114
  294. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='44114'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  295. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='44114'
  296. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=44114
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  297. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='44114'
  298. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=44114
  299. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=44114
  300. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='Pyr-00030-29121'
  301. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=87165
  302. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='87165'
  303. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=87165
  304. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='87165'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='87165'
  306. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=87165
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  307. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='87165'
  308. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=87165
  309. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=87165
  310. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
  311. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  312. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  313. SELECT *
      FROM `jos_acajoom_xonfig`
  314. SELECT *
      FROM `jos_acajoom_lists`
      WHERE `published` = 1
  315. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  316. SELECT g.shopper_group_discount
                   
      FROM jos_vm_shopper_vendor_xref AS x, jos_vm_shopper_group AS g
                   
      WHERE x.shopper_group_id = g.shopper_group_id
                   
      AND x.user_id = '0'
  317. SELECT x.shopper_group_id, g.shopper_group_discount
               
      FROM  jos_vm_shopper_vendor_xref AS x, jos_vm_shopper_group AS g
               
      WHERE x.shopper_group_id = g.shopper_group_id
      AND x.user_id = '0'
  318. SELECT sum(order_subtotal)
      FROM  jos_vm_orders
      WHERE user_id='0'
      AND order_status = 'S'
  319. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  320. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  321. SELECT g.shopper_group_discount
                   
      FROM jos_vm_shopper_vendor_xref AS x, jos_vm_shopper_group AS g
                   
      WHERE x.shopper_group_id = g.shopper_group_id
                   
      AND x.user_id = '0'

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

  1. DELETE
      FROM jos_session
      WHERE ( time < '1537942188' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'lue8miebh0geh43u07nhlatv22'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'lue8miebh0geh43u07nhlatv22','1537945788','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. 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
  7. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  8. 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'
  9. 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`);
  10. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  11. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  12. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  13. 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`=69
     
      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'
     
      AND product_in_stock > 0
  14. SELECT category_id, category_name, seo_title
      FROM jos_vm_category
      WHERE category_id='69'
  15. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='69'
  16. 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='69'
      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
  17. 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='69'
      AND jos_vm_category.category_id='69'
  18. 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='11'
      AND jos_vm_category.category_id='11'
  19. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  20. 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`=69
     
      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'
     
      AND product_in_stock > 0
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_sku` ASC
      LIMIT 0, 20
  21. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  22. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54778
  23. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='54778'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  24. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='54778'
  25. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  26. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=54778
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  27. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='54778'
  28. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54778
      AND `file_is_image`=1
      AND `file_published`=1
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=54778
  30. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  31. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54778
      AND `file_is_image`=0
      AND `file_published`=1
  32. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='54778'
  33. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  34. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=54778
  35. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=54778
  36. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='54778'
  37. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54778
  38. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41076
  39. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='41076'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  40. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='41076'
  41. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=41076
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  42. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='41076'
  43. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41076
      AND `file_is_image`=1
      AND `file_published`=1
  44. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=41076
  45. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  46. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41076
      AND `file_is_image`=0
      AND `file_published`=1
  47. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='41076'
  48. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  49. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=41076
  50. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=41076
  51. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='41076'
  52. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41076
  53. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41083
  54. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='41083'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  55. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='41083'
  56. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=41083
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  57. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='41083'
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41083
      AND `file_is_image`=1
      AND `file_published`=1
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=41083
  60. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  61. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41083
      AND `file_is_image`=0
      AND `file_published`=1
  62. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='41083'
  63. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  64. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=41083
  65. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=41083
  66. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='41083'
  67. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41083
  68. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54785
  69. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='54785'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  70. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='54785'
  71. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=54785
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  72. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='54785'
  73. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54785
      AND `file_is_image`=1
      AND `file_published`=1
  74. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=54785
  75. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  76. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54785
      AND `file_is_image`=0
      AND `file_published`=1
  77. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='54785'
  78. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  79. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=54785
  80. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=54785
  81. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='54785'
  82. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54785
  83. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54786
  84. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='54786'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  85. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='54786'
  86. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=54786
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  87. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='54786'
  88. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54786
      AND `file_is_image`=1
      AND `file_published`=1
  89. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=54786
  90. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  91. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54786
      AND `file_is_image`=0
      AND `file_published`=1
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='54786'
  93. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  94. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=54786
  95. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=54786
  96. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='54786'
  97. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54786
  98. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41126
  99. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='41126'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  100. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='41126'
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=41126
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  102. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='41126'
  103. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41126
      AND `file_is_image`=1
      AND `file_published`=1
  104. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=41126
  105. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  106. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41126
      AND `file_is_image`=0
      AND `file_published`=1
  107. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='41126'
  108. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  109. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=41126
  110. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=41126
  111. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='41126'
  112. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41126
  113. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=54796
  114. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='54796'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='54796'
  116. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=54796
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  117. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='54796'
  118. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54796
      AND `file_is_image`=1
      AND `file_published`=1
  119. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=54796
  120. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  121. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=54796
      AND `file_is_image`=0
      AND `file_published`=1
  122. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='54796'
  123. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  124. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=54796
  125. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=54796
  126. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='54796'
  127. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58613
  128. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58613'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58613'
  130. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58613
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  131. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58613'
  132. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58613
      AND `file_is_image`=1
      AND `file_published`=1
  133. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58613
  134. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  135. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58613
      AND `file_is_image`=0
      AND `file_published`=1
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58613'
  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`=58613
  139. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58613
  140. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58613'
  141. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58613
  142. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58614
  143. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58614'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  144. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58614'
  145. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58614
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  146. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58614'
  147. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58614
      AND `file_is_image`=1
      AND `file_published`=1
  148. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58614
  149. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  150. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58614
      AND `file_is_image`=0
      AND `file_published`=1
  151. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58614'
  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`=58614
  154. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58614
  155. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58614'
  156. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58614
  157. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58618
  158. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58618'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  159. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58618'
  160. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58618
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  161. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58618'
  162. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58618
      AND `file_is_image`=1
      AND `file_published`=1
  163. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58618
  164. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  165. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58618
      AND `file_is_image`=0
      AND `file_published`=1
  166. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58618'
  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`=58618
  169. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58618
  170. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58618'
  171. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58618
  172. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58619
  173. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58619'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58619'
  175. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58619
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  176. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58619'
  177. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58619
      AND `file_is_image`=1
      AND `file_published`=1
  178. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58619
  179. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  180. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58619
      AND `file_is_image`=0
      AND `file_published`=1
  181. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58619'
  182. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  183. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=58619
  184. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58619
  185. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58619'
  186. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58619
  187. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58623
  188. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58623'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  189. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58623'
  190. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58623
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  191. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58623'
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58623
      AND `file_is_image`=1
      AND `file_published`=1
  193. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58623
  194. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  195. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58623
      AND `file_is_image`=0
      AND `file_published`=1
  196. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58623'
  197. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  198. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=58623
  199. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58623
  200. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58623'
  201. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58623
  202. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58624
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58624'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58624'
  205. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58624
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  206. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58624'
  207. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58624
      AND `file_is_image`=1
      AND `file_published`=1
  208. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58624
  209. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  210. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58624
      AND `file_is_image`=0
      AND `file_published`=1
  211. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58624'
  212. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  213. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=58624
  214. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58624
  215. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58624'
  216. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58624
  217. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58625
  218. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='58625'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='58625'
  220. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=58625
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  221. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='58625'
  222. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58625
      AND `file_is_image`=1
      AND `file_published`=1
  223. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=58625
  224. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  225. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=58625
      AND `file_is_image`=0
      AND `file_published`=1
  226. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='58625'
  227. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  228. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=58625
  229. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=58625
  230. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='58625'
  231. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=58625
  232. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41165
  233. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='41165'
      AND (start_date<='1537945788' OR start_date=0)
      AND (end_date>='1537945788' OR end_date=0)
      AND product_discount_id=discount_id
  234. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='41165'
  235. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=41165
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  236. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='41165'
  237. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41165
      AND `file_is_image`=1
      AND `file_published`=1
  238. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=41165
  239. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  240. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=41165
      AND `file_is_image`=0
      AND `file_published`=1
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='41165'
  242. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  243. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=41165
  244. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=41165
  245. SELECT *
      FROM `jos_vm_jwishlist`
      WHERE user_id='0'
      AND  product_id='41165'
  246. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=41165
  247. 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='69'

      AND jos_vm_product.product_publish='Y'

      AND jos_vm_product.product_special='Y'
     
      AND product_in_stock > 0

      ORDER BY RAND()
      LIMIT 0, 10
  248. 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 = 1 OR mm.menuid = 0 )
      ORDER BY position, ordering
  249. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE product_parent_id=''
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y' 
      AND product_in_stock > 0
      ORDER BY product_name DESC
  250. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1003212'
  251. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=124191
  252. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='124191'
  253. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=124191
  254. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='124191'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='124191'
  256. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=124191
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  257. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='124191'
  258. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=124191
  259. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=124191
  260. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='181411'
  261. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=99563
  262. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='99563'
  263. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=99563
  264. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='99563'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  265. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='99563'
  266. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=99563
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  267. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='99563'
  268. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=99563
  269. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=99563
  270. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='TR-08-932'
  271. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=30166
  272. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='30166'
  273. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=30166
  274. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='30166'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  275. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='30166'
  276. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=30166
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  277. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='30166'
  278. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=30166
  279. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=30166
  280. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DB0693'
  281. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=122521
  282. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='122521'
  283. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=122521
  284. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='122521'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  285. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='122521'
  286. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=122521
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  287. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='122521'
  288. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=122521
  289. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=122521
  290. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='5328-4-723'
  291. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=44114
  292. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='44114'
  293. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=44114
  294. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='44114'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  295. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='44114'
  296. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=44114
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  297. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='44114'
  298. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=44114
  299. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=44114
  300. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='Pyr-00030-29121'
  301. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=87165
  302. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='87165'
  303. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=87165
  304. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='87165'
      AND (start_date<='1537945789' OR start_date=0)
      AND (end_date>='1537945789' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='87165'
  306. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=87165
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  307. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='87165'
  308. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=87165
  309. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=87165
  310. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
  311. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  312. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  313. SELECT *
      FROM `jos_acajoom_xonfig`
  314. SELECT *
      FROM `jos_acajoom_lists`
      WHERE `published` = 1
  315. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  316. SELECT g.shopper_group_discount
                   
      FROM jos_vm_shopper_vendor_xref AS x, jos_vm_shopper_group AS g
                   
      WHERE x.shopper_group_id = g.shopper_group_id
                   
      AND x.user_id = '0'
  317. SELECT x.shopper_group_id, g.shopper_group_discount
               
      FROM  jos_vm_shopper_vendor_xref AS x, jos_vm_shopper_group AS g
               
      WHERE x.shopper_group_id = g.shopper_group_id
      AND x.user_id = '0'
  318. SELECT sum(order_subtotal)
      FROM  jos_vm_orders
      WHERE user_id='0'
      AND order_status = 'S'
  319. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  320. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  321. SELECT g.shopper_group_discount
                   
      FROM jos_vm_shopper_vendor_xref AS x, jos_vm_shopper_group AS g
                   
      WHERE x.shopper_group_id = g.shopper_group_id
                   
      AND x.user_id = '0'

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

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

Нет

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

Нет