Index: temp/trunk/html/admin/mail/index.php
===================================================================
--- temp/trunk/html/admin/mail/index.php	(revision 4608)
+++ temp/trunk/html/admin/mail/index.php	(revision 4846)
@@ -135,5 +135,5 @@
 		// ¸¡º÷·ë²Ì¤Î¼èÆÀ
 		$objQuery = new SC_Query();
-		$from = "dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
+		$from = "dtb_customer_mail as mail LEFT OUTER JOIN dtb_customer as cus USING(email)";
 
 		// ¹Ô¿ô¤Î¼èÆÀ
@@ -151,5 +151,5 @@
 		$objQuery->setorder("customer_id DESC");
 		// ¸¡º÷·ë²Ì¤Î¼èÆÀ
-		$col = "customer_id,name01,name02,kana01,kana02,sex,email,tel01,tel02,tel03,pref,mail_flag";
+		$col = "cus.customer_id,cus.name01,cus.name02,cus.kana01,cus.kana02,cus.sex,cus.email,cus.tel01,cus.tel02,cus.tel03,cus.pref,mail.mail_flag";
 		$objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);
 
@@ -276,5 +276,5 @@
 function lfGetCustomerOrderId($keyword) {
 	if($keyword != "") {
-		$col = "customer_id, order_id";
+		$col = "dtb_order.customer_id, dtb_order.order_id";
 		$from = "dtb_order LEFT JOIN dtb_order_detail USING(order_id)";
 		$where = "product_code LIKE ? AND del_flg = 0";
Index: temp/trunk/data/class/SC_CustomerList.php
===================================================================
--- temp/trunk/data/class/SC_CustomerList.php	(revision 4608)
+++ temp/trunk/data/class/SC_CustomerList.php	(revision 4846)
@@ -30,5 +30,5 @@
 			$this->setWhere("status = 2");
 			
-			/*¡¡²ñ°÷¤Î¤ßÂоݤȤ¹¤ë
+			/*¡¡²ñ°÷¤Î¤ßÂоݤȤ¹¤ë¤¿¤áºï½ü
 			if(is_array($this->arrSql['customer'])) {
 				$tmp_where = "";