Index: temp/trunk/data/conf/conf.php
===================================================================
--- temp/trunk/data/conf/conf.php	(revision 4870)
+++ temp/trunk/data/conf/conf.php	(revision 4871)
@@ -847,6 +847,6 @@
 		T3.rank AS rank1, T4.rank AS rank2, T3.class_id AS class_id1, T4.class_id AS class_id2,
 		stock, price01, price02, stock_unlimited, product_code
-		FROM (dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2
-		ON T1.classcategory_id1 = T2.classcategory_id)
+		FROM ( SELECT * FROM (dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2
+		ON T1.classcategory_id1 = T2.classcategory_id))
 		AS T3 LEFT JOIN dtb_classcategory AS T4
 		ON T3.classcategory_id2 = T4.classcategory_id) AS T5 LEFT JOIN dtb_products AS T6
Index: temp/trunk/html/frontparts/bloc/best5.php
===================================================================
--- temp/trunk/html/frontparts/bloc/best5.php	(revision 2812)
+++ temp/trunk/html/frontparts/bloc/best5.php	(revision 4871)
@@ -25,6 +25,6 @@
 	$objQuery = new SC_Query();
 	
-	$col = "A.*, B.name, B.price02_min, B.price01_min, B.main_list_image ";
-	$from = "dtb_best_products AS A INNER JOIN vw_products_allclass AS B ON A.product_id = B.product_id";
+	$col = "A.*, vw_products_allclass.name, vw_products_allclass.price02_min, vw_products_allclass.price01_min, vw_products_allclass.main_list_image ";
+	$from = "dtb_best_products AS A INNER JOIN vw_products_allclass ON A.product_id = vw_products_allclass.product_id";
 	$where = "status = 1";
 	$order = "rank";