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_170 filter_170,bird_filter_36 filter_36,bird_filter_43 filter_43,bird_mobile t where 1 and filter_170.m_id=t.id and filter_36.m_id=t.id and filter_43.m_id=t.id and t.hide=0 and t.city='郑州' and t.province='河南' and t.cate=4 order by t.dateline desc LIMIT 0,40