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

motoring2013@gmail.com

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

Каталог

Корзина

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

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




Новости

Новые мотоциклы 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.017 seconds, 3.87 MB
Application afterRoute: 0.024 seconds, 5.48 MB
Application afterDispatch: 0.052 seconds, 9.47 MB
Application afterRender: 0.394 seconds, 18.34 MB

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

19345728

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'b6q0sv7ib6gcop5s8gnsa7eu14'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1770160106' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'b6q0sv7ib6gcop5s8gnsa7eu14'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'b6q0sv7ib6gcop5s8gnsa7eu14','1770162206','','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-02-03 23:43:27' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-03 23:43:27' )
      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-02-03 23:43:27' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-03 23:43:27' )
      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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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-02-03 21:43:27' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-03 21:43:27' )
      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='DISK97'
  95. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9714
  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`='9714'
  97. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9714
  98. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9714'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9714
  100. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9714'
  102. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9714
      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=9714
  104. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9714'
  105. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9714
  106. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9714
  107. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2397'
  108. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1224
  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`='1224'
  110. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1224
  111. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1224'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  112. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1224
  113. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  114. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1224'
  115. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1224
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  116. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1224
  117. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1224'
  118. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1224
  119. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1224
  120. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='3547'
  121. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1672
  122. 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`='1672'
  123. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1672
  124. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1672'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  125. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1672
  126. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  127. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1672'
  128. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1672
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  129. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1672
  130. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1672'
  131. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1672
  132. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1672
  133. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='JL150730'
  134. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8906
  135. 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`='8906'
  136. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8906
  137. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8906'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  138. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8906
  139. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  140. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8906'
  141. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8906
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  142. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8906
  143. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8906'
  144. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8906
  145. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8906
  146. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VN0009'
  147. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7090
  148. 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`='7090'
  149. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7090
  150. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7090'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7090
  152. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  153. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7090'
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7090
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  155. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7090
  156. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7090'
  157. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7090
  158. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7090
  159. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='3574'
  160. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1698
  161. 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`='1698'
  162. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1698
  163. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1698'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1698
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1698'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1698
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1698
  169. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1698'
  170. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1698
  171. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1698
  172. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='908a'
  173. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3885
  174. 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`='3885'
  175. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3885
  176. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3885'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  177. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3885
  178. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  179. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3885'
  180. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3885
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  181. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3885
  182. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3885'
  183. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3885
  184. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3885
  185. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='17191207'
  186. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6135
  187. 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`='6135'
  188. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6135
  189. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6135'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  190. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6135
  191. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  192. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6135'
  193. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6135
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  194. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6135
  195. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6135'
  196. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6135
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6135
  198. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='FJ012'
  199. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8606
  200. 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`='8606'
  201. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8606
  202. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8606'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  203. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8606
  204. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  205. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8606'
  206. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8606
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  207. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8606
  208. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8606'
  209. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8606
  210. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8606
  211. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1454a'
  212. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4431
  213. 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`='4431'
  214. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4431
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4431'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4431
  217. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  218. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4431'
  219. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4431
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  220. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4431
  221. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4431'
  222. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4431
  223. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4431
  224. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='V150114'
  225. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6566
  226. 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`='6566'
  227. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6566
  228. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6566'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  229. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6566
  230. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  231. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6566'
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6566
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6566
  234. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6566'
  235. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6566
  236. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6566
  237. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='4021'
  238. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3345
  239. 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`='3345'
  240. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3345
  241. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3345'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3345
  243. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3345'
  245. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3345
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  246. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3345
  247. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3345'
  248. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3345
  249. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3345
  250. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='827a'
  251. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3803
  252. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='3803'
  253. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3803
  254. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3803'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3803
  256. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  257. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3803'
  258. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3803
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  259. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3803
  260. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3803'
  261. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3803
  262. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3803
  263. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='368d'
  264. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5344
  265. 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`='5344'
  266. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5344
  267. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5344'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5344
  269. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  270. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5344'
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5344
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5344
  273. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5344'
  274. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5344
  275. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5344
  276. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DAV081'
  277. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7014
  278. 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`='7014'
  279. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7014
  280. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7014'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  281. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7014
  282. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  283. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7014'
  284. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7014
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  285. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7014
  286. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7014'
  287. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7014
  288. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7014
  289. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DAV00001'
  290. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6937
  291. 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`='6937'
  292. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6937
  293. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6937'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  294. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6937
  295. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  296. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6937'
  297. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6937
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  298. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6937
  299. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6937'
  300. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6937
  301. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6937
  302. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111V150A'
  303. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8099
  304. 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`='8099'
  305. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8099
  306. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8099'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  307. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8099
  308. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  309. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8099'
  310. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  311. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8099
  312. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8099'
  313. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8099
  314. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8099
  315. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VM2523'
  316. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8593
  317. 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`='8593'
  318. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8593
  319. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8593'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8593
  321. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  322. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8593'
  323. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8593
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  324. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8593
  325. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8593'
  326. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8593
  327. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8593
  328. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='LN284'
  329. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9169
  330. 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`='9169'
  331. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9169
  332. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9169'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  333. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9169
  334. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  335. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9169'
  336. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9169
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  337. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9169
  338. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9169'
  339. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9169
  340. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9169
  341. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='344d'
  342. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5320
  343. 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`='5320'
  344. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5320
  345. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5320'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  346. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5320
  347. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  348. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5320'
  349. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  350. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5320
  351. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5320'
  352. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5320
  353. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5320
  354. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2264'
  355. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1110
  356. 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`='1110'
  357. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1110
  358. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1110'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  359. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1110
  360. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  361. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1110'
  362. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1110
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  363. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1110
  364. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1110'
  365. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1110
  366. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1110
  367. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1432a'
  368. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4409
  369. 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`='4409'
  370. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4409
  371. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4409'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  372. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4409
  373. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  374. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4409'
  375. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4409
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  376. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4409
  377. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4409'
  378. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4409
  379. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4409
  380. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1453a'
  381. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4430
  382. 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`='4430'
  383. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4430
  384. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4430'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  385. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4430
  386. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  387. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4430'
  388. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4430
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  389. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4430
  390. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4430'
  391. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4430
  392. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4430
  393. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1120a'
  394. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4097
  395. 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`='4097'
  396. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4097
  397. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4097'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  398. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4097
  399. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  400. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4097'
  401. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4097
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  402. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4097
  403. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4097'
  404. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4097
  405. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4097
  406. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1688a'
  407. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4665
  408. 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`='4665'
  409. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4665
  410. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4665'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  411. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4665
  412. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  413. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4665'
  414. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4665
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  415. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4665
  416. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4665'
  417. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4665
  418. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4665

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'b6q0sv7ib6gcop5s8gnsa7eu14'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1770160106' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'b6q0sv7ib6gcop5s8gnsa7eu14'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'b6q0sv7ib6gcop5s8gnsa7eu14','1770162206','','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-02-03 23:43:27' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-03 23:43:27' )
      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-02-03 23:43:27' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-03 23:43:27' )
      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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' 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-02-03 21:43:27' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-03 21:43:27' )
      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='DISK97'
  95. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9714
  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`='9714'
  97. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9714
  98. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9714'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9714
  100. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9714'
  102. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9714
      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=9714
  104. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9714'
  105. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9714
  106. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9714
  107. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2397'
  108. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1224
  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`='1224'
  110. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1224
  111. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1224'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  112. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1224
  113. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  114. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1224'
  115. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1224
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  116. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1224
  117. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1224'
  118. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1224
  119. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1224
  120. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='3547'
  121. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1672
  122. 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`='1672'
  123. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1672
  124. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1672'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  125. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1672
  126. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  127. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1672'
  128. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1672
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  129. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1672
  130. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1672'
  131. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1672
  132. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1672
  133. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='JL150730'
  134. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8906
  135. 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`='8906'
  136. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8906
  137. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8906'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  138. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8906
  139. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  140. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8906'
  141. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8906
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  142. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8906
  143. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8906'
  144. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8906
  145. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8906
  146. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VN0009'
  147. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7090
  148. 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`='7090'
  149. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7090
  150. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7090'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  151. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7090
  152. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  153. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7090'
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7090
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  155. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7090
  156. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7090'
  157. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7090
  158. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7090
  159. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='3574'
  160. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1698
  161. 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`='1698'
  162. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1698
  163. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1698'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1698
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1698'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1698
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1698
  169. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1698'
  170. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1698
  171. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1698
  172. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='908a'
  173. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3885
  174. 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`='3885'
  175. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3885
  176. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3885'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  177. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3885
  178. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  179. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3885'
  180. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3885
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  181. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3885
  182. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3885'
  183. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3885
  184. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3885
  185. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='17191207'
  186. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6135
  187. 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`='6135'
  188. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6135
  189. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6135'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  190. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6135
  191. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  192. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6135'
  193. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6135
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  194. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6135
  195. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6135'
  196. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6135
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6135
  198. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='FJ012'
  199. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8606
  200. 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`='8606'
  201. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8606
  202. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8606'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  203. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8606
  204. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  205. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8606'
  206. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8606
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  207. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8606
  208. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8606'
  209. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8606
  210. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8606
  211. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1454a'
  212. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4431
  213. 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`='4431'
  214. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4431
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4431'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4431
  217. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  218. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4431'
  219. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4431
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  220. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4431
  221. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4431'
  222. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4431
  223. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4431
  224. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='V150114'
  225. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6566
  226. 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`='6566'
  227. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6566
  228. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6566'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  229. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6566
  230. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  231. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6566'
  232. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6566
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  233. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6566
  234. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6566'
  235. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6566
  236. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6566
  237. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='4021'
  238. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3345
  239. 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`='3345'
  240. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3345
  241. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3345'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3345
  243. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3345'
  245. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3345
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  246. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3345
  247. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3345'
  248. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3345
  249. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3345
  250. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='827a'
  251. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3803
  252. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='3803'
  253. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3803
  254. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3803'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  255. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3803
  256. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  257. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3803'
  258. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3803
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  259. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3803
  260. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3803'
  261. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3803
  262. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3803
  263. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='368d'
  264. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5344
  265. 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`='5344'
  266. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5344
  267. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5344'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5344
  269. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  270. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5344'
  271. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5344
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  272. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5344
  273. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5344'
  274. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5344
  275. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5344
  276. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DAV081'
  277. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7014
  278. 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`='7014'
  279. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7014
  280. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7014'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  281. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7014
  282. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  283. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7014'
  284. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7014
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  285. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7014
  286. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7014'
  287. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7014
  288. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7014
  289. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DAV00001'
  290. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6937
  291. 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`='6937'
  292. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6937
  293. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6937'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  294. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6937
  295. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  296. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6937'
  297. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6937
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  298. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6937
  299. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6937'
  300. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6937
  301. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6937
  302. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='111V150A'
  303. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8099
  304. 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`='8099'
  305. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8099
  306. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8099'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  307. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8099
  308. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  309. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8099'
  310. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8099
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  311. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8099
  312. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8099'
  313. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8099
  314. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8099
  315. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VM2523'
  316. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8593
  317. 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`='8593'
  318. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8593
  319. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8593'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8593
  321. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  322. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8593'
  323. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8593
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  324. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=8593
  325. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8593'
  326. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=8593
  327. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=8593
  328. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='LN284'
  329. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9169
  330. 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`='9169'
  331. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9169
  332. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9169'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  333. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9169
  334. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  335. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9169'
  336. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9169
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  337. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9169
  338. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9169'
  339. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9169
  340. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9169
  341. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='344d'
  342. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5320
  343. 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`='5320'
  344. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5320
  345. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5320'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  346. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5320
  347. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  348. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5320'
  349. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5320
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  350. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5320
  351. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5320'
  352. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5320
  353. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5320
  354. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2264'
  355. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1110
  356. 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`='1110'
  357. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1110
  358. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1110'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  359. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1110
  360. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  361. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1110'
  362. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1110
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  363. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1110
  364. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1110'
  365. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1110
  366. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1110
  367. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1432a'
  368. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4409
  369. 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`='4409'
  370. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4409
  371. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4409'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  372. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4409
  373. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  374. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4409'
  375. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4409
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  376. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4409
  377. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4409'
  378. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4409
  379. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4409
  380. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1453a'
  381. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4430
  382. 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`='4430'
  383. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4430
  384. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4430'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  385. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4430
  386. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  387. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4430'
  388. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4430
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  389. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4430
  390. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4430'
  391. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4430
  392. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4430
  393. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1120a'
  394. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4097
  395. 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`='4097'
  396. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4097
  397. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4097'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  398. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4097
  399. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  400. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4097'
  401. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4097
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  402. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4097
  403. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4097'
  404. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4097
  405. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4097
  406. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1688a'
  407. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4665
  408. 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`='4665'
  409. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4665
  410. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4665'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  411. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4665
  412. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1770162207' OR start_date=0)
      AND (end_date>='1770075360' OR end_date=0)
      AND product_discount_id=discount_id
  413. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4665'
  414. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4665
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  415. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4665
  416. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4665'
  417. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4665
  418. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4665

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

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

Нет

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

Нет