The table '/home/mysql/data3146/tmp/#sql_2a29_0' is full:
SELECT s.userid,s.Ems_userid,s.fullname,s.nickname,s.logoimg,s.Ems_leibie, u.Ems_liulan,u.Ems_HyClass,u.Ems_Address, u.Ems_times,u.Ems_QQ,u.Ems_tel,u.Ems_Phone FROM ms_pxschool s,ms_studyemsuser u WHERE s.shenhe IN (3,4) AND s.City002="1670" AND u.userid=s.userid AND u.Ems_class="1" ORDER BY u.Ems_liulan DESC LIMIT 5