Notice: Undefined index: HTTP_REFERER in /home/bepgasvi/public_html/sieuthibepgasgiare.vn/plugins/system/xcalendar.php on line 200
mua bếp ga âm tặng mày khử mùi với giá chỉ 5900k | bếp gas Khuyến mại trọn bộ | Bếp Gas Việt | Bếp Gas | Bếp Gas Dương | Bếp Gas Âm | Bếp Gas gi


Danh mục sản phẩm


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


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

Trang chủ >> Sản phẩm >> bếp gas Khuyến mại trọn bộ >> mua bếp ga âm tặng mày khử mùi với giá chỉ 5900k

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

mua bếp ga âm tặng mày khử mùi với giá chỉ 5900k

Giá: 7.900.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

mua bếp ga âm tặng mày khử mùi với giá chỉ 5900k

Máy hút mùi cao cấp SUNHOUSE (vỏ Inox) SHB-6628

Mã sản phẩm: SHB-6628
Kiểu dáng/Model: SHB-6628
Kích thước: 700 x 500x 930 mm
Giá bán: 5.900.000  VND
Khuyến mại: Giá bán:(chưa bao gồm VAT)

- Kích thước về sản phẩm: 700 x 500 x 930 mm
- Thông tin về sản phẩm:
+ Điện thế 220V~50Hz, tổng công suất motor: 196W, công suất đèn: 2W x 2)
+ Màu sắc: Inox
+ An toàn, thuận tiện trong sử dụng
+ Motor siêu bền 2 tốc độ
+ Chức năng: hút & khử mùi

Bếp gas âm Rinnai RVB - 2BG(B)

Xuất xứ: Việt Nam

Mã sản phẩm

 

Bếp gas âm RVB-2BG(B)

Hãng sản xuất

bếp gas âm Rinnai

Loại sản phẩm

Bếp gas âm kính

Số bếp nấu

02

Số vòng lửa

02 + 02

Mặt bếp

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

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

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

Pin 1,5V

Chế độ hẹn giờ

Không

Kiềng

Kiềng thép tráng men chống gỉ

Bộ chia lửa

Patened hợp kim

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

Kính đen

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

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

0,38kg/h/lò

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

720 x 420mm

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

675 x 365mm


Last Updated: Monday, 25 September 2017 02:46

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 nay74
mod_vvisit_counterTất cả3330267

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

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

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

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

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

Điện thoại : 0436615399

Di động: 01643767888

Website : sieuthibepgasgiare.vn

 

 

•Thông tin cá nhân•

Application afterLoad: 0.000 seconds, 0.38 MB
Application afterInitialise: 0.075 seconds, 7.05 MB
Application afterRoute: 0.140 seconds, 10.90 MB
Application afterDispatch: 0.548 seconds, 21.74 MB
Application afterRender: 4.174 seconds, 37.45 MB

•Bộ nhớ sử dụng•

39650488

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'm3mmo69vjiv5tl6epaa3igvc13'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1506306678' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'm3mmo69vjiv5tl6epaa3igvc13'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'm3mmo69vjiv5tl6epaa3igvc13','1506307578','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT MAX(TIME)  
      FROM jos_vvcounter_logs
  8. SELECT *
      FROM jos_migration_backlinks
      WHERE url LIKE 'vmchk/bep-gas-khuyen-mai-tron-bo/mua-bep-ga-am-tang-may-khu-mui-voi-gia-chi-5900k.html%' OR sefurl LIKE 'vmchk/bep-gas-khuyen-mai-tron-bo/mua-bep-ga-am-tang-may-khu-mui-voi-gia-chi-5900k.html%'
  9. SELECT oldurl, newurl
      FROM jos_redirection
      WHERE oldurl = 'vmchk/bep-gas-khuyen-mai-tron-bo/mua-bep-ga-am-tang-may-khu-mui-voi-gia-chi-5900k.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=78&flypage=flypage.tpl&lang=vi&limitstart=0&page=shop.product_details&product_id=729&vmcchk=1'
      AND `oldurl` = 'vmchk/bep-gas-khuyen-mai-tron-bo/mua-bep-ga-am-tang-may-khu-mui-voi-gia-chi-5900k.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`=729
      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='729'
      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 != 729
      AND (jos_vm_product_category_xref.category_id = '78'
      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='BB VN'
  24. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='626'
      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`='626'
  26. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=626%'
      AND published=1
  27. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      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=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=626'
  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 = 626
  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 = '626'
  35. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=626
  36. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='626'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  37. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=626
  38. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  39. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='626'
  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=626
      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=626
  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`=626
  45. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=626
  46. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=626%'
      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=626'
  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 = '626'
  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ộ bếp đôi Rinnai'
  52. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='620'
      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`='620'
  54. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=620%'
      AND published=1
  55. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      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=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=620'
  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 = 620
  61. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '620'
  62. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=620
  63. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='620'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  64. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=620
  65. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  66. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='620'
  67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=620
      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=620
  69. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=620
  70. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=620
  71. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=620%'
      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=620'
  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 = '620'
  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='mua bếp gas âm canzy tặng bộ binh van dây'
  77. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='730'
      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`='730'
  79. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=730%'
      AND published=1
  80. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      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=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=730'
  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 = 730
  86. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '730'
  87. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=730
  88. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='730'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  89. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=730
  90. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  91. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='730'
  92. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=730
      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=730
  94. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=730
  95. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=730
  96. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=730%'
      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=730'
  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 = '730'
  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='BB RV-150G'
  102. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='625'
      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`='625'
  104. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=625%'
      AND published=1
  105. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      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=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=625'
  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 = 625
  111. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '625'
  112. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=625
  113. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='625'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  114. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=625
  115. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  116. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='625'
  117. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=625
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  118. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=625
  119. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=625
  120. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=625
  121. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=625%'
      AND published=1
  122. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  123. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=625'
  124. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  125. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '625'
  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ộ bếp gas đơn kính'
  127. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='688'
      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`='688'
  129. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=688%'
      AND published=1
  130. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      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=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=688'
  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 = 688
  136. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '688'
  137. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=688
  138. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='688'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=688
  140. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  141. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='688'
  142. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=688
      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=688
  144. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=688
  145. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=688
  146. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=688%'
      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=688'
  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 = '688'
  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ộ bếp gas đôi mặt kính Dynamic'
  152. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='686'
      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`='686'
  154. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=686%'
      AND published=1
  155. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      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=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=686'
  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 = 686
  161. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '686'
  162. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=686
  163. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='686'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=686
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='686'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=686
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=686
  169. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=686
  170. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=686
  171. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=686%'
      AND published=1
  172. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  173. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=686'
  174. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  175. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '686'
  176. 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ộ bếp gas Rinnai nhật'
  177. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='725'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  178. 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`='725'
  179. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=725%'
      AND published=1
  180. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      AND published=1
  181. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  182. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  183. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=725'
  184. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  185. 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 = 725
  186. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '725'
  187. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=725
  188. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='725'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  189. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=725
  190. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  191. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='725'
  192. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=725
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  193. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=725
  194. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=725
  195. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=725
  196. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=725%'
      AND published=1
  197. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  198. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=725'
  199. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  200. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '725'
  201. 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ộ bếp ga paloma'
  202. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='734'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  203. 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`='734'
  204. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=734%'
      AND published=1
  205. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      AND published=1
  206. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  207. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  208. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=734'
  209. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  210. 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 = 734
  211. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '734'
  212. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=734
  213. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='734'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  214. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=734
  215. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  216. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='734'
  217. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=734
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  218. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=734
  219. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=734
  220. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=734
  221. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=734%'
      AND published=1
  222. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  223. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=734'
  224. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  225. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '734'
  226. 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ộ bếp gas Rinnai RJ-8600FE'
  227. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='727'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  228. 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`='727'
  229. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=727%'
      AND published=1
  230. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      AND published=1
  231. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  232. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  233. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=727'
  234. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  235. 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 = 727
  236. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '727'
  237. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=727
  238. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='727'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  239. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=727
  240. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  241. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='727'
  242. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=727
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  243. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=727
  244. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=727
  245. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=727
  246. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=727%'
      AND published=1
  247. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  248. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=727'
  249. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  250. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '727'
  251. 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ộ bếp đôi dương kính'
  252. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='619'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  253. 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`='619'
  254. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=619%'
      AND published=1
  255. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      AND published=1
  256. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  257. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  258. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=619'
  259. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  260. 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 = 619
  261. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '619'
  262. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=619
  263. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='619'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  264. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=619
  265. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  266. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='619'
  267. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=619
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  268. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=619
  269. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=619
  270. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=619
  271. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=619%'
      AND published=1
  272. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  273. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=619'
  274. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  275. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '619'
  276. SELECT product_id, product_name, product_parent_id, product_thumb_image, product_full_image,product_s_desc,product_desc
      FROM jos_vm_product
      WHERE product_sku='Bếp ga đôi liên doanh Việt-Nhật'
  277. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='621'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  278. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

                           
      WHERE `jos_vm_product`.`product_id`='621'
  279. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=621%'
      AND published=1
  280. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=78%'
      AND published=1
  281. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  282. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  283. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&category_id=78&flypage=flypage.tpl&lang=vi&page=shop.product_details&product_id=621'
  284. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  285. 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 = 621
  286. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '621'
  287. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=621
  288. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='621'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  289. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=621
  290. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1506307578' OR start_date=0)
      AND (end_date>='1506296160' OR end_date=0)
      AND product_discount_id=discount_id
  291. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='621'
  292. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=621
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  293. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=621
  294. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=621
  295. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=621
  296. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=621%'
      AND published=1
  297. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  298. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=56&func=cartAdd&lang=vi&page=shop.cart&product_id=621'
  299. SELECT name, link,id
      FROM jos_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  300. SELECT product_id, product_sku, product_name
      FROM jos_vm_product
     
      WHERE product_id = '621'
  301. 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ộ bếp gas đơn sinh viên'
  302. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='623'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
  303. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

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

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