Index: temp/trunk/html/admin/mail/htmlmail_select.php
===================================================================
--- temp/trunk/html/admin/mail/htmlmail_select.php	(revision 4608)
+++ temp/trunk/html/admin/mail/htmlmail_select.php	(revision 5253)
@@ -71,5 +71,5 @@
 	// Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
 	$col = "product_id, name, category_id, main_list_image, status, product_code, price01, stock, stock_unlimited";
-	$from = "vw_products_nonclass";
+	$from = "vw_products_nonclass AS noncls ";
 		
 	$objQuery = new SC_Query();
Index: temp/trunk/html/admin/customer/index.php
===================================================================
--- temp/trunk/html/admin/customer/index.php	(revision 4853)
+++ temp/trunk/html/admin/customer/index.php	(revision 5253)
@@ -200,5 +200,5 @@
 		case 'delete_all':
 			// ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü
-			$where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)";
+			$where = "product_id IN (SELECT product_id FROM vw_products_nonclass AS noncls WHERE $where)";
 			$sqlval['del_flg'] = 1;
 			$objQuery->update("dtb_products", $sqlval, $where, $arrval);
Index: temp/trunk/html/admin/products/product_rank.php
===================================================================
--- temp/trunk/html/admin/products/product_rank.php	(revision 4812)
+++ temp/trunk/html/admin/products/product_rank.php	(revision 5253)
@@ -64,5 +64,5 @@
 	$objQuery = new SC_Query();
 	$col = "product_id, name, main_list_image, rank, product_code";
-	$table = "vw_products_nonclass";
+	$table = "vw_products_nonclass AS noncls ";
 	$where = "del_flg = 0 AND category_id = ?";
 	
Index: temp/trunk/html/admin/products/index.php
===================================================================
--- temp/trunk/html/admin/products/index.php	(revision 4608)
+++ temp/trunk/html/admin/products/index.php	(revision 5253)
@@ -223,5 +223,5 @@
 		case 'delete_all':
 			// ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü
-			$where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)";
+			$where = "product_id IN (SELECT product_id FROM vw_products_nonclass AS noncls  WHERE $where)";
 			$sqlval['del_flg'] = 1;
 			$objQuery->update("dtb_products", $sqlval, $where, $arrval);
@@ -230,5 +230,5 @@
 			// Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
 			$col = "product_id, name, category_id, main_list_image, status, product_code, price01, price02, stock, stock_unlimited";
-			$from = "vw_products_nonclass";
+			$from = "vw_products_nonclass AS noncls ";
 
 			// ¹Ô¿ô¤Î¼èÆÀ
Index: temp/trunk/html/admin/products/product_select.php
===================================================================
--- temp/trunk/html/admin/products/product_select.php	(revision 4608)
+++ temp/trunk/html/admin/products/product_select.php	(revision 5253)
@@ -73,5 +73,5 @@
 	// Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
 	$col = "product_id, name, category_id, main_list_image, status, product_code, price01, stock, stock_unlimited";
-	$from = "vw_products_nonclass";
+	$from = "vw_products_nonclass AS noncls ";
 		
 	$objQuery = new SC_Query();
Index: temp/trunk/html/admin/products/product.php
===================================================================
--- temp/trunk/html/admin/products/product.php	(revision 5202)
+++ temp/trunk/html/admin/products/product.php	(revision 5253)
@@ -221,5 +221,5 @@
 	$objQuery = new SC_Query();
 	$col = "*";
-	$table = "vw_products_nonclass";
+	$table = "vw_products_nonclass AS noncls ";
 	$where = "product_id = ?";
 	$arrRet = $objQuery->select($col, $table, $where, array($product_id));
Index: temp/trunk/data/conf/conf.php
===================================================================
--- temp/trunk/data/conf/conf.php	(revision 5252)
+++ temp/trunk/data/conf/conf.php	(revision 5253)
@@ -780,5 +780,5 @@
 		FROM dtb_products_class WHERE classcategory_id1 = 0 AND classcategory_id2 = 0) 
 		AS T2
-		ON T1.product_id = T2.product_id_sub) vw_products_nonclass',
+		ON T1.product_id = T2.product_id_sub) ',
 	
 	"vw_products_allclass" => '