chalet resale for sale compound bungalows

select * from Mls where RecycleBin=0 and Active=1 and (EnItem like '%chalet resale for sale compound bungalows%' or ArItem like '%chalet resale for sale compound bungalows%') group by CompanyCode ORDER BY Google DESC,UpdateStamp DESC
Disk full (/tmp/#sql_e8c_31.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")