MySQL Query Error:Can't create/write to file '/tmp/#sql_14a8_0.MYI' (Errcode: 28 - No space left on device)
select t.* from bird_filter_170 filter_170,bird_filter_34 filter_34,bird_filter_40 filter_40,bird_filter_42 filter_42,bird_filter_167 filter_167,bird_mobile t where 1 and filter_170.m_id=t.id and filter_34.m_id=t.id and filter_40.m_id=t.id and filter_42.m_id=t.id and filter_167.m_id=t.id and t.hide=0 and t.cate=4 order by t.id DESC LIMIT 0,40