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 SAKURA SH-0610 | 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 SAKURA SH-0610

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 SAKURA SH-0610

Giá: 2.990.000 VND

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

bình nóng lạnh gas SAKURA SH-0610

Máy nước nóng lạnh SH-0610

Model: SH-0610
Hãng sản xuất: SAKURA
Sản phẩm bán tại :Siêu thị bếp gas giá rẻ .vn

SH-0610

TÍNH NĂNG NỔI BẬT

Máy nước nóng trực tiếp dùng gas Sakura, an toàn và tiện lợi
Tự động khởi động máy bằng IC khi mở nước,
Tự động ngắt gas khi cúp nước, nhiệt  độ >75oC
Sau 20 phút hoạt động, máy sẽ tự động tắt
Lượng nước đun nóng: 10 lít/phút

THÔNG TIN CHI TIẾT SẢN PHẨM

DUNG TÍCH: 10 LÍT 
Máy nước nóng trực tiếp dùng gas Sakura, an toàn và tiện lợi
Tự động khởi động máy bằng IC khi mở nước,
Tự động ngắt gas khi cúp nước, nhiệt  độ > 75oC
Sau 20 phút hoạt động, máy sẽ tự động tắt
Lượng nước đun nóng: 10 lít/phút.
Mức gas tiêu thụ: 0,64kg/h.
Đường kính ống thoát khí: φ110mm
Kích thước (mm): 550(d) x 330(r) x 190(c)
Bảo hành 12 tháng
Xuất xứ : Đài Loan
Lưu ý: Đo áp lực nước tại vị trí dự định lắp máy. Áp suất nước tối thiểu qui định để máy hoạt động tốt là : 0.25kg/m2

* Vị trí lắp đặt:  Bên ngoài hoặc trong phòng tắm có cửa thông gió
* Sử dụng bình gas & van thấp áp

Giao hàng: Miễn phí nội thành Hà Nội : đt 0945913335


Last Updated: Tuesday, 26 September 2017 03:45

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 nay200
mod_vvisit_counterTất cả3330843

•Hiện có•: •116 khách• •Trực tuyến•
Hôm nay:26 •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.573 seconds, 7.05 MB
Application afterRoute: 0.725 seconds, 10.90 MB
Application afterDispatch: 1.313 seconds, 21.72 MB
Application afterRender: 3.985 seconds, 37.39 MB

•Bộ nhớ sử dụng•

39595872

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'pjshtonifglkquim3r0g8fdoc3'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1506396646' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'pjshtonifglkquim3r0g8fdoc3'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'pjshtonifglkquim3r0g8fdoc3','1506397547','','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-sakura-sh-0610.html%' OR sefurl LIKE 'vmchk/binh-nong-lanh-ga/binh-nong-lanh-gas-sakura-sh-0610.html%'
  9. SELECT oldurl, newurl
      FROM jos_redirection
      WHERE oldurl = 'vmchk/binh-nong-lanh-ga/binh-nong-lanh-gas-sakura-sh-0610.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=843&vmcchk=1'
      AND `oldurl` = 'vmchk/binh-nong-lanh-ga/binh-nong-lanh-gas-sakura-sh-0610.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`=843
      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='843'
      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 != 843
      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='bình tắm nóng lạnh sử dụng Biogas'
  24. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='977'
      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`='977'
  26. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=977%'
      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=977'
  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 = 977
  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 = '977'
  35. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=977
  36. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='977'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  37. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=977
  38. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  39. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='977'
  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=977
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  42. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=977
  43. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  44. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=977
  45. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=977
  46. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=977%'
      AND published=1
  47. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  48. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=977'
  49. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  50. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '977'
  51. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bình nóng lạnh gas nazushi'
  52. 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
  53. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='742'
  54. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=742%'
      AND published=1
  55. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  56. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  57. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  58. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=742'
  59. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  60. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 742
  61. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '742'
  62. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=742
  63. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='742'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  64. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=742
  65. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  66. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='742'
  67. 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
  68. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=742
  69. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=742
  70. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=742
  71. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=742%'
      AND published=1
  72. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  73. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=742'
  74. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  75. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '742'
  76. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bình nóng lạnh gas SAKURA SH-0506'
  77. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='844'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  78. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='844'
  79. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=844%'
      AND published=1
  80. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  81. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  82. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  83. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=844'
  84. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  85. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 844
  86. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '844'
  87. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=844
  88. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='844'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  89. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=844
  90. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  91. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='844'
  92. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=844
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  93. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=844
  94. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=844
  95. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=844
  96. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=844%'
      AND published=1
  97. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  98. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=844'
  99. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  100. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '844'
  101. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bình nóng lạnh gas owani'
  102. 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
  103. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1173'
  104. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1173%'
      AND published=1
  105. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  106. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  107. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  108. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=1173'
  109. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  110. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1173
  111. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1173'
  112. 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'
  113. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1173
  114. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1173'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1173
  116. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  117. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1173'
  118. 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
  119. 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
  120. 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
  121. 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
  122. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1173%'
      AND published=1
  123. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  124. 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'
  125. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  126. 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'
  127. 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
  128. 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'
  129. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=186%'
      AND published=1
  130. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  131. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  132. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  133. 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'
  134. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  135. 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
  136. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '186'
  137. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=186
  138. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='186'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=186
  140. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  141. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='186'
  142. 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
  143. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=186
  144. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=186
  145. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=186
  146. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=186%'
      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=186'
  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 = '186'
  151. 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'
  152. 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
  153. 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'
  154. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1008%'
      AND published=1
  155. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  156. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  157. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  158. 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'
  159. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  160. 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
  161. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1008'
  162. 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'
  163. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1008
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1008'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1008
  166. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1008'
  168. 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
  169. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1008
  170. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1008
  171. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1008
  172. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1008%'
      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=1008'
  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 = '1008'
  177. 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'
  178. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='NA-10GH'
  179. 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
  180. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='326'
  181. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=326%'
      AND published=1
  182. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  183. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  184. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  185. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=326'
  186. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  187. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 326
  188. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '326'
  189. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=326
  190. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='326'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  191. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=326
  192. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  193. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='326'
  194. 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
  195. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=326
  196. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=326
  197. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=326
  198. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=326%'
      AND published=1
  199. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  200. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=326'
  201. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  202. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '326'
  203. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='NA-06GH'
  204. 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
  205. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='324'
  206. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=324%'
      AND published=1
  207. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  208. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  209. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  210. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=324'
  211. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  212. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 324
  213. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '324'
  214. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=324
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='324'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=324
  217. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  218. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='324'
  219. 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
  220. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=324
  221. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=324
  222. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=324
  223. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=324%'
      AND published=1
  224. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  225. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=324'
  226. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  227. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '324'
  228. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='bnl002'
  229. 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
  230. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='187'
  231. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=187%'
      AND published=1
  232. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  233. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  234. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  235. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=187'
  236. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  237. SELECT p.product_id, x.category_id
      FROM jos_vm_product AS p
      LEFT JOIN jos_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 187
  238. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '187'
  239. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=187
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='187'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=187
  242. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  243. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='187'
  244. 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
  245. 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
  246. 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
  247. 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
  248. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=187%'
      AND published=1
  249. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  250. 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'
  251. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  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='NA-08GH'
  253. 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
  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`='325'
  255. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=325%'
      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=325'
  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 = 325
  262. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '325'
  263. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=325
  264. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='325'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  265. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=325
  266. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  267. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='325'
  268. 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
  269. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=325
  270. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=325
  271. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=325
  272. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=325%'
      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=325'
  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 = '325'
  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 lạnh gas Rinnai'
  278. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='740'
      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`='740'
  280. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=740%'
      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=740'
  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 = 740
  287. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '740'
  288. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=740
  289. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='740'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  290. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=740
  291. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  292. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='740'
  293. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=740
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  294. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=740
  295. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=740
  296. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=740
  297. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=740%'
      AND published=1
  298. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  299. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=740'
  300. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  301. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '740'
  302. 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'
  303. 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
  304. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='1150'
  305. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1150%'
      AND published=1
  306. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  307. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  308. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  309. 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'
  310. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  311. 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
  312. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1150'
  313. 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'
  314. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1150
  315. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1150'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  316. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1150
  317. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397547' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  318. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1150'
  319. 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
  320. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1150
  321. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1150
  322. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1150
  323. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1150%'
      AND published=1
  324. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  325. 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'
  326. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  327. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1150'
  328. 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'
  329. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='12'
      AND jos_vm_category.category_id='12'
  330. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  331. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  332. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=12&lang=vi&page=shop.browse'
  333. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  334. 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
  335. 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`='1007'
  336. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1007%'
      AND published=1
  337. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  338. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  339. 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=1007'
  340. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  341. 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 = 1007
  342. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1007'
  343. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=1007'
  344. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=844%'
      AND published=1
  345. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  346. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  347. 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=844'
  348. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  349. 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 = 844
  350. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '844'
  351. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='12'
  352. SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='843'
  353. SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='843'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  354. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=843
  355. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='843'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  356. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=843
  357. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  358. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='843'
  359. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=843
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  360. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=843
  361. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=843
  362. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=843
      AND `file_is_image`=1
      AND `file_published`=1
  363. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=843
  364. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  365. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=843
      AND `file_is_image`=0
      AND `file_published`=1
  366. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='843'
  367. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  368. SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  369. 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'
  370. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='843'
  371. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='843'
  372. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=843%'
      AND published=1
  373. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  374. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  375. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  376. 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=843'
  377. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  378. SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='843'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  379. SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='843'
  380. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=843
  381. SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='843'
  382. SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='843'
  383. SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='843'
  384. SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='843'
  385. SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='843'
      AND product_publish='Y'
  386. 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
  387. SELECT user_info_id
      FROM `jos_vm_user_info`
      WHERE user_id='0'
      AND address_type='BT'
  388. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  389. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&lang=vi&page=shop.cart'
  390. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  391. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  392. 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
  393. 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'
  394. 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
  395. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1173%'
      AND published=1
  396. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  397. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  398. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  399. 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'
  400. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  401. 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
  402. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1173'
  403. 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'
  404. 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
  405. 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
  406. 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
  407. 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
  408. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1173%'
      AND published=1
  409. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  410. 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'
  411. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  412. 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'
  413. 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
  414. 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'
  415. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1169%'
      AND published=1
  416. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  417. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  418. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  419. 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'
  420. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  421. 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
  422. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1169'
  423. 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'
  424. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1169
  425. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1169'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  426. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1169
  427. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  428. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1169'
  429. 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
  430. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1169
  431. 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'
  432. 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
  433. 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'
  434. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1168%'
      AND published=1
  435. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  436. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  437. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  438. 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'
  439. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  440. 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
  441. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1168'
  442. 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'
  443. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1168
  444. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1168'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  445. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1168
  446. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  447. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1168'
  448. 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
  449. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1168
  450. 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'
  451. 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
  452. 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'
  453. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1167%'
      AND published=1
  454. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  455. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  456. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  457. 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'
  458. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  459. 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
  460. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1167'
  461. 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'
  462. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1167
  463. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1167'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  464. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1167
  465. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  466. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1167'
  467. 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
  468. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1167
  469. 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'
  470. 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
  471. 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'
  472. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1166%'
      AND published=1
  473. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  474. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  475. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  476. 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'
  477. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  478. 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
  479. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1166'
  480. 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'
  481. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1166
  482. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1166'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  483. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1166
  484. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  485. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1166'
  486. 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
  487. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1166
  488. 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'
  489. 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
  490. 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'
  491. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1165%'
      AND published=1
  492. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  493. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  494. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  495. 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'
  496. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  497. 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
  498. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1165'
  499. 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'
  500. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1165
  501. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1165'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  502. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1165
  503. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  504. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1165'
  505. 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
  506. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1165
  507. 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'
  508. 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
  509. 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'
  510. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1164%'
      AND published=1
  511. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=165%'
      AND published=1
  512. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  513. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  514. 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'
  515. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  516. 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
  517. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1164'
  518. 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'
  519. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1164
  520. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1164'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  521. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1164
  522. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  523. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1164'
  524. 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
  525. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1164
  526. 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'
  527. 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
  528. 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'
  529. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1158%'
      AND published=1
  530. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  531. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  532. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  533. 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'
  534. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  535. 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
  536. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1158'
  537. 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'
  538. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1158
  539. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1158'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  540. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1158
  541. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  542. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1158'
  543. 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
  544. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1158
  545. 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'
  546. 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
  547. 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'
  548. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1157%'
      AND published=1
  549. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  550. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  551. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  552. 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'
  553. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  554. 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
  555. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1157'
  556. 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'
  557. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1157
  558. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1157'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  559. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1157
  560. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  561. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1157'
  562. 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
  563. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1157
  564. 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'
  565. 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
  566. 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'
  567. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1156%'
      AND published=1
  568. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  569. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  570. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  571. 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'
  572. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  573. 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
  574. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1156'
  575. 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'
  576. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1156
  577. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1156'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  578. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1156
  579. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  580. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1156'
  581. 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
  582. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1156
  583. 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'
  584. 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
  585. 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'
  586. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1155%'
      AND published=1
  587. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  588. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  589. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  590. 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'
  591. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  592. 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
  593. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1155'
  594. 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'
  595. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1155
  596. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1155'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  597. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1155
  598. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  599. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1155'
  600. 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
  601. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1155
  602. 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'
  603. 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
  604. 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'
  605. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1154%'
      AND published=1
  606. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  607. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  608. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  609. 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'
  610. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  611. 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
  612. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1154'
  613. 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'
  614. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1154
  615. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1154'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  616. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1154
  617. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  618. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1154'
  619. 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
  620. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1154
  621. 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'
  622. 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
  623. 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'
  624. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1153%'
      AND published=1
  625. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  626. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  627. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  628. 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'
  629. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  630. 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
  631. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1153'
  632. 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'
  633. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1153
  634. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1153'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  635. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1153
  636. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  637. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1153'
  638. 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
  639. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1153
  640. 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'
  641. 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
  642. 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'
  643. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1152%'
      AND published=1
  644. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  645. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  646. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  647. 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'
  648. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  649. 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
  650. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1152'
  651. 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'
  652. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1152
  653. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1152'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  654. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1152
  655. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  656. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1152'
  657. 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
  658. 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
  659. 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
  660. 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
  661. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1152%'
      AND published=1
  662. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  663. 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'
  664. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  665. 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'
  666. 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
  667. 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'
  668. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1151%'
      AND published=1
  669. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=162%'
      AND published=1
  670. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  671. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  672. 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'
  673. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  674. 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
  675. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1151'
  676. 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'
  677. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1151
  678. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1151'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  679. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1151
  680. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  681. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1151'
  682. 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
  683. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1151
  684. 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'
  685. 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
  686. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1150%'
      AND published=1
  687. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=12%'
      AND published=1
  688. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  689. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  690. 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'
  691. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  692. 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
  693. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1150'
  694. 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'
  695. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1150
  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ạt che ban công'
  697. 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
  698. 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'
  699. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1149%'
      AND published=1
  700. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=161%'
      AND published=1
  701. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  702. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  703. 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'
  704. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  705. 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
  706. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1149'
  707. 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'
  708. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1149
  709. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1149'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  710. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1149
  711. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  712. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1149'
  713. 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
  714. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1149
  715. 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'
  716. 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
  717. 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'
  718. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1148%'
      AND published=1
  719. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=161%'
      AND published=1
  720. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  721. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  722. 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'
  723. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  724. 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
  725. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1148'
  726. 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'
  727. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1148
  728. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1148'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  729. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1148
  730. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  731. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1148'
  732. 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
  733. 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
  734. 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
  735. 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
  736. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1148%'
      AND published=1
  737. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  738. 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'
  739. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  740. 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'
  741. 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
  742. 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'
  743. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1147%'
      AND published=1
  744. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=159%'
      AND published=1
  745. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  746. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  747. 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'
  748. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  749. 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
  750. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1147'
  751. 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'
  752. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1147
  753. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1147'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  754. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1147
  755. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  756. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1147'
  757. 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
  758. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1147
  759. 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'
  760. 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
  761. 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'
  762. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1146%'
      AND published=1
  763. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=160%'
      AND published=1
  764. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  765. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  766. 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'
  767. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  768. 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
  769. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1146'
  770. 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'
  771. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1146
  772. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1146'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  773. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1146
  774. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  775. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1146'
  776. 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
  777. 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
  778. 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
  779. 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
  780. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1146%'
      AND published=1
  781. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  782. 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'
  783. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  784. 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'
  785. 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
  786. 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'
  787. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1145%'
      AND published=1
  788. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=159%'
      AND published=1
  789. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  790. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  791. 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'
  792. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  793. 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
  794. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1145'
  795. 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'
  796. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1145
  797. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1145'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  798. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1145
  799. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  800. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1145'
  801. 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
  802. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1145
  803. 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'
  804. 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
  805. 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'
  806. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1144%'
      AND published=1
  807. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=160%'
      AND published=1
  808. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  809. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  810. 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'
  811. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  812. 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
  813. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1144'
  814. 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'
  815. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1144
  816. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1144'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  817. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1144
  818. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  819. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1144'
  820. 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
  821. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1144
  822. 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ổ'
  823. 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
  824. 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'
  825. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1143%'
      AND published=1
  826. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=160%'
      AND published=1
  827. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  828. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  829. 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'
  830. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  831. 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
  832. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '1143'
  833. 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'
  834. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1143
  835. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1143'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  836. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1143
  837. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506397548' OR start_date=0)
      AND (end_date>='1506382560' OR end_date=0)
      AND product_discount_id=discount_id
  838. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1143'
  839. 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
  840. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1143
  841. 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'
  842. 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
  843. 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`='1142'
  844. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1142%'
      AND published=1
  845. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=160%'
      AND published=1
  846. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  847. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  848. 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=1142'
  849. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  850. 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 = 1142
  851. SELECT product_id, product_sku, product_name
      FROM jos_vm_product