1 - Can't create/write to file '/tmp/#sql_8ed_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, travel.agentCatg, travel.comp_logo, travel.logo_image_status, travel.travelDesc, travel.logo_height, travel.logo_width, mem.new_mobile_phone from travels as travel inner join members as mem ON mem.memberID=travel.memberID where mem.activeStatus in ('Y','B') && travel.activeStatus='Y' && mem.memberType='1' && mem.memberID IN (9082,429032,516625,389470,474174,514823,253155,440391,440281,440277,440309,404109,423695,474190,481461,514826,253156,475276,512463,263350,512479,514824,514835,257477,475268,440276,429209,413806,475269,475288) ORDER BY FIELD(mem.memberID,9082,429032,516625,389470,474174,514823,253155,440391,440281,440277,440309,404109,423695,474190,481461,514826,253156,475276,512463,263350,512479,514824,514835,257477,475268,440276,429209,413806,475269,475288)
