1 - Can't create/write to file '/tmp/#sql_209_0.MYI' (Errcode: 28 - No space left on device)
select mem.contact_visibility_status, mem.genderType, mem.yourName, mem.fax, mem.mobilePhone, mem.compName, mem.country_code, mem.address, mem.state, mem.phone, mem.paid_status, mem.memberID, mem.file_name, mem.city_code, mem.sub_city_code, mem.postalCode, mem.city_other, ccr.ccr_comp_logo as comp_logo, ccr.ccr_logo_image_status as logo_image_status, ccr.ccr_company_detail as travelDesc, mem.new_mobile_phone from car_coach_rental ccr, members mem where mem.memberID=ccr.ccr_member_id && mem.city_code = '10085' AND mem.activeStatus in ('Y','B') && ccr.ccr_status='Y' && mem.memberType='3' && mem.test_status='0' group by mem.memberID order by mem.paid_status desc,RAND()
