Index: /temp/trunk/html/frontparts/bloc/best5.php
===================================================================
--- /temp/trunk/html/frontparts/bloc/best5.php	(revision 5257)
+++ /temp/trunk/html/frontparts/bloc/best5.php	(revision 5258)
@@ -29,5 +29,4 @@
 	$where = "status = 1";
 	$order = "rank";
-	$objQuery->setorder($order);
 	
 	$arrBestProducts = $objQuery->select($col, $from, $where);
Index: /temp/trunk/html/admin/products/product.php
===================================================================
--- /temp/trunk/html/admin/products/product.php	(revision 5253)
+++ /temp/trunk/html/admin/products/product.php	(revision 5258)
@@ -167,5 +167,5 @@
 
 		if($_POST[$keyname] != "" && $_POST[$delkey] != 1) {
-			$arrRet = $objQuery->select("main_list_image, product_code_min, name", "vw_products_allclass", "product_id = ?", array($_POST[$keyname])); 
+			$arrRet = $objQuery->select("main_list_image, product_code_min, name", "vw_products_allclass AS allcls", "product_id = ?", array($_POST[$keyname])); 
 			$arrRecommend[$i] = $arrRet[0];
 			$arrRecommend[$i]['product_id'] = $_POST[$keyname];
Index: /temp/trunk/html/admin/mail/preview.php
===================================================================
--- /temp/trunk/html/admin/mail/preview.php	(revision 1328)
+++ /temp/trunk/html/admin/mail/preview.php	(revision 5258)
@@ -42,5 +42,5 @@
 	
 	// ¥á¥¤¥ó¾¦ÉʤξðÊó¼èÆÀ
-	$sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass WHERE product_id = ?";
+	$sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?";
 	$main = $conn->getAll($sql, array($objPage->list_data["main_product_id"]));
 	$objPage->list_data["main"] = $main[0];
Index: /temp/trunk/html/admin/mail/inc_mailmagazine.php
===================================================================
--- /temp/trunk/html/admin/mail/inc_mailmagazine.php	(revision 4608)
+++ /temp/trunk/html/admin/mail/inc_mailmagazine.php	(revision 5258)
@@ -83,10 +83,10 @@
 
 	// ¥á¥¤¥ó¾¦ÉʤξðÊó¼èÆÀ
-	$sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass WHERE product_id = ?";
+	$sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?";
 	$main = $conn->getAll($sql, array($list_data["main_product_id"]));
 	$list_data["main"] = $main[0];
 
 	// ¥µ¥Ö¾¦ÉʤξðÊó¼èÆÀ
-	$sql = "SELECT product_id, name, main_list_image, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass WHERE product_id = ?";
+	$sql = "SELECT product_id, name, main_list_image, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?";
 	$k = 0;
 	$l = 0;
Index: /temp/trunk/data/lib/slib.php
===================================================================
--- /temp/trunk/data/lib/slib.php	(revision 5204)
+++ /temp/trunk/data/lib/slib.php	(revision 5258)
@@ -1751,5 +1751,5 @@
 	// ´û¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ëÆâÍƤò¼èÆÀ¤¹¤ë
 	$sql = "SELECT name, main_image, main_list_image, price01_min, price01_max, price02_min, price02_max, point_rate,
-			 A.product_id, A.comment FROM dtb_best_products as A LEFT JOIN vw_products_allclass as B 
+			 A.product_id, A.comment FROM dtb_best_products as A LEFT JOIN vw_products_allclass AS allcls 
 			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));