Index: branches/dev/data/class/SC_CustomerList.php
===================================================================
--- branches/dev/data/class/SC_CustomerList.php	(revision 11748)
+++ branches/dev/data/class/SC_CustomerList.php	(revision 11755)
@@ -283,5 +283,15 @@
 
 	function getListMailMagazine($is_mobile = false) {
-		
+			
+		$colomn = $this->getMailMagazineColumn($is_mobile);
+		$this->select = "
+			SELECT 
+				$colomn
+			FROM 
+				dtb_customer";
+		return $this->getSql(0);	
+	}
+	
+	function getMailMagazineColumn($is_mobile= false) {
 		if($is_mobile == true) {
 			$email_column = "dtb_customer.email_mobile as email";
@@ -290,7 +300,5 @@
 		}
 		
-		$this->select = "
-			SELECT 
-				dtb_customer.customer_id,
+		$column ="dtb_customer.customer_id,
 				dtb_customer.name01,
 				dtb_customer.name02,
@@ -303,8 +311,7 @@
 				dtb_customer.tel03,
 				dtb_customer.pref, 
-				dtb_customer.mailmaga_flg 
-			FROM 
-				dtb_customer";
-		return $this->getSql(0);	
+				dtb_customer.mailmaga_flg";
+				
+		return $column;
 	}
 	
