Memory limit of 10240 KB exceeded for buffered query

Good day, I'm trying to `running a queries` for my `searching` 

but i get this result `<p>Error Number: IMSSP/-59</p><p>Memory limit of 10240 KB exceeded for buffered query</p>`

Here it's my query 

   

Code:

SELECT * From transaksi a 
    left join Outlet b on a.Outlet = b.OutletCode
    left join area c on b.areacode = c.areacode where b.BrandCode like  '%AR-1%'
    and b.areacode like '%%' and b.OutletCode like '%%' and tanggal 
    between '2016-03-01' and '2016-07-31'

from my query above i get `16046 rows`. when i try to do some other search that only showing `10 rows`, that error not showing and everything is working fine.

Here it's my fullscript.

   

Code:

function show_it()
    {
    extract(populateform());
    if($date_search == "")
    {
    unset($date_search);
    }
    if(isset($date_search)){
    $explode = explode('-',$date_search);
    $start_date = inggris_date($explode[0]);
    $end_date = inggris_date($explode[1]);
    $result = $this->modelmodel->showdata("SELECT * From transaksi a 
    left join Outlet b on a.Outlet = b.OutletCode
    left join area c on b.areacode = c.areacode where b.BrandCode like  '%$tipenya%'
    and b.areacode like '%$area%' and b.OutletCode like '%$outlet%' and tanggal 
    between '$start_date' and '$end_date'
    ");
    }else{
    $result = $this->modelmodel->showdata("SELECT * From transaksi a 
    left join Outlet b on a.Outlet = b.OutletCode
    left join area c on b.areacode = c.areacode where b.BrandCode like '%$tipenya%'
    and b.areacode like '%$area%' and b.OutletCode like '%$outlet%' 
    ");
    }
    }

Any solution? sorry for my bad english. I'm using Sqlsrv