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 (965604,686466,302421,433352,1022635,391379,327996,529132,443355,516159,418371,437690,327987,236174,328042,465089,302288,448362,446748,499599,302231,514266,486616,495049,439260,624934,731074,466399,384651,327773) ORDER BY FIELD(mem.memberID,965604,686466,302421,433352,1022635,391379,327996,529132,443355,516159,418371,437690,327987,236174,328042,465089,302288,448362,446748,499599,302231,514266,486616,495049,439260,624934,731074,466399,384651,327773)
