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/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/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;
 }