1 - Can't create/write to file '/tmp/#sql_8ed_0.MYI' (Errcode: 28 - No space left on device)

select p.*, m.file_name, m.memberID, m.compName, m.yourName, m.paid_status, m.new_mobile_phone, m.contact_visibility_status, m.mobilePhone, m.phone, m.fax, m.memberType, m.agent_rating, i.pkg_id, i.image, i.title, i.default_img_slno, i.small_height, i.small_width, i.big_height, i.big_width from packagetbl p inner join members m on m.memberID = p.member_id and m.activeStatus in ('Y','B') left join pkg_image i on i.pkg_id = p.slno where p.activeStatus = 'Y' && m.test_status='0' && p.slno IN (71458,125364,187839,163393,107095,1851,147314,197625,168566,177764,39237,138872,77492,185065,149674,183479,32591,183597,139532,142792,140183,154036,64000,136834,183380,174139,178650,18943,147408,90468,158193,127806,107457,130314,163078,8080,109406,75898,141786,97196,195554,154667,117347,84835,75236,127664,151717,138051,134620,112569) group by p.slno order by FIELD(p.slno,71458,125364,187839,163393,107095,1851,147314,197625,168566,177764,39237,138872,77492,185065,149674,183479,32591,183597,139532,142792,140183,154036,64000,136834,183380,174139,178650,18943,147408,90468,158193,127806,107457,130314,163078,8080,109406,75898,141786,97196,195554,154667,117347,84835,75236,127664,151717,138051,134620,112569)

[TEP STOP]