SELECT id,nickname,sex,grade,photo_s,photo_f,areatitle,birthday,job,pay,love,heigh,photo_ifshow FROM zeai_user b WHERE kind<>4 AND flag=1 AND photo_f=1 ORDER BY refresh_time DESC LIMIT 10