SELECT Get_Txn_Search_Customer_Name(x.accountno) customer_name , x.* FROM ( SELECT y.* FROM ( SELECT t.TXNREFNO,t.TxnId,t.TXNDATE,t.TXNAMOUNT, a.ACCOUNTNUMBER,a.ACCOUNTTYPE,a.ACCOUNTNO FROM account a,amltransaction t WHERE t.ACCOUNTNO = a.ACCOUNTNO and t.TxnId IN ( SELECT t.TxnId FROM ( SELECT ca.CustomerId account_cust_id,a.ACCOUNTTYPE, concat( ifnull(c.FirstName,''),' ',ifnull(c.MiddleName,''),' ', ifnull(c.LastName,'')) customer_name, a.ACCOUNTNO, a.ACCOUNTNUMBER, c.CustomerNo FROM account a,customer c,customer_account ca WHERE ca.CustomerId = c.CustomerId and ca.ACCOUNTNO = a.ACCOUNTNO) ac, amltransaction t WHERE t.ACCOUNTNO = ac.ACCOUNTNO and t.branchcode = '003' and cast( t.TXNAMOUNT as DECIMAL(38,4)) >0.0 and upper(t.CURRENCY) LIKE 'PHP%' and t.TXNDATE >= STR_TO_DATE('03-JAN-2005','%d-%M-%Y') and t.TXNDATE <= STR_TO_DATE('18-DEC-2007','%d-%M-%Y') ) ) y ) x LIMIT 0,10