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 (529900,394205,533851,533254,533227,531462,536439,524207,532985,523397) ORDER BY FIELD(mem.memberID,529900,394205,533851,533254,533227,531462,536439,524207,532985,523397)
