Notice: Undefined index: HTTP_REFERER in /home/bepgasvi/public_html/sieuthibepgasgiare.vn/plugins/system/xcalendar.php on line 200
Bếp ga âm kính Canzy CZ-306 | Bếp ga âm Canzy | Bếp ga âm | Bếp Gas Việt | Bếp Gas | Bếp Gas Dương | Bếp Gas Âm | Bếp Gas gi


Danh mục sản phẩm


Notice: Undefined variable: PMenuID in /home/bepgasvi/public_html/sieuthibepgasgiare.vn/modules/mod_vm_menu/mod_vm_menu.php on line 6


Sản phẩm mới nhất

Trang chủ >> Sản phẩm >> Bếp ga âm >> Bếp ga âm Canzy >> Bếp ga âm kính Canzy CZ-306

Thông tin: Your browser does not accept cookies. To put products into your cart and purchase them you need to enable cookies.

Bếp ga âm kính Canzy CZ-306

Giá: 4.750.000 VND

Notice: Use of undefined constant php - assumed 'php' in /home/bepgasvi/public_html/sieuthibepgasgiare.vn/components/com_virtuemart/themes/ga/templates/product_details/flypage.tpl.php on line 50

Bếp ga âm kính Canzy CZ-306

Nhà sản xuất: CANZY

Xuất xứ: Italy
Giao hàng và lắp đặt miễn phí 
trong phạm vi nội thành Hà Nội.
(không bao gồm đục tường và khoét đá)
Bảo hành 3 năm theo hãng sản xuất

Mã sản phẩ

CZ-360

Hãng sản xuất

CANZY

Loại sản phẩm

Bếp gas âm kính

Số bếp nấu

02

Số vòng lửa

02

Mặt bếp

Kính chịu lực, chịu nhiệt dày 8mm

Cảm ứng ngắt gas tự động an toàn

Hệ thống đánh lửa IC

Pin 1,5V

Chế độ hẹn giờ

Không

Kiềng

Kiềng gang đúc siêu bền

Bộ chia lửa

Hệ thống mâm chia lửa bằng đồng

Chất liệu/ màu sắc

 

Chế độ pep hầm tiết kiệm gas

Lượng gas tiêu thụ tối đa

0,30kg/h/lò

Kích thước bề mặt

750 x 450mm

Kích thước khoét đá

680x380mm


Last Updated: Monday, 25 September 2017 02:43

Giỏ hàng của bạn

VirtueMart Giỏ của bạn chưa có hàng.

Sản phẩm khuyến mại

Hỗ trợ trực tuyến


Notice: Undefined offset: 1 in /home/bepgasvi/public_html/sieuthibepgasgiare.vn/modules/mod_pah_yahoo/helper.php on line 20

Phụ trách kinh doanh SĐT:0436615399

Phụ trách kinh doanh SĐT:01643767888

Thống kê truy cập

mod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_counter
mod_vvisit_counterHôm nay47
mod_vvisit_counterTất cả3330240

•Hiện có•: •36 khách• •Trực tuyến•
Hôm nay:25 •Tháng 9•, 2017

siêu thị bếp gas giá rẻ .vn

Địa chỉ: Số nhà 41 - Đại Từ - Đại Kim - Hoàng Mai - Hà Nội

số 114 ngõ 351 đường lĩnh nam - hoàng mai - hà nội

số 163 đường trần nhân tông ,kon tum

Điện thoại : 0436615399

Di động: 01643767888

Website : sieuthibepgasgiare.vn

 

 

•Thông tin cá nhân•

Application afterLoad: 0.000 seconds, 0.38 MB
Application afterInitialise: 0.082 seconds, 7.05 MB
Application afterRoute: 0.163 seconds, 10.89 MB
Application afterDispatch: 1.110 seconds, 21.80 MB
Application afterRender: 4.560 seconds, 37.56 MB

•Bộ nhớ sử dụng•

39765624

•2815 các truy vấn đã được ghi lại•

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'ug4apeht2iam482gvthr25fvl5'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1506306490' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'ug4apeht2iam482gvthr25fvl5'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'ug4apeht2iam482gvthr25fvl5','1506307390','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT MAX(TIME)  
      FROM jos_vvcounter_logs
  8. SELECT *
      FROM jos_migration_backlinks
      WHERE url LIKE 'vmchk/bep-ga-am-canzy/bep-ga-am-kinh-canzy-cz-306.html%' OR sefurl LIKE 'vmchk/bep-ga-am-canzy/bep-ga-am-kinh-canzy-cz-306.html%'
  9. SELECT oldurl, newurl
      FROM jos_redirection
      WHERE oldurl = 'vmchk/bep-ga-am-canzy/bep-ga-am-kinh-canzy-cz-306.html'
      ORDER BY rank ASC
      LIMIT 1
  10. UPDATE jos_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=721&vmcchk=1'
      AND `oldurl` = 'vmchk/bep-ga-am-canzy/bep-ga-am-kinh-canzy-cz-306.html'
  11. 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
  12. 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
  13. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 56)
      ORDER BY menuid DESC
      LIMIT 0, 1
  14. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  15. 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'
  16. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  17. 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`);
  18. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  19. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  20. SELECT *
      FROM `jos_vm_product`
      WHERE `product_id`=721
      AND `product_publish`='Y'
  21. SELECT product_sku, related_products
      FROM jos_vm_product,jos_vm_product_relations
      WHERE jos_vm_product_relations.product_id='721'
      AND product_publish='Y'
  22. SELECT product_sku
      FROM jos_vm_product,jos_vm_product_category_xref
      WHERE product_publish='Y'
      AND jos_vm_product.product_id != 721
      AND (jos_vm_product_category_xref.category_id = '30'
      AND jos_vm_product_category_xref.product_id = jos_vm_product.product_id)
      ORDER BY RAND()
      LIMIT 0, 12
  23. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bếp ga âm kính Canzy CZ-208'
  24. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='720'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  25. 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`='720'
  26. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=720%'
      AND published=1
  27. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  28. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  29. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  30. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=720'
  31. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  32. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 720
  33. SELECT c.category_name, c.category_id, x.category_parent_id
      FROM jos_vm_category AS c
     
      LEFT JOIN jos_vm_category_xref AS x
      ON c.category_id = x.category_child_id;
  34. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '720'
  35. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=720
  36. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='720'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  37. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=720
  38. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  39. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='720'
  40. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  41. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=720
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  42. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=720
  43. 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
  44. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=720
  45. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=720
  46. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=720%'
      AND published=1
  47. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  48. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=720'
  49. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  50. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '720'
  51. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bếp gas âm Canzy CZ-217MI'
  52. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='92'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  53. 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`='92'
  54. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=92%'
      AND published=1
  55. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  56. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  57. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  58. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=92'
  59. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  60. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 92
  61. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '92'
  62. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=92
  63. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='92'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  64. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=92
  65. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  66. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='92'
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=92
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  68. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=92
  69. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=92
  70. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=92
  71. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=92%'
      AND published=1
  72. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  73. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=92'
  74. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  75. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '92'
  76. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='CANZY CZ-26'
  77. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='524'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  78. 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`='524'
  79. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=524%'
      AND published=1
  80. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  81. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  82. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  83. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=524'
  84. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  85. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 524
  86. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '524'
  87. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=524
  88. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='524'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  89. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=524
  90. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  91. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='524'
  92. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=524
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  93. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=524
  94. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=524
  95. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=524
  96. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=524%'
      AND published=1
  97. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  98. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=524'
  99. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  100. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '524'
  101. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bếp gas âm CANZY CZ-118'
  102. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='714'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  103. 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`='714'
  104. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=714%'
      AND published=1
  105. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  106. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  107. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  108. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=714'
  109. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  110. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 714
  111. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '714'
  112. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=714
  113. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='714'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  114. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=714
  115. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='714'
  117. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=714
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  118. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=714
  119. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=714
  120. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=714
  121. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=714%'
      AND published=1
  122. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  123. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=714'
  124. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  125. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '714'
  126. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&limitstart=0&page=shop.cart&product_id=714'
  127. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bếp ga âm Canzy CZ-26MI'
  128. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='88'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  129. 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`='88'
  130. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=88%'
      AND published=1
  131. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  132. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  133. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  134. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=88'
  135. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  136. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 88
  137. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '88'
  138. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=88'
  139. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=88
  140. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='88'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  141. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=88
  142. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  143. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='88'
  144. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=88
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  145. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=88
  146. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=88
  147. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=88
  148. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=88%'
      AND published=1
  149. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  150. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=88'
  151. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  152. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '88'
  153. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bếp ga âm CANZY CZ-37MI'
  154. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='711'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  155. 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`='711'
  156. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=711%'
      AND published=1
  157. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  158. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  159. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  160. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=711'
  161. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  162. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 711
  163. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '711'
  164. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=711
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='711'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=711
  167. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  168. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='711'
  169. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=711
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  170. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=711
  171. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=711
  172. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=711
  173. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=711%'
      AND published=1
  174. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  175. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=711'
  176. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  177. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '711'
  178. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bếp gas âm Canzy CZ-118S'
  179. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='715'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  180. 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`='715'
  181. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=715%'
      AND published=1
  182. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  183. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  184. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  185. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=715'
  186. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  187. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 715
  188. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '715'
  189. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=715
  190. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='715'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  191. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=715
  192. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  193. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='715'
  194. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=715
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  195. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=715
  196. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=715
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=715
  198. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=715%'
      AND published=1
  199. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  200. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=715'
  201. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  202. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '715'
  203. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bếp gas âm CANZY LA-318AS'
  204. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='723'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  205. 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`='723'
  206. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=723%'
      AND published=1
  207. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  208. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  209. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  210. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=723'
  211. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  212. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 723
  213. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '723'
  214. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=723
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='723'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=723
  217. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  218. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='723'
  219. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=723
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  220. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=723
  221. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=723
  222. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=723
  223. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=723%'
      AND published=1
  224. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  225. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=723'
  226. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  227. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '723'
  228. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bếp gas âm Canzy CZ-202'
  229. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='717'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  230. 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`='717'
  231. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=717%'
      AND published=1
  232. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  233. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  234. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  235. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=717'
  236. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  237. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 717
  238. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '717'
  239. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=717
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='717'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=717
  242. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  243. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='717'
  244. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=717
      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=717
  246. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=717
  247. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=717
  248. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=717%'
      AND published=1
  249. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  250. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=717'
  251. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  252. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '717'
  253. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bếp gas âm Canzy CZ-27FI'
  254. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='93'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  255. 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`='93'
  256. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=93%'
      AND published=1
  257. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  258. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  259. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  260. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=93'
  261. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  262. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 93
  263. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '93'
  264. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=93
  265. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='93'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  266. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=93
  267. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  268. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='93'
  269. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=93
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  270. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=93
  271. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=93
  272. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=93
  273. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=93%'
      AND published=1
  274. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  275. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=93'
  276. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  277. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '93'
  278. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&limitstart=0&page=shop.cart&product_id=93'
  279. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bếp gas âm Cz-270'
  280. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='91'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  281. 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`='91'
  282. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=91%'
      AND published=1
  283. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  284. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  285. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  286. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=91'
  287. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  288. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 91
  289. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '91'
  290. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=91
  291. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='91'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  292. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=91
  293. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  294. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='91'
  295. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=91
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  296. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=91
  297. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=91
  298. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=91
  299. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=91%'
      AND published=1
  300. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  301. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=91'
  302. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  303. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '91'
  304. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bếp gas âm CANZY CZ-116'
  305. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='722'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  306. 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`='722'
  307. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=722%'
      AND published=1
  308. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  309. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  310. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  311. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=722'
  312. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  313. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 722
  314. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '722'
  315. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=722
  316. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='722'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  317. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=722
  318. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='722'
  320. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=722
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  321. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=722
  322. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=722
  323. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=722
  324. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=722%'
      AND published=1
  325. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  326. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=722'
  327. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  328. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '722'
  329. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='30'
      AND jos_vm_category.category_id='30'
  330. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='5'
      AND jos_vm_category.category_id='5'
  331. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=5%'
      AND published=1
  332. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  333. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=5&lang=vi&page=shop.browse'
  334. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  335. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  336. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  337. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&lang=vi&page=shop.browse'
  338. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  339. SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
                                    `jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
                                    `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE (`jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` OR `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_parent_id`)
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 2000
  340. 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`='534'
  341. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=534%'
      AND published=1
  342. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  343. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  344. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&flypage=flypage.tpl&lang=vi&page=shop.product_details&pop=0&product_id=534'
  345. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  346. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 534
  347. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '534'
  348. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=720%'
      AND published=1
  349. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  350. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  351. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&flypage=flypage.tpl&lang=vi&page=shop.product_details&pop=0&product_id=720'
  352. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  353. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 720
  354. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '720'
  355. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='30'
  356. SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='721'
  357. SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='721'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  358. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=721
  359. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='721'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  360. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=721
  361. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  362. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='721'
  363. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=721
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  364. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=721
  365. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=721
  366. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=721
      AND `file_is_image`=1
      AND `file_published`=1
  367. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=721
  368. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  369. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=721
      AND `file_is_image`=0
      AND `file_published`=1
  370. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='721'
  371. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  372. SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  373. SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `jos_vm_product_files`
      WHERE file_product_id = '0'
      AND file_published = '1'
      AND file_is_image = '0'
  374. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='721'
  375. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='721'
  376. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=721%'
      AND published=1
  377. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=30%'
      AND published=1
  378. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  379. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  380. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=30&flypage=flypage.tpl&lang=vi&page=shop.ask&product_id=721'
  381. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  382. SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='721'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  383. SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='721'
  384. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=721
  385. SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='721'
  386. SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='721'
  387. SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='721'
  388. SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='721'
  389. SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='721'
      AND product_publish='Y'
  390. 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 = 56 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  391. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  392. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  393. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&lang=vi&page=shop.cart'
  394. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  395. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  396. 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'
      AND jos_vm_product.product_s_desc=""
      ORDER BY jos_vm_product.product_id DESC
      LIMIT 0, 100
  397. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bình nóng lạnh gas owani'
  398. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1173'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  399. 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`='1173'
  400. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1173%'
      AND published=1
  401. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  402. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  403. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  404. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1173'
  405. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  406. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1173
  407. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1173'
  408. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1173'
  409. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1173
  410. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1173'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  411. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1173
  412. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  413. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1173'
  414. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1173
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  415. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1173
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  416. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1173
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  417. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1173
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  418. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1173%'
      AND published=1
  419. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  420. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&lang=vi&page=shop.ask&product_id=1173&subject=G%E1%BB%8Di+%C4%91%E1%BB%83+bi%E1%BA%BFt+gi%C3%A1%3A+b%26Atilde%3B%26not%3Bnh+n%26Atilde%3B%26sup3%3Bng+l%26aacute%3B%26ordm%3B%26iexcl%3Bnh+gas+owani'
  421. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  422. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bình nóng lạnh Rossi TI 20L'
  423. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1169'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  424. 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`='1169'
  425. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1169%'
      AND published=1
  426. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  427. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  428. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  429. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1169'
  430. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  431. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1169
  432. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1169'
  433. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1169'
  434. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1169
  435. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1169'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  436. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1169
  437. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  438. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1169'
  439. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1169
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  440. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1169
  441. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bình nóng lạnh Rossi HQ 20L'
  442. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1168'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  443. 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`='1168'
  444. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1168%'
      AND published=1
  445. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  446. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  447. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  448. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1168'
  449. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  450. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1168
  451. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1168'
  452. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1168'
  453. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1168
  454. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1168'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  455. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1168
  456. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  457. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1168'
  458. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1168
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  459. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1168
  460. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bình nóng lạnh Rossi HQ PRO 15L'
  461. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1167'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  462. 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`='1167'
  463. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1167%'
      AND published=1
  464. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  465. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  466. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  467. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1167'
  468. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  469. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1167
  470. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1167'
  471. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1167'
  472. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1167
  473. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1167'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  474. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1167
  475. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307391' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  476. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1167'
  477. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1167
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  478. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1167
  479. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bình nóng lạnh Rossi TI 15L'
  480. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1166'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  481. 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`='1166'
  482. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1166%'
      AND published=1
  483. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  484. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  485. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  486. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1166'
  487. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  488. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1166
  489. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1166'
  490. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1166'
  491. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1166
  492. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1166'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  493. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1166
  494. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  495. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1166'
  496. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1166
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  497. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1166
  498. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='BÌNH NÓNG LẠNH ROSSI HQ PRO 30L'
  499. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1165'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  500. 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`='1165'
  501. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1165%'
      AND published=1
  502. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  503. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  504. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  505. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1165'
  506. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  507. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1165
  508. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1165'
  509. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1165'
  510. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1165
  511. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1165'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  512. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1165
  513. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  514. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1165'
  515. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1165
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  516. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1165
  517. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='BÌNH NÓNG LẠNH ROSSI HQ 30L'
  518. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1164'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  519. 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`='1164'
  520. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1164%'
      AND published=1
  521. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  522. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  523. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  524. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1164'
  525. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  526. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1164
  527. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1164'
  528. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=165&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1164'
  529. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1164
  530. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1164'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  531. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1164
  532. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  533. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1164'
  534. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1164
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  535. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1164
  536. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bếp gas đơn piogas'
  537. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1158'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  538. 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`='1158'
  539. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1158%'
      AND published=1
  540. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  541. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  542. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  543. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1158'
  544. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  545. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1158
  546. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1158'
  547. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1158'
  548. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1158
  549. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1158'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  550. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1158
  551. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  552. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1158'
  553. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1158
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  554. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1158
  555. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bếp đôi kính piogas'
  556. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1157'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  557. 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`='1157'
  558. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1157%'
      AND published=1
  559. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  560. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  561. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  562. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1157'
  563. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  564. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1157
  565. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1157'
  566. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1157'
  567. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1157
  568. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1157'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  569. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1157
  570. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  571. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1157'
  572. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1157
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  573. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1157
  574. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bếp gas piogas inox'
  575. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1156'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  576. 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`='1156'
  577. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1156%'
      AND published=1
  578. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  579. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  580. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  581. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1156'
  582. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  583. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1156
  584. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1156'
  585. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1156'
  586. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1156
  587. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1156'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  588. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1156
  589. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  590. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1156'
  591. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1156
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  592. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1156
  593. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='đèn sưởi piogas men'
  594. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1155'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  595. 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`='1155'
  596. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1155%'
      AND published=1
  597. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  598. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  599. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  600. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1155'
  601. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  602. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1155
  603. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1155'
  604. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1155'
  605. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1155
  606. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1155'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  607. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1155
  608. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  609. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1155'
  610. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1155
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  611. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1155
  612. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='đèn sưởi piogas'
  613. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1154'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  614. 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`='1154'
  615. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1154%'
      AND published=1
  616. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  617. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  618. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  619. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1154'
  620. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  621. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1154
  622. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1154'
  623. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1154'
  624. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1154
  625. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1154'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  626. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1154
  627. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  628. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1154'
  629. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1154
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  630. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1154
  631. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bóng đèn piogas'
  632. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1153'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  633. 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`='1153'
  634. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1153%'
      AND published=1
  635. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  636. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  637. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  638. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1153'
  639. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  640. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1153
  641. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1153'
  642. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1153'
  643. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1153
  644. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1153'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  645. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1153
  646. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  647. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1153'
  648. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1153
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  649. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1153
  650. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='nồi cơm biogas men'
  651. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1152'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  652. 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`='1152'
  653. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1152%'
      AND published=1
  654. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  655. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  656. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  657. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1152'
  658. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  659. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1152
  660. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1152'
  661. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1152'
  662. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1152
  663. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1152'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  664. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1152
  665. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  666. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1152'
  667. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1152
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  668. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1152
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  669. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1152
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  670. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1152
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  671. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1152%'
      AND published=1
  672. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  673. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&lang=vi&page=shop.ask&product_id=1152&subject=G%E1%BB%8Di+%C4%91%E1%BB%83+bi%E1%BA%BFt+gi%C3%A1%3A+n%26Atilde%3B%26acute%3B%26Igrave%3B%80i+c%26AElig%3B%26iexcl%3Bm+biogas+men'
  674. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  675. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='nồi cơm biogas INOX'
  676. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1151'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  677. 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`='1151'
  678. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1151%'
      AND published=1
  679. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  680. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  681. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  682. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1151'
  683. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  684. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1151
  685. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1151'
  686. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=162&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1151'
  687. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1151
  688. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1151'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  689. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1151
  690. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  691. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1151'
  692. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1151
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  693. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1151
  694. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bình nước nóng Biogas'
  695. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1150'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  696. 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`='1150'
  697. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1150%'
      AND published=1
  698. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  699. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  700. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  701. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1150'
  702. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  703. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1150
  704. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1150'
  705. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1150'
  706. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1150
  707. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1150'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  708. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1150
  709. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  710. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1150'
  711. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1150
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  712. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1150
  713. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bạt che ban công'
  714. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1149'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  715. 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`='1149'
  716. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1149%'
      AND published=1
  717. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=161%'
      AND published=1
  718. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  719. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  720. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=161&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1149'
  721. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  722. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1149
  723. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1149'
  724. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=161&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1149'
  725. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1149
  726. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1149'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  727. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1149
  728. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  729. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1149'
  730. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1149
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  731. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1149
  732. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bạt che nắng mưa'
  733. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1148'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  734. 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`='1148'
  735. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1148%'
      AND published=1
  736. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=161%'
      AND published=1
  737. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  738. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  739. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=161&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1148'
  740. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  741. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1148
  742. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1148'
  743. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=161&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1148'
  744. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1148
  745. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1148'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  746. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1148
  747. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  748. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1148'
  749. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1148
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  750. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1148
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  751. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1148
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  752. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1148
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  753. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1148%'
      AND published=1
  754. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  755. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&lang=vi&page=shop.ask&product_id=1148&subject=G%E1%BB%8Di+%C4%91%E1%BB%83+bi%E1%BA%BFt+gi%C3%A1%3A+b%26aacute%3B%26ordm%3B%26iexcl%3Bt+che+n%26aacute%3B%26ordm%3B%26macr%3Bng+m%26AElig%3B%26deg%3Ba'
  756. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  757. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='dàn phơi hòa phát'
  758. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1147'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  759. 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`='1147'
  760. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1147%'
      AND published=1
  761. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=159%'
      AND published=1
  762. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  763. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  764. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=159&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1147'
  765. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  766. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1147
  767. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1147'
  768. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=159&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1147'
  769. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1147
  770. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1147'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  771. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1147
  772. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  773. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1147'
  774. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1147
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  775. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1147
  776. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='lưới an toàn bảo vệ gia đình bạn'
  777. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1146'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  778. 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`='1146'
  779. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1146%'
      AND published=1
  780. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=160%'
      AND published=1
  781. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  782. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  783. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=160&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1146'
  784. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  785. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1146
  786. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1146'
  787. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=160&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1146'
  788. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1146
  789. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1146'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  790. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1146
  791. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  792. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1146'
  793. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1146
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  794. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1146
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  795. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1146
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  796. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1146
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  797. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1146%'
      AND published=1
  798. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  799. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&lang=vi&page=shop.ask&product_id=1146&subject=G%E1%BB%8Di+%C4%91%E1%BB%83+bi%E1%BA%BFt+gi%C3%A1%3A+l%26AElig%3B%26deg%3B%26aacute%3B%26raquo%3B%9Bi+an+to%26Atilde%3B%26nbsp%3Bn+b%26aacute%3B%26ordm%3B%26pound%3Bo+v%26aacute%3B%26raquo%3B%87+gia+%26Auml%3B%91%26Atilde%3B%26not%3Bnh+b%26aacute%3B%26ordm%3B%26iexcl%3Bn'
  800. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  801. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Giàn Phơi Quần Áo'
  802. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1145'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  803. 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`='1145'
  804. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1145%'
      AND published=1
  805. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=159%'
      AND published=1
  806. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  807. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  808. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=159&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1145'
  809. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  810. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1145
  811. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1145'
  812. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=159&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1145'
  813. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1145
  814. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1145'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  815. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1145
  816. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  817. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1145'
  818. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1145
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  819. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1145
  820. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Lưới an toàn'
  821. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1144'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  822. 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`='1144'
  823. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1144%'
      AND published=1
  824. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=160%'
      AND published=1
  825. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  826. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  827. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=160&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1144'
  828. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  829. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1144
  830. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1144'
  831. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=160&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1144'
  832. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1144
  833. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1144'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  834. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1144
  835. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307392' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  836. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1144'
  837. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1144
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  838. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1144
  839. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Lưới an toàn cửa sổ'
  840. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1143'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  841. 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`='1143'
  842. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1143%'
      AND published=1
  843. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=160%'
      AND published=1
  844. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  845. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  846. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=160&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1143'
  847. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  848. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1143
  849. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1143'
  850. SELECT oldurl
      FROM jos_redirection