Index: temp/trunk/data/class/SC_CustomerList.php
===================================================================
--- temp/trunk/data/class/SC_CustomerList.php	(revision 4847)
+++ temp/trunk/data/class/SC_CustomerList.php	(revision 4849)
@@ -258,5 +258,20 @@
 
 	function getListMailMagazine() {
-		$this->select = "SELECT customer_id,name01,name02,kana01,kana02,sex,email,tel01,tel02,tel03,pref, mail_flag FROM dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
+		$this->select = "
+			SELECT 
+				dtb_customer.customer_id,
+				dtb_customer.name01,
+				dtb_customer.name02,
+				dtb_customer.kana01,
+				dtb_customer.kana02,
+				dtb_customer.sex,
+				dtb_customer.email,
+				dtb_customer.tel01,
+				dtb_customer.tel02,
+				dtb_customer.tel03,
+				dtb_customer.pref, 
+				dtb_customer_mail.mail_flag 
+			FROM 
+				dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
 		return $this->getSql(0);	
 	}
Index: temp/trunk/html/admin/mail/index.php
===================================================================
--- temp/trunk/html/admin/mail/index.php	(revision 4847)
+++ temp/trunk/html/admin/mail/index.php	(revision 4849)
@@ -369,4 +369,6 @@
 	global $conn;
 	global $arrSearchColumn;
+	
+	$objQuery = new SC_Query();
 		
 	$objSelect = new SC_CustomerList( lfConvertParam($arrData, $arrSearchColumn), "magazine" );
@@ -375,5 +377,6 @@
 	
 	$dtb_send_history = array();
-	$dtb_send_history["send_id"] = $conn->getOne("SELECT NEXTVAL('dtb_send_history_send_id_seq')");
+//	$dtb_send_history["send_id"] = $conn->getOne("SELECT NEXTVAL('dtb_send_history_send_id_seq')");
+	$dtb_send_history["send_id"] = $objQuery->nextval('dtb_send_history', 'send_id');
 	$dtb_send_history["mail_method"] = $arrData['mail_method'];
 	$dtb_send_history["subject"] = $arrData['subject'];