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

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.018 seconds, 3.89 MB
Application afterRoute: 0.025 seconds, 5.49 MB
Application afterDispatch: 0.059 seconds, 9.48 MB
Application afterRender: 0.493 seconds, 18.34 MB

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

19350400

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'bt3fdbu4fau6d7sjgsleg6chs6'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1775745491' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'bt3fdbu4fau6d7sjgsleg6chs6'
  4. UPDATE `jos_session`
      SET `time`='1775747591',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1775747589;s:18:\"session.timer.last\";i:1775747590;s:17:\"session.timer.now\";i:1775747591;s:24:\"session.client.forwarded\";s:13:\"216.73.216.32\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/home/motoring/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}VMCHECK|s:2:\"OK\";auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:6:\"грн\";userstate|a:1:{s:10:\"product_id\";i:0;}last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:3:\"189\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";'
      WHERE session_id='bt3fdbu4fau6d7sjgsleg6chs6'
  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-04-09 15:13:11' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 15:13:11' )
      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-04-09 15:13:11' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 15:13:11' )
      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 `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  15. 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
  16. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  17. 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
  18. 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`);
  19. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  20. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  21. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  22. SELECT m.manufacturer_id,m.mf_name
      FROM jos_vm_manufacturer m
      ORDER BY m.mf_name ASC
  23. 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
  24. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD25'
  25. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9836
  26. 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'
  27. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9836
  28. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9836'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9836
  30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  31. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9836'
  32. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  33. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9836
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  34. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9836
  35. 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
  36. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9836'
  37. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9836
  38. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9836
  39. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD27'
  40. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9835
  41. 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'
  42. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9835
  43. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9835'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  44. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9835
  45. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  46. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9835'
  47. 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
  48. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9835
  49. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9835'
  50. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9835
  51. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9835
  52. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD43'
  53. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9834
  54. 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'
  55. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9834
  56. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9834'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  57. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9834
  58. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  59. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9834'
  60. 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
  61. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9834
  62. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9834'
  63. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9834
  64. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9834
  65. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD42'
  66. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9833
  67. 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'
  68. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9833
  69. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9833'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  70. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9833
  71. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  72. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9833'
  73. 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
  74. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9833
  75. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9833'
  76. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9833
  77. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9833
  78. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD41'
  79. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9832
  80. 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'
  81. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9832
  82. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9832'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  83. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9832
  84. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  85. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9832'
  86. 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
  87. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9832
  88. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9832'
  89. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9832
  90. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9832
  91. 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-04-09 12:13:11' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 12:13:11' )
      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
  92. 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
  93. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AV0056'
  94. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6848
  95. 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`='6848'
  96. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6848
  97. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6848'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6848
  99. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  100. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6848'
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6848
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  102. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6848
  103. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6848'
  104. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6848
  105. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6848
  106. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='917a'
  107. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3894
  108. 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`='3894'
  109. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3894
  110. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3894'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  111. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3894
  112. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  113. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3894'
  114. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3894
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  115. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3894
  116. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3894'
  117. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3894
  118. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3894
  119. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ZA023'
  120. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7189
  121. 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`='7189'
  122. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7189
  123. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7189'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  124. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7189
  125. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  126. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7189'
  127. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7189
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  128. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7189
  129. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7189'
  130. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7189
  131. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7189
  132. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2773'
  133. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1618
  134. 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`='1618'
  135. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1618
  136. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1618'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  137. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1618
  138. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1618'
  140. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  141. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1618
  142. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1618'
  143. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1618
  144. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1618
  145. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='882a'
  146. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3859
  147. 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`='3859'
  148. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3859
  149. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3859'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3859
  151. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  152. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3859'
  153. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3859
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  154. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3859
  155. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3859'
  156. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3859
  157. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3859
  158. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1652a'
  159. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4629
  160. 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`='4629'
  161. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4629
  162. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4629'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  163. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4629
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4629'
  166. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4629
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  167. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4629
  168. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4629'
  169. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4629
  170. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4629
  171. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DAV090'
  172. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7023
  173. 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`='7023'
  174. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7023
  175. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7023'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  176. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7023
  177. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  178. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7023'
  179. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7023
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  180. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7023
  181. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7023'
  182. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7023
  183. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7023
  184. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VN0002'
  185. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7083
  186. 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`='7083'
  187. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7083
  188. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7083'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  189. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7083
  190. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  191. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7083'
  192. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7083
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  193. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7083
  194. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7083'
  195. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7083
  196. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7083
  197. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='K806'
  198. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9686
  199. 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`='9686'
  200. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9686
  201. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9686'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9686
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9686'
  205. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9686
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  206. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9686
  207. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9686'
  208. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9686
  209. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9686
  210. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='8836z'
  211. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3642
  212. 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`='3642'
  213. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3642
  214. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3642'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  215. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3642
  216. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3642'
  218. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3642
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  219. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3642
  220. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3642'
  221. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3642
  222. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3642
  223. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AV0079'
  224. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6871
  225. 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`='6871'
  226. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6871
  227. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6871'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  228. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6871
  229. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  230. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6871'
  231. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6871
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  232. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6871
  233. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6871'
  234. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6871
  235. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6871
  236. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='186a'
  237. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3540
  238. 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`='3540'
  239. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3540
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3540'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3540
  242. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  243. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3540'
  244. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3540
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  245. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3540
  246. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3540'
  247. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3540
  248. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3540
  249. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0009'
  250. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2327
  251. 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`='2327'
  252. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2327
  253. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2327'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  254. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2327
  255. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  256. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2327'
  257. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2327
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  258. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2327
  259. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2327'
  260. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2327
  261. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2327
  262. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2620'
  263. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1465
  264. 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`='1465'
  265. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1465
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1465'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1465
  268. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  269. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1465'
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1465
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  271. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1465
  272. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1465'
  273. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1465
  274. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1465
  275. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='218'
  276. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=140
  277. 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`='140'
  278. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=140
  279. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='140'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  280. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=140
  281. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  282. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='140'
  283. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=140
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  284. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=140
  285. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='140'
  286. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=140
  287. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=140
  288. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='MON1340'
  289. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9502
  290. 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`='9502'
  291. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9502
  292. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9502'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  293. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9502
  294. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  295. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9502'
  296. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9502
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  297. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9502
  298. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9502'
  299. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9502
  300. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9502
  301. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='3879'
  302. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1921
  303. 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`='1921'
  304. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1921
  305. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1921'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  306. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1921
  307. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  308. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1921'
  309. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1921
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  310. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1921
  311. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1921'
  312. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1921
  313. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1921
  314. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2694'
  315. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1539
  316. 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`='1539'
  317. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1539
  318. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1539'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1539
  320. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  321. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1539'
  322. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1539
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  323. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1539
  324. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1539'
  325. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1539
  326. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1539
  327. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='4201'
  328. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2060
  329. 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`='2060'
  330. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2060
  331. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2060'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  332. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2060
  333. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  334. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2060'
  335. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2060
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  336. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2060
  337. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2060'
  338. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2060
  339. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2060
  340. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ZS0015'
  341. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6257
  342. 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`='6257'
  343. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6257
  344. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6257'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  345. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6257
  346. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  347. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6257'
  348. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6257
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  349. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6257
  350. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6257'
  351. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6257
  352. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6257
  353. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1720a'
  354. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4697
  355. 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`='4697'
  356. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4697
  357. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4697'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  358. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4697
  359. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  360. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4697'
  361. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4697
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  362. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4697
  363. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4697'
  364. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4697
  365. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4697
  366. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='17606'
  367. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7588
  368. 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`='7588'
  369. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7588
  370. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7588'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  371. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7588
  372. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  373. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7588'
  374. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7588
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  375. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7588
  376. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7588'
  377. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7588
  378. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7588
  379. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='299'
  380. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=221
  381. 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`='221'
  382. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=221
  383. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='221'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  384. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=221
  385. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  386. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='221'
  387. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=221
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  388. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=221
  389. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='221'
  390. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=221
  391. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=221
  392. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2601'
  393. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1446
  394. 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`='1446'
  395. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1446
  396. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1446'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  397. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1446
  398. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  399. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1446'
  400. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1446
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  401. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1446
  402. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1446'
  403. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1446
  404. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1446
  405. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VXC059'
  406. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2668
  407. 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`='2668'
  408. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2668
  409. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2668'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  410. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2668
  411. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  412. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2668'
  413. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2668
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  414. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2668
  415. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2668'
  416. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2668
  417. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2668

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'bt3fdbu4fau6d7sjgsleg6chs6'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1775745491' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'bt3fdbu4fau6d7sjgsleg6chs6'
  4. UPDATE `jos_session`
      SET `time`='1775747591',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1775747589;s:18:\"session.timer.last\";i:1775747590;s:17:\"session.timer.now\";i:1775747591;s:24:\"session.client.forwarded\";s:13:\"216.73.216.32\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/home/motoring/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}VMCHECK|s:2:\"OK\";auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:6:\"грн\";userstate|a:1:{s:10:\"product_id\";i:0;}last_page|s:11:\"shop.browse\";last_browse_parameters|a:7:{s:11:\"category_id\";s:3:\"189\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";'
      WHERE session_id='bt3fdbu4fau6d7sjgsleg6chs6'
  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-04-09 15:13:11' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 15:13:11' )
      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-04-09 15:13:11' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 15:13:11' )
      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 `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  15. 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
  16. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  17. 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
  18. 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`);
  19. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  20. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  21. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  22. SELECT m.manufacturer_id,m.mf_name
      FROM jos_vm_manufacturer m
      ORDER BY m.mf_name ASC
  23. 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
  24. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD25'
  25. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9836
  26. 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'
  27. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9836
  28. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9836'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  29. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9836
  30. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  31. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9836'
  32. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  33. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9836
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  34. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9836
  35. 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
  36. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9836'
  37. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9836
  38. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9836
  39. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD27'
  40. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9835
  41. 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'
  42. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9835
  43. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9835'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  44. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9835
  45. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  46. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9835'
  47. 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
  48. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9835
  49. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9835'
  50. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9835
  51. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9835
  52. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD43'
  53. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9834
  54. 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'
  55. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9834
  56. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9834'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  57. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9834
  58. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  59. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9834'
  60. 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
  61. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9834
  62. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9834'
  63. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9834
  64. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9834
  65. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD42'
  66. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9833
  67. 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'
  68. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9833
  69. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9833'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  70. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9833
  71. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  72. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9833'
  73. 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
  74. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9833
  75. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9833'
  76. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9833
  77. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9833
  78. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HD41'
  79. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9832
  80. 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'
  81. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9832
  82. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9832'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  83. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9832
  84. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747591' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  85. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9832'
  86. 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
  87. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9832
  88. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9832'
  89. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9832
  90. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9832
  91. 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-04-09 12:13:11' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 12:13:11' )
      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
  92. 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
  93. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AV0056'
  94. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6848
  95. 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`='6848'
  96. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6848
  97. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6848'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6848
  99. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  100. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6848'
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6848
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  102. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6848
  103. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6848'
  104. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6848
  105. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6848
  106. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='917a'
  107. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3894
  108. 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`='3894'
  109. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3894
  110. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3894'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  111. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3894
  112. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  113. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3894'
  114. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3894
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  115. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3894
  116. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3894'
  117. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3894
  118. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3894
  119. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ZA023'
  120. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7189
  121. 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`='7189'
  122. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7189
  123. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7189'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  124. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7189
  125. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  126. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7189'
  127. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7189
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  128. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7189
  129. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7189'
  130. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7189
  131. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7189
  132. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2773'
  133. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1618
  134. 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`='1618'
  135. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1618
  136. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1618'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  137. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1618
  138. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1618'
  140. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1618
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  141. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1618
  142. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1618'
  143. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1618
  144. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1618
  145. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='882a'
  146. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3859
  147. 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`='3859'
  148. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3859
  149. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3859'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  150. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3859
  151. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  152. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3859'
  153. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3859
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  154. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3859
  155. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3859'
  156. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3859
  157. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3859
  158. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1652a'
  159. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4629
  160. 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`='4629'
  161. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4629
  162. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4629'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  163. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4629
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4629'
  166. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4629
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  167. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4629
  168. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4629'
  169. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4629
  170. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4629
  171. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DAV090'
  172. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7023
  173. 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`='7023'
  174. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7023
  175. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7023'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  176. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7023
  177. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  178. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7023'
  179. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7023
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  180. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7023
  181. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7023'
  182. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7023
  183. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7023
  184. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VN0002'
  185. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7083
  186. 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`='7083'
  187. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7083
  188. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7083'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  189. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7083
  190. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  191. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7083'
  192. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7083
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  193. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7083
  194. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7083'
  195. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7083
  196. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7083
  197. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='K806'
  198. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9686
  199. 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`='9686'
  200. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9686
  201. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9686'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9686
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9686'
  205. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9686
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  206. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9686
  207. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9686'
  208. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9686
  209. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9686
  210. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='8836z'
  211. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3642
  212. 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`='3642'
  213. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3642
  214. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3642'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  215. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3642
  216. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3642'
  218. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3642
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  219. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3642
  220. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3642'
  221. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3642
  222. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3642
  223. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='AV0079'
  224. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6871
  225. 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`='6871'
  226. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6871
  227. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6871'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  228. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6871
  229. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  230. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6871'
  231. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6871
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  232. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6871
  233. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6871'
  234. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6871
  235. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6871
  236. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='186a'
  237. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=3540
  238. 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`='3540'
  239. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3540
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3540'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3540
  242. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  243. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3540'
  244. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3540
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  245. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3540
  246. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='3540'
  247. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3540
  248. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3540
  249. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0009'
  250. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2327
  251. 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`='2327'
  252. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2327
  253. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2327'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  254. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2327
  255. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  256. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2327'
  257. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2327
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  258. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2327
  259. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2327'
  260. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2327
  261. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2327
  262. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2620'
  263. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1465
  264. 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`='1465'
  265. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1465
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1465'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1465
  268. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  269. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1465'
  270. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1465
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  271. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1465
  272. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1465'
  273. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1465
  274. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1465
  275. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='218'
  276. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=140
  277. 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`='140'
  278. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=140
  279. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='140'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  280. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=140
  281. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  282. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='140'
  283. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=140
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  284. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=140
  285. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='140'
  286. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=140
  287. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=140
  288. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='MON1340'
  289. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=9502
  290. 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`='9502'
  291. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=9502
  292. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='9502'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  293. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=9502
  294. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  295. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='9502'
  296. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=9502
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  297. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=9502
  298. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='9502'
  299. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=9502
  300. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=9502
  301. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='3879'
  302. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1921
  303. 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`='1921'
  304. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1921
  305. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1921'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  306. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1921
  307. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  308. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1921'
  309. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1921
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  310. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1921
  311. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1921'
  312. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1921
  313. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1921
  314. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2694'
  315. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1539
  316. 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`='1539'
  317. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1539
  318. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1539'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1539
  320. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  321. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1539'
  322. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1539
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  323. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1539
  324. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1539'
  325. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1539
  326. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1539
  327. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='4201'
  328. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2060
  329. 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`='2060'
  330. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2060
  331. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2060'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  332. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2060
  333. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  334. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2060'
  335. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2060
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  336. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2060
  337. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2060'
  338. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2060
  339. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2060
  340. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='ZS0015'
  341. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=6257
  342. 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`='6257'
  343. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=6257
  344. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='6257'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  345. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=6257
  346. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  347. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='6257'
  348. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=6257
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  349. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=6257
  350. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='6257'
  351. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=6257
  352. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=6257
  353. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='1720a'
  354. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4697
  355. 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`='4697'
  356. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4697
  357. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4697'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  358. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4697
  359. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  360. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4697'
  361. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4697
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  362. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=4697
  363. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4697'
  364. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=4697
  365. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=4697
  366. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='17606'
  367. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7588
  368. 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`='7588'
  369. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7588
  370. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7588'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  371. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7588
  372. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  373. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7588'
  374. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7588
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  375. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=7588
  376. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7588'
  377. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=7588
  378. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=7588
  379. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='299'
  380. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=221
  381. 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`='221'
  382. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=221
  383. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='221'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  384. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=221
  385. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  386. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='221'
  387. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=221
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  388. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=221
  389. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='221'
  390. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=221
  391. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=221
  392. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='2601'
  393. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=1446
  394. 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`='1446'
  395. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1446
  396. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1446'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  397. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1446
  398. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  399. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1446'
  400. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1446
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  401. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1446
  402. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1446'
  403. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1446
  404. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1446
  405. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='VXC059'
  406. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2668
  407. 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`='2668'
  408. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2668
  409. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2668'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  410. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2668
  411. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1775747592' OR start_date=0)
      AND (end_date>='1775691360' OR end_date=0)
      AND product_discount_id=discount_id
  412. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2668'
  413. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2668
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  414. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2668
  415. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2668'
  416. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2668
  417. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2668

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

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

Нет

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

Нет