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

motoring2013@gmail.com

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

Каталог

766.20 грн
736.20 грн
Вы экономите: 30.00 грн


Корзина

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

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




Новости

Новые мотоциклы SPIKE ZZ 250cc (Zongshen ZS250GS),

нове скутера MITSUKO TUNING (Viper Shtorm NEW), SMART WIND (VIPER WIND), Power Super (Viper TORNADO),

новые мопеды Viper Aktiv, Alhfa, Delta, Sabur.

Техника с заводов, с документами.

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

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.020 seconds, 3.87 MB
Application afterRoute: 0.028 seconds, 5.47 MB
Application afterDispatch: 0.063 seconds, 9.43 MB
Application afterRender: 0.535 seconds, 18.31 MB

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

19311464

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'oh5475et2aaverb3esenvp43c1'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1790025106' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'oh5475et2aaverb3esenvp43c1'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'oh5475et2aaverb3esenvp43c1','1790027206','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 55)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-21 21:46:46' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-21 21:46:46' )
      ORDER BY cc.ordering,  a.created DESC
      LIMIT 0, 12
  10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-21 21:46:46' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-21 21:46:46' )
      ORDER BY cc.ordering,  a.created DESC
  11. 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 = 55 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  12. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  13. 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'
  14. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  15. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  16. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  17. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  18. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft
  19. 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`);
  20. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  21. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  22. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  23. SELECT m.manufacturer_id,m.mf_name
      FROM jos_vm_manufacturer m
      ORDER BY m.mf_name ASC
  24. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      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_product.product_publish='Y'
      ORDER BY jos_vm_product.product_id DESC
      LIMIT 0, 5
  25. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD25'
  26. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9836
  27. 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`='9836'
  28. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9836
  29. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9836'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  30. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9836
  31. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  32. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9836'
  33. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  34. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9836
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  35. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9836
  36. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  37. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9836'
  38. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9836
  39. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9836
  40. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD27'
  41. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9835
  42. 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`='9835'
  43. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9835
  44. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9835'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  45. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9835
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9835'
  48. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9835
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  49. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9835
  50. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9835'
  51. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9835
  52. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9835
  53. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD43'
  54. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9834
  55. 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`='9834'
  56. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9834
  57. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9834'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  58. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9834
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9834'
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9834
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9834
  63. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9834'
  64. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9834
  65. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9834
  66. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD42'
  67. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9833
  68. 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`='9833'
  69. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9833
  70. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9833'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9833
  72. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  73. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9833'
  74. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9833
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  75. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9833
  76. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9833'
  77. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9833
  78. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9833
  79. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD41'
  80. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9832
  81. 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`='9832'
  82. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9832
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9832'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9832
  85. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  86. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9832'
  87. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9832
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  88. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9832
  89. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9832'
  90. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9832
  91. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9832
  92. SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-21 18:46:46' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-21 18:46:46' )
      AND s.id > 0
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (s.id=5)
      AND f.content_id IS NULL  
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 8
  93. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'  
      ORDER BY RAND()
      LIMIT 0, 25
  94. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='LF1913'
  95. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9392
  96. 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`='9392'
  97. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9392
  98. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9392'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9392
  100. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9392'
  102. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9392
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  103. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9392
  104. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9392'
  105. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9392
  106. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9392
  107. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1016'
  108. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=365
  109. 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`='365'
  110. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=365
  111. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='365'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  112. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='365'
  113. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=365
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  114. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=365
  115. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='365'
  116. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=365
  117. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=365
  118. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2493'
  119. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1338
  120. 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`='1338'
  121. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1338
  122. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1338'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  123. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1338
  124. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  125. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1338'
  126. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1338
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  127. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1338
  128. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1338'
  129. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1338
  130. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1338
  131. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='5228'
  132. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2135
  133. 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`='2135'
  134. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2135
  135. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2135'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2135
  137. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  138. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2135'
  139. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2135
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  140. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2135
  141. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2135'
  142. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2135
  143. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2135
  144. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2201F2'
  145. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7989
  146. 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`='7989'
  147. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7989
  148. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7989'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7989
  150. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7989'
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7989
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7989
  154. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7989'
  155. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7989
  156. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7989
  157. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1580'
  158. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=856
  159. 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`='856'
  160. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=856
  161. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='856'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  162. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=856
  163. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='856'
  165. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=856
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  166. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=856
  167. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='856'
  168. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=856
  169. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=856
  170. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='90423'
  171. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7699
  172. 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`='7699'
  173. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7699
  174. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7699'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  175. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7699
  176. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  177. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7699'
  178. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7699
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  179. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7699
  180. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7699'
  181. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7699
  182. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7699
  183. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VCS014'
  184. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2886
  185. 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`='2886'
  186. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2886
  187. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2886'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  188. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2886
  189. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  190. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2886'
  191. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2886
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  192. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2886
  193. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2886'
  194. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2886
  195. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2886
  196. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='933d'
  197. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5009
  198. 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`='5009'
  199. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5009
  200. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5009'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  201. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5009
  202. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  203. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5009'
  204. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5009
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  205. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5009
  206. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5009'
  207. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5009
  208. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5009
  209. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='17328'
  210. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7570
  211. 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`='7570'
  212. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7570
  213. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7570'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  214. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7570
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7570'
  217. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7570
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  218. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7570
  219. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7570'
  220. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7570
  221. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7570
  222. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='29052060'
  223. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5909
  224. 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`='5909'
  225. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5909
  226. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5909'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  227. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5909
  228. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  229. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5909'
  230. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5909
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5909
  232. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5909'
  233. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5909
  234. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5909
  235. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7009'
  236. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3178
  237. 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`='3178'
  238. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3178
  239. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3178'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  240. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3178
  241. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3178'
  243. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3178
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  244. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3178
  245. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3178'
  246. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3178
  247. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3178
  248. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='OS1137'
  249. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9359
  250. 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`='9359'
  251. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9359
  252. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9359'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  253. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9359
  254. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9359'
  256. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9359
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  257. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9359
  258. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9359'
  259. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9359
  260. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9359
  261. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1504'
  262. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=785
  263. 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`='785'
  264. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=785
  265. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='785'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  266. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=785
  267. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='785'
  269. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=785
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=785
  271. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='785'
  272. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=785
  273. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=785
  274. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='M114'
  275. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8808
  276. 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`='8808'
  277. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8808
  278. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8808'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  279. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8808
  280. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  281. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8808'
  282. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8808
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  283. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8808
  284. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8808'
  285. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8808
  286. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8808
  287. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2251V200R'
  288. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8279
  289. 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`='8279'
  290. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8279
  291. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8279'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  292. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8279
  293. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  294. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8279'
  295. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8279
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  296. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8279
  297. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8279'
  298. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8279
  299. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8279
  300. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1886'
  301. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=934
  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`='934'
  303. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=934
  304. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='934'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=934
  306. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  307. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='934'
  308. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=934
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  309. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=934
  310. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='934'
  311. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=934
  312. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=934
  313. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2989'
  314. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3037
  315. 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`='3037'
  316. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3037
  317. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3037'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  318. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3037
  319. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3037'
  321. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3037
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  322. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3037
  323. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3037'
  324. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3037
  325. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3037
  326. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='99702'
  327. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7708
  328. 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`='7708'
  329. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7708
  330. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7708'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  331. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7708
  332. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  333. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7708'
  334. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7708
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  335. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7708
  336. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7708'
  337. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7708
  338. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7708
  339. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='790a'
  340. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3766
  341. 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`='3766'
  342. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3766
  343. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3766'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  344. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3766
  345. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  346. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3766'
  347. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3766
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  348. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3766
  349. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3766'
  350. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3766
  351. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3766
  352. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='18042120'
  353. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5773
  354. 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`='5773'
  355. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5773
  356. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5773'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  357. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5773
  358. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  359. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5773'
  360. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5773
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  361. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5773
  362. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5773'
  363. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5773
  364. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5773
  365. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DAV100'
  366. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7033
  367. 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`='7033'
  368. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7033
  369. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7033'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  370. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7033
  371. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  372. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7033'
  373. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7033
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  374. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7033
  375. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7033'
  376. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7033
  377. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7033
  378. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='303d'
  379. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5279
  380. 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`='5279'
  381. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5279
  382. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5279'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  383. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5279
  384. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  385. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5279'
  386. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5279
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  387. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5279
  388. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5279'
  389. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5279
  390. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5279
  391. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='70220322'
  392. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5586
  393. 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`='5586'
  394. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5586
  395. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5586'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  396. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5586
  397. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  398. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5586'
  399. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5586
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  400. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5586
  401. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5586'
  402. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5586
  403. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5586
  404. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DISK922'
  405. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9781
  406. 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`='9781'
  407. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9781
  408. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9781'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  409. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9781
  410. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  411. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9781'
  412. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9781
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  413. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9781
  414. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9781'
  415. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9781
  416. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9781

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'oh5475et2aaverb3esenvp43c1'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1790025106' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'oh5475et2aaverb3esenvp43c1'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'oh5475et2aaverb3esenvp43c1','1790027206','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 55)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-21 21:46:46' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-21 21:46:46' )
      ORDER BY cc.ordering,  a.created DESC
      LIMIT 0, 12
  10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-21 21:46:46' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-21 21:46:46' )
      ORDER BY cc.ordering,  a.created DESC
  11. 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 = 55 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  12. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  13. 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'
  14. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  15. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  16. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  17. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  18. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft
  19. 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`);
  20. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  21. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  22. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  23. SELECT m.manufacturer_id,m.mf_name
      FROM jos_vm_manufacturer m
      ORDER BY m.mf_name ASC
  24. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      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_product.product_publish='Y'
      ORDER BY jos_vm_product.product_id DESC
      LIMIT 0, 5
  25. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD25'
  26. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9836
  27. 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`='9836'
  28. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9836
  29. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9836'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  30. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9836
  31. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  32. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9836'
  33. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  34. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9836
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  35. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9836
  36. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  37. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9836'
  38. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9836
  39. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9836
  40. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD27'
  41. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9835
  42. 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`='9835'
  43. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9835
  44. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9835'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  45. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9835
  46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  47. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9835'
  48. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9835
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  49. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9835
  50. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9835'
  51. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9835
  52. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9835
  53. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD43'
  54. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9834
  55. 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`='9834'
  56. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9834
  57. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9834'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  58. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9834
  59. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9834'
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9834
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9834
  63. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9834'
  64. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9834
  65. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9834
  66. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD42'
  67. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9833
  68. 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`='9833'
  69. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9833
  70. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9833'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9833
  72. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  73. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9833'
  74. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9833
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  75. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9833
  76. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9833'
  77. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9833
  78. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9833
  79. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD41'
  80. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9832
  81. 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`='9832'
  82. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9832
  83. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9832'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  84. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9832
  85. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027206' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  86. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9832'
  87. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9832
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  88. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9832
  89. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9832'
  90. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9832
  91. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9832
  92. SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-21 18:46:46' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-21 18:46:46' )
      AND s.id > 0
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (s.id=5)
      AND f.content_id IS NULL  
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 8
  93. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'  
      ORDER BY RAND()
      LIMIT 0, 25
  94. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='LF1913'
  95. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9392
  96. 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`='9392'
  97. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9392
  98. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9392'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9392
  100. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9392'
  102. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9392
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  103. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9392
  104. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9392'
  105. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9392
  106. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9392
  107. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1016'
  108. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=365
  109. 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`='365'
  110. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=365
  111. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='365'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  112. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='365'
  113. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=365
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  114. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=365
  115. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='365'
  116. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=365
  117. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=365
  118. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2493'
  119. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1338
  120. 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`='1338'
  121. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1338
  122. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1338'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  123. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1338
  124. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  125. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1338'
  126. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1338
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  127. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1338
  128. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1338'
  129. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1338
  130. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1338
  131. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='5228'
  132. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2135
  133. 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`='2135'
  134. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2135
  135. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2135'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2135
  137. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  138. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2135'
  139. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2135
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  140. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2135
  141. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2135'
  142. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2135
  143. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2135
  144. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2201F2'
  145. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7989
  146. 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`='7989'
  147. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7989
  148. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7989'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7989
  150. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7989'
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7989
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7989
  154. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7989'
  155. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7989
  156. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7989
  157. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1580'
  158. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=856
  159. 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`='856'
  160. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=856
  161. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='856'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  162. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=856
  163. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='856'
  165. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=856
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  166. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=856
  167. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='856'
  168. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=856
  169. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=856
  170. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='90423'
  171. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7699
  172. 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`='7699'
  173. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7699
  174. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7699'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  175. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7699
  176. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  177. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7699'
  178. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7699
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  179. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7699
  180. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7699'
  181. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7699
  182. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7699
  183. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VCS014'
  184. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2886
  185. 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`='2886'
  186. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2886
  187. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2886'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  188. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2886
  189. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  190. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2886'
  191. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2886
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  192. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2886
  193. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2886'
  194. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2886
  195. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2886
  196. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='933d'
  197. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5009
  198. 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`='5009'
  199. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5009
  200. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5009'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  201. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5009
  202. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  203. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5009'
  204. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5009
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  205. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5009
  206. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5009'
  207. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5009
  208. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5009
  209. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='17328'
  210. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7570
  211. 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`='7570'
  212. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7570
  213. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7570'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  214. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7570
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7570'
  217. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7570
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  218. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7570
  219. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7570'
  220. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7570
  221. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7570
  222. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='29052060'
  223. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5909
  224. 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`='5909'
  225. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5909
  226. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5909'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  227. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5909
  228. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  229. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5909'
  230. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5909
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5909
  232. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5909'
  233. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5909
  234. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5909
  235. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='7009'
  236. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3178
  237. 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`='3178'
  238. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3178
  239. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3178'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  240. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3178
  241. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3178'
  243. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3178
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  244. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3178
  245. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3178'
  246. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3178
  247. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3178
  248. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='OS1137'
  249. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9359
  250. 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`='9359'
  251. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9359
  252. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9359'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  253. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9359
  254. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9359'
  256. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9359
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  257. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9359
  258. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9359'
  259. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9359
  260. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9359
  261. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1504'
  262. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=785
  263. 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`='785'
  264. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=785
  265. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='785'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  266. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=785
  267. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='785'
  269. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=785
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=785
  271. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='785'
  272. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=785
  273. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=785
  274. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='M114'
  275. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8808
  276. 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`='8808'
  277. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8808
  278. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8808'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  279. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8808
  280. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  281. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8808'
  282. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8808
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  283. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8808
  284. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8808'
  285. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8808
  286. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8808
  287. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2251V200R'
  288. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8279
  289. 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`='8279'
  290. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8279
  291. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8279'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  292. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8279
  293. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  294. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8279'
  295. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8279
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  296. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8279
  297. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8279'
  298. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8279
  299. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8279
  300. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1886'
  301. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=934
  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`='934'
  303. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=934
  304. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='934'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  305. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=934
  306. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  307. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='934'
  308. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=934
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  309. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=934
  310. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='934'
  311. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=934
  312. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=934
  313. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2989'
  314. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3037
  315. 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`='3037'
  316. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3037
  317. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3037'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  318. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3037
  319. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3037'
  321. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3037
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  322. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3037
  323. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3037'
  324. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3037
  325. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3037
  326. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='99702'
  327. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7708
  328. 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`='7708'
  329. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7708
  330. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7708'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  331. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7708
  332. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  333. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7708'
  334. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7708
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  335. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7708
  336. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7708'
  337. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7708
  338. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7708
  339. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='790a'
  340. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3766
  341. 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`='3766'
  342. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3766
  343. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3766'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  344. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3766
  345. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  346. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3766'
  347. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3766
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  348. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3766
  349. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3766'
  350. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3766
  351. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3766
  352. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='18042120'
  353. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5773
  354. 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`='5773'
  355. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5773
  356. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5773'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  357. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5773
  358. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  359. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5773'
  360. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5773
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  361. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5773
  362. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5773'
  363. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5773
  364. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5773
  365. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DAV100'
  366. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7033
  367. 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`='7033'
  368. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7033
  369. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7033'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  370. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7033
  371. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  372. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7033'
  373. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7033
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  374. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7033
  375. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7033'
  376. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7033
  377. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7033
  378. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='303d'
  379. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5279
  380. 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`='5279'
  381. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5279
  382. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5279'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  383. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5279
  384. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  385. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5279'
  386. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5279
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  387. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5279
  388. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5279'
  389. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5279
  390. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5279
  391. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='70220322'
  392. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5586
  393. 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`='5586'
  394. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5586
  395. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5586'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  396. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5586
  397. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  398. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5586'
  399. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5586
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  400. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5586
  401. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5586'
  402. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5586
  403. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5586
  404. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DISK922'
  405. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9781
  406. 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`='9781'
  407. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9781
  408. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9781'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  409. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9781
  410. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1790027207' OR start_date=0)
      AND (end_date>='1789947360' OR end_date=0)
      AND product_discount_id=discount_id
  411. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9781'
  412. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9781
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  413. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9781
  414. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9781'
  415. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9781
  416. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9781

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

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

Нет

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

Нет