Index: /temp/trunk/html/admin/products/index_csv.php
===================================================================
--- /temp/trunk/html/admin/products/index_csv.php	(revision 1328)
+++ /temp/trunk/html/admin/products/index_csv.php	(revision 5259)
@@ -27,5 +27,5 @@
 	global $arrPRODUCTS_CVSCOL;
 
-	$from = "vw_product_class";
+	$from = "vw_product_class AS prdcls";
 	$cols = sfGetCommaList($arrOutputCols);
 	
Index: /temp/trunk/html/frontparts/bloc/best5.php
===================================================================
--- /temp/trunk/html/frontparts/bloc/best5.php	(revision 5258)
+++ /temp/trunk/html/frontparts/bloc/best5.php	(revision 5259)
@@ -31,5 +31,4 @@
 	
 	$arrBestProducts = $objQuery->select($col, $from, $where);
-	$objQuery->getlastquery();
 	return $arrBestProducts;
 }
Index: /temp/trunk/html/products/list.php
===================================================================
--- /temp/trunk/html/products/list.php	(revision 5255)
+++ /temp/trunk/html/products/list.php	(revision 5259)
@@ -352,5 +352,5 @@
 		$objQuery = new SC_Query();
 		$col = "product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited";
-		$table = "vw_product_class";
+		$table = "vw_product_class AS prdcls";
 		$where = "product_id = ?";
 		$objQuery->setorder("rank1 DESC, rank2 DESC");
Index: /temp/trunk/html/products/detail.php
===================================================================
--- /temp/trunk/html/products/detail.php	(revision 5255)
+++ /temp/trunk/html/products/detail.php	(revision 5259)
@@ -140,5 +140,5 @@
 $objQuery = new SC_Query();
 // DB¤«¤é¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë¡£
-$arrRet = $objQuery->select("*", "vw_products_allclass_detail", "product_id = ?", array($tmp_id));
+$arrRet = $objQuery->select("*", "vw_products_allclass_detail AS alldtl", "product_id = ?", array($tmp_id));
 $objPage->arrProduct = $arrRet[0];
 
Index: /temp/trunk/data/conf/conf.php
===================================================================
--- /temp/trunk/data/conf/conf.php	(revision 5256)
+++ /temp/trunk/data/conf/conf.php	(revision 5259)
@@ -840,5 +840,5 @@
 		FROM dtb_products_class GROUP BY product_id) AS T2
 		ON T1.product_id = T2.product_id_sub ) ) AS T3 LEFT JOIN (SELECT rank AS category_rank, category_id AS sub_category_id FROM dtb_category) AS T4
-		ON T3.category_id = T4.sub_category_id) vw_products_allclass_detail ',
+		ON T3.category_id = T4.sub_category_id) ',
 
 	"vw_product_class" => '
Index: /temp/trunk/data/lib/slib.php
===================================================================
--- /temp/trunk/data/lib/slib.php	(revision 5258)
+++ /temp/trunk/data/lib/slib.php	(revision 5259)
@@ -1754,4 +1754,6 @@
 			USING (product_id) WHERE A.category_id = ? AND A.del_flg = 0 AND status = 1 ORDER BY A.rank";
 	$arrItems = $conn->getAll($sql, array($category_id));
+	
+	sfprintr($arrItems);
 	return $arrItems;
 }