Index: /temp/trunk/html/frontparts/bloc/best5.php
===================================================================
--- /temp/trunk/html/frontparts/bloc/best5.php	(revision 4873)
+++ /temp/trunk/html/frontparts/bloc/best5.php	(revision 4874)
@@ -26,5 +26,5 @@
 	
 	$col = "A.*, name, price02_min, price01_min, main_list_image ";
-	$from = "dtb_best_products AS A INNER JOIN vw_products_allclass using(product_id)";
+	$from = "dtb_best_products AS A INNER JOIN vw_products_allclass ON using(product_id)";
 	$where = "status = 1";
 	$order = "rank";
Index: /temp/trunk/data/conf/conf.php
===================================================================
--- /temp/trunk/data/conf/conf.php	(revision 4872)
+++ /temp/trunk/data/conf/conf.php	(revision 4874)
@@ -783,5 +783,5 @@
 	
 	"vw_products_allclass" => '
-		((SELECT
+		(SELECT
         product_id,
         product_code_min,
@@ -816,5 +816,5 @@
     FROM
         dtb_products AS T1 RIGHT JOIN (SELECT product_id AS product_id_sub, MIN(product_code) AS product_code_min, MAX(product_code) AS product_code_max, MIN(price01) AS price01_min, MAX(price01) AS price01_max, MIN(price02) AS price02_min, MAX(price02) AS price02_max, MIN(stock) AS stock_min, MAX(stock) AS stock_max, MIN(stock_unlimited) AS stock_unlimited_min, MAX(stock_unlimited) AS stock_unlimited_max FROM dtb_products_class GROUP BY product_id) AS T2 ON T1.product_id = T2.product_id_sub
-    ) vw_products_allclass )',
+    ) vw_products_allclass ',
 
 	"vw_products_allclass_detail" => '