MySQL Query Error:Can't create/write to file '/tmp/#sql_5e0f_0.MYI' (Errcode: 28 - No space left on device)
select t.* from bird_filter_9 filter_9,bird_filter_180 filter_180,bird_filter_46 filter_46,bird_mobile t where 1 and filter_9.m_id=t.id and filter_180.m_id=t.id and filter_46.m_id=t.id and t.hide=0 and t.city='郑州' and t.province='河南' and t.cate=1 and t.hd='36' order by t.dateline desc LIMIT 0,40