Notice: Undefined index: HTTP_REFERER in /home/bepgasvi/public_html/sieuthibepgasgiare.vn/plugins/system/xcalendar.php on line 200
bình nóng lạnh gas owani | Bình nóng lạnh ga | 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ình nóng lạnh ga >> bình nóng lạnh gas owani

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

bình nóng lạnh gas owani

Giá: Gọi để biết giá

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ình nước nóng chạy gas Owani bình nóng lạnh gas owani Đánh lửa không phụ thuộc áp lực nước Cảm ứng nhiệt tự ngắt khi nhiệt độ quá cao, tăng khả năng an toàn khi sử dụng Với thiết kế 2 van an toàn đảm bảo sự an tâm tuyệt đối khi sử dụng Sứ đánh lửa cực nhạy, thiết kế theo tiêu chuẩn Nhật Bản Lưu lượng: 8L/phút Kích thước: Tiết kiệm 20% lượng gas sử dụng so với các SP bình tắm khác. Chi phí sử dụng bằng 1/3 so với bình tắm dùng điện. Dàn hấp thụ nhiệt bằng inox, cung cấp nước nóng tức thời, liên tục, dễ dàng điều chỉnh nhiệt độ nước theo ý muốn. Có chế độ dùng cho mùa đông và mùa hè. Hãng sản xuất: Owani Dung tích (lít): 8 Chất liệu: Inox Điện thế: 220V Trọng lượng (kg): 4.5
Last Updated: Monday, 25 September 2017 02:40

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 nay22
mod_vvisit_counterTất cả3330215

•Hiện có•: •11 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.092 seconds, 7.05 MB
Application afterRoute: 0.156 seconds, 10.90 MB
Application afterDispatch: 0.955 seconds, 21.72 MB
Application afterRender: 3.887 seconds, 37.39 MB

•Bộ nhớ sử dụng•

39593976

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = '8142l5puol9eivbcu3iuu2mks6'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1506306303' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '8142l5puol9eivbcu3iuu2mks6'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '8142l5puol9eivbcu3iuu2mks6','1506307203','','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/binh-nong-lanh-ga/binh-nong-lanh-gas-owani.html%' OR sefurl LIKE 'vmchk/binh-nong-lanh-ga/binh-nong-lanh-gas-owani.html%'
  9. SELECT oldurl, newurl
      FROM jos_redirection
      WHERE oldurl = 'vmchk/binh-nong-lanh-ga/binh-nong-lanh-gas-owani.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=12&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1173&vmcchk=1'
      AND `oldurl` = 'vmchk/binh-nong-lanh-ga/binh-nong-lanh-gas-owani.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`=1173
      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='1173'
      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 != 1173
      AND (jos_vm_product_category_xref.category_id = '12'
      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='bnl002'
  24. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='187'
      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`='187'
  26. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=187%'
      AND published=1
  27. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      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=12&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=187'
  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 = 187
  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 = '187'
  35. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=187
  36. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='187'
      AND (start_date<='1506307204' 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=187
  38. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' 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='187'
  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=187
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  42. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=187
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  43. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=187
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  44. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=187
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  45. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=187%'
      AND published=1
  46. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  47. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&lang=vi&page=shop.ask&product_id=187&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+Goldsun+GS+-+0555'
  48. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  49. 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ÓNG LẠNH DÙNG GAS HISAMA'
  50. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='660'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  51. 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`='660'
  52. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=660%'
      AND published=1
  53. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  54. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  55. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  56. 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=660'
  57. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  58. 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 = 660
  59. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '660'
  60. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=660
  61. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='660'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=660
  63. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  64. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='660'
  65. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=660
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  66. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=660
  67. 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
  68. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=660
  69. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=660
  70. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=660%'
      AND published=1
  71. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  72. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=660'
  73. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  74. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '660'
  75. 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='NA-10GH'
  76. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='326'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  77. 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`='326'
  78. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=326%'
      AND published=1
  79. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  80. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  81. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  82. 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=326'
  83. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  84. 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 = 326
  85. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '326'
  86. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=326
  87. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='326'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  88. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=326
  89. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  90. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='326'
  91. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=326
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  92. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=326
  93. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=326
  94. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=326
  95. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=326%'
      AND published=1
  96. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  97. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=326'
  98. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  99. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '326'
  100. 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 NAPOLIZ NA10GWH'
  101. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='838'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  102. 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`='838'
  103. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=838%'
      AND published=1
  104. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  105. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  106. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  107. 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=838'
  108. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  109. 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 = 838
  110. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '838'
  111. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=838
  112. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='838'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  113. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=838
  114. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='838'
  116. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=838
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  117. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=838
  118. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=838
  119. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=838
  120. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=838%'
      AND published=1
  121. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  122. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=838'
  123. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  124. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '838'
  125. 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'
  126. 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
  127. 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'
  128. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1150%'
      AND published=1
  129. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  130. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  131. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  132. 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'
  133. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  134. 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
  135. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1150'
  136. 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'
  137. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1150
  138. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1150'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1150
  140. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  141. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1150'
  142. 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
  143. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1150
  144. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1150
  145. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1150
  146. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1150%'
      AND published=1
  147. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  148. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=1150'
  149. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  150. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1150'
  151. 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=1150'
  152. 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='NA-08GH'
  153. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='325'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  154. 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`='325'
  155. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=325%'
      AND published=1
  156. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  157. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  158. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  159. 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=325'
  160. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  161. 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 = 325
  162. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '325'
  163. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=325
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='325'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=325
  166. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='325'
  168. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=325
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  169. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=325
  170. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=325
  171. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=325
  172. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=325%'
      AND published=1
  173. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  174. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=325'
  175. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  176. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '325'
  177. 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 Goldsun SH-GHS6L'
  178. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='186'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  179. 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`='186'
  180. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=186%'
      AND published=1
  181. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  182. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  183. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  184. 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=186'
  185. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  186. 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 = 186
  187. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '186'
  188. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=186
  189. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='186'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  190. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=186
  191. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  192. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='186'
  193. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=186
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  194. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=186
  195. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=186
  196. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=186
  197. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=186%'
      AND published=1
  198. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  199. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=186'
  200. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  201. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '186'
  202. 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 nazushi'
  203. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='742'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  204. 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`='742'
  205. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=742%'
      AND published=1
  206. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  207. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  208. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  209. 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=742'
  210. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  211. 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 = 742
  212. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '742'
  213. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=742
  214. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='742'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  215. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=742
  216. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='742'
  218. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=742
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  219. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=742
  220. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=742
  221. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=742
  222. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=742%'
      AND published=1
  223. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  224. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=742'
  225. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  226. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '742'
  227. 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='NA-06GH'
  228. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='324'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  229. 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`='324'
  230. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=324%'
      AND published=1
  231. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  232. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  233. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  234. 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=324'
  235. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  236. 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 = 324
  237. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '324'
  238. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=324
  239. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='324'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  240. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=324
  241. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  242. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='324'
  243. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=324
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  244. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=324
  245. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=324
  246. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=324
  247. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=324%'
      AND published=1
  248. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  249. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=324'
  250. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  251. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '324'
  252. 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='binh nóng lạnh biogas'
  253. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='848'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  254. 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`='848'
  255. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=848%'
      AND published=1
  256. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  257. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  258. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  259. 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=848'
  260. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  261. 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 = 848
  262. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '848'
  263. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=848
  264. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='848'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  265. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=848
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='848'
  268. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=848
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  269. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=848
  270. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=848
  271. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=848
  272. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=848%'
      AND published=1
  273. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  274. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=848'
  275. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  276. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '848'
  277. 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 gas Sakura 10L SH 0810'
  278. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='978'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  279. 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`='978'
  280. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=978%'
      AND published=1
  281. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  282. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  283. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  284. 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=978'
  285. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  286. 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 = 978
  287. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '978'
  288. 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=978'
  289. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=978
  290. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='978'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  291. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=978
  292. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  293. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='978'
  294. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=978
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  295. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=978
  296. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=978
  297. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=978
  298. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=978%'
      AND published=1
  299. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  300. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=978'
  301. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  302. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '978'
  303. 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=978'
  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ình nóng lạnh gas Sunhouse SHB650'
  305. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1008'
      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`='1008'
  307. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1008%'
      AND published=1
  308. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      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=12&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1008'
  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 = 1008
  314. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1008'
  315. 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=1008'
  316. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1008
  317. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1008'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  318. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1008
  319. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  320. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1008'
  321. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1008
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  322. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1008
  323. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1008
  324. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1008
  325. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1008%'
      AND published=1
  326. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  327. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=1008'
  328. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  329. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1008'
  330. 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=1008'
  331. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='12'
      AND jos_vm_category.category_id='12'
  332. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  333. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  334. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&lang=vi&page=shop.browse'
  335. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  336. 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
  337. 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`='740'
  338. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=740%'
      AND published=1
  339. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  340. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  341. 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=740'
  342. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  343. 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 = 740
  344. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '740'
  345. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=742%'
      AND published=1
  346. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  347. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  348. 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=742'
  349. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  350. 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 = 742
  351. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '742'
  352. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='12'
  353. SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='1173'
  354. SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='1173'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  355. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1173
  356. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1173'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  357. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1173
  358. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  359. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1173'
  360. 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
  361. 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
  362. 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
  363. 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
  364. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1173%'
      AND published=1
  365. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  366. 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'
  367. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  368. 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
  369. 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
  370. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1173
  371. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1173
      AND `file_is_image`=1
      AND `file_published`=1
  372. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1173
  373. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  374. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1173
      AND `file_is_image`=0
      AND `file_published`=1
  375. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1173'
  376. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  377. SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  378. 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'
  379. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1173'
  380. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='1173'
  381. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1173%'
      AND published=1
  382. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  383. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  384. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  385. 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.ask&product_id=1173'
  386. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  387. SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='1173'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  388. SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='1173'
  389. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1173
  390. SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='1173'
  391. SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='1173'
  392. 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
  393. 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
  394. SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='1173'
  395. SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='1173'
  396. SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='1173'
      AND product_publish='Y'
  397. 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
  398. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  399. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  400. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&lang=vi&page=shop.cart'
  401. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  402. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  403. 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
  404. 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'
  405. 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
  406. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1173'
  407. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1173%'
      AND published=1
  408. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  409. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  410. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  411. 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'
  412. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  413. 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
  414. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1173'
  415. 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'
  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 `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
  419. 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
  420. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1173%'
      AND published=1
  421. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  422. 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'
  423. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  424. 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'
  425. 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
  426. 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'
  427. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1169%'
      AND published=1
  428. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  429. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  430. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  431. 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'
  432. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  433. 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
  434. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1169'
  435. 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'
  436. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1169
  437. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1169'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  438. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1169
  439. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  440. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1169'
  441. 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
  442. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1169
  443. 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'
  444. 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
  445. 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'
  446. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1168%'
      AND published=1
  447. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  448. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  449. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  450. 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'
  451. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  452. 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
  453. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1168'
  454. 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'
  455. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1168
  456. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1168'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  457. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1168
  458. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  459. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1168'
  460. 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
  461. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1168
  462. 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'
  463. 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
  464. 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'
  465. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1167%'
      AND published=1
  466. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  467. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  468. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  469. 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'
  470. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  471. 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
  472. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1167'
  473. 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'
  474. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1167
  475. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1167'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  476. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1167
  477. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  478. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1167'
  479. 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
  480. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1167
  481. 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'
  482. 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
  483. 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'
  484. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1166%'
      AND published=1
  485. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  486. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  487. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  488. 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'
  489. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  490. 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
  491. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1166'
  492. 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'
  493. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1166
  494. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1166'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  495. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1166
  496. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  497. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1166'
  498. 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
  499. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1166
  500. 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'
  501. 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
  502. 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'
  503. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1165%'
      AND published=1
  504. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  505. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  506. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  507. 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'
  508. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  509. 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
  510. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1165'
  511. 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'
  512. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1165
  513. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1165'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  514. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1165
  515. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  516. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1165'
  517. 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
  518. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1165
  519. 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'
  520. 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
  521. 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'
  522. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1164%'
      AND published=1
  523. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  524. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  525. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  526. 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'
  527. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  528. 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
  529. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1164'
  530. 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'
  531. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1164
  532. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1164'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  533. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1164
  534. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  535. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1164'
  536. 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
  537. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1164
  538. 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'
  539. 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
  540. 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'
  541. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1158%'
      AND published=1
  542. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  543. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  544. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  545. 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'
  546. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  547. 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
  548. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1158'
  549. 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'
  550. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1158
  551. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1158'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  552. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1158
  553. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  554. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1158'
  555. 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
  556. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1158
  557. 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'
  558. 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
  559. 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'
  560. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1157%'
      AND published=1
  561. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  562. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  563. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  564. 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'
  565. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  566. 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
  567. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1157'
  568. 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'
  569. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1157
  570. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1157'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  571. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1157
  572. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  573. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1157'
  574. 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
  575. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1157
  576. 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'
  577. 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
  578. 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'
  579. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1156%'
      AND published=1
  580. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  581. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  582. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  583. 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'
  584. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  585. 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
  586. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1156'
  587. 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'
  588. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1156
  589. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1156'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  590. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1156
  591. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307204' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  592. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1156'
  593. 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
  594. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1156
  595. 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'
  596. 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
  597. 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'
  598. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1155%'
      AND published=1
  599. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  600. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  601. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  602. 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'
  603. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  604. 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
  605. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1155'
  606. 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'
  607. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1155
  608. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1155'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  609. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1155
  610. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  611. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1155'
  612. 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
  613. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1155
  614. 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'
  615. 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
  616. 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'
  617. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1154%'
      AND published=1
  618. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  619. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  620. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  621. 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'
  622. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  623. 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
  624. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1154'
  625. 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'
  626. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1154
  627. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1154'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  628. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1154
  629. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  630. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1154'
  631. 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
  632. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1154
  633. 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'
  634. 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
  635. 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'
  636. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1153%'
      AND published=1
  637. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  638. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  639. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  640. 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'
  641. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  642. 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
  643. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1153'
  644. 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'
  645. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1153
  646. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1153'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  647. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1153
  648. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  649. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1153'
  650. 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
  651. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1153
  652. 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'
  653. 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
  654. 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'
  655. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1152%'
      AND published=1
  656. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  657. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  658. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  659. 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'
  660. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  661. 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
  662. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1152'
  663. 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'
  664. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1152
  665. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1152'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  666. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1152
  667. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  668. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1152'
  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 `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
  672. 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
  673. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1152%'
      AND published=1
  674. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  675. 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'
  676. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  677. 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'
  678. 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
  679. 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'
  680. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1151%'
      AND published=1
  681. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  682. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  683. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  684. 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'
  685. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  686. 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
  687. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1151'
  688. 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'
  689. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1151
  690. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1151'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  691. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1151
  692. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  693. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1151'
  694. 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
  695. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1151
  696. 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'
  697. 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
  698. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1150%'
      AND published=1
  699. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  700. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  701. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  702. 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'
  703. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  704. 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
  705. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1150'
  706. 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'
  707. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1150
  708. 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'
  709. 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
  710. 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'
  711. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1149%'
      AND published=1
  712. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=161%'
      AND published=1
  713. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  714. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  715. 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'
  716. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  717. 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
  718. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1149'
  719. 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'
  720. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1149
  721. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1149'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  722. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1149
  723. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  724. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1149'
  725. 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
  726. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1149
  727. 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'
  728. 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
  729. 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'
  730. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1148%'
      AND published=1
  731. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=161%'
      AND published=1
  732. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  733. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  734. 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'
  735. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  736. 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
  737. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1148'
  738. 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'
  739. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1148
  740. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1148'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  741. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1148
  742. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  743. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1148'
  744. 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
  745. 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
  746. 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
  747. 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
  748. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1148%'
      AND published=1
  749. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  750. 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'
  751. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  752. 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'
  753. 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
  754. 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'
  755. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1147%'
      AND published=1
  756. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=159%'
      AND published=1
  757. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  758. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  759. 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'
  760. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  761. 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
  762. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1147'
  763. 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'
  764. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1147
  765. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1147'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  766. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1147
  767. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  768. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1147'
  769. 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
  770. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1147
  771. 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'
  772. 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
  773. 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'
  774. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1146%'
      AND published=1
  775. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=160%'
      AND published=1
  776. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  777. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  778. 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'
  779. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  780. 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
  781. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1146'
  782. 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'
  783. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1146
  784. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1146'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  785. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1146
  786. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  787. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1146'
  788. 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
  789. 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
  790. 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
  791. 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
  792. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1146%'
      AND published=1
  793. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  794. 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'
  795. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  796. 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'
  797. 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
  798. 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'
  799. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1145%'
      AND published=1
  800. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=159%'
      AND published=1
  801. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  802. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  803. 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'
  804. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  805. 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
  806. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1145'
  807. 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'
  808. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1145
  809. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1145'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  810. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1145
  811. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  812. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1145'
  813. 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
  814. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1145
  815. 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'
  816. 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
  817. 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'
  818. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1144%'
      AND published=1
  819. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=160%'
      AND published=1
  820. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  821. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  822. 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'
  823. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  824. 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
  825. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1144'
  826. 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'
  827. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1144
  828. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1144'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  829. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1144
  830. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  831. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1144'
  832. 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
  833. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1144
  834. 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ổ'
  835. 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
  836. 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'
  837. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1143%'
      AND published=1
  838. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=160%'
      AND published=1
  839. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  840. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  841. 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'
  842. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  843. 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
  844. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1143'
  845. 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=1143'
  846. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1143
  847. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1143'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  848. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1143
  849. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307205' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  850. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1143'
  851. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1143
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  852. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1143
  853. 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 ban công'
  854. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='1142'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  855. SELECT