Index: branches/dev/data/class/SC_CustomerList.php
===================================================================
--- branches/dev/data/class/SC_CustomerList.php	(revision 12489)
+++ branches/dev/data/class/SC_CustomerList.php	(revision 12490)
@@ -214,7 +214,7 @@
         	    if($domain==3){
         		    if($this->arrSql['mail_type']==1){
-            	        $sql_where .= "dtb_customer.email LIKE ? " ;
+            	        $this->setWhere( "email LIKE ? ");
         	    }elseif($this->arrSql['mail_type']==2){
-        		        $sql_where .= "dtb_customer.email_mobile LIKE ? " ;
+        		        $this->setWhere( "email_mobile LIKE ? ");
         	        }
         	    }
@@ -222,7 +222,7 @@
         	    if($domain==2){
         		    if($this->arrSql['mail_type']==1){
-            	        $sql_where .= "email NOT LIKE ? " ;
+            	        $this->setWhere( "email NOT LIKE ? ");
         	    }elseif($this->arrSql['mail_type']==2){
-        		        $sql_where .= "email_mobile NOT LIKE ? " ;
+        		        $this->setWhere( "email_mobile NOT LIKE ? ");
         	        }
         	    }
@@ -230,5 +230,4 @@
             }
             print_r($searchDomain);
-            $this->setWhere($sql_where);
         }