Index: branches/dev/data/lib/slib.php
===================================================================
--- branches/dev/data/lib/slib.php	(revision 11460)
+++ branches/dev/data/lib/slib.php	(revision 11577)
@@ -1773,7 +1773,7 @@
 /* ²ñ°÷¤Î¥á¥ë¥Þ¥¬ÅÐÏ¿¤¬¤¢¤ë¤«¤É¤¦¤«¤Î¥Á¥§¥Ã¥¯(²¾²ñ°÷¤ò´Þ¤Þ¤Ê¤¤) */
 function sfCheckCustomerMailMaga($email) {
-	$col = "T1.email, T1.mail_flag, T2.customer_id";
-	$from = "dtb_customer_mail AS T1 LEFT JOIN dtb_customer AS T2 ON T1.email = T2.email";
-	$where = "T1.email = ? AND T2.status = 2";
+	$col = "email, mailmaga_flg, customer_id";
+	$from = "dtb_customer";
+	$where = "email = ? AND status = 2";
 	$objQuery = new SC_Query();
 	$arrRet = $objQuery->select($col, $from, $where, array($email));
