56,677
社区成员
发帖
与我相关
我的任务
分享
select DISTINCT a.nickname,a.gender,p.picture_url,a.siignature,a.access_amount,a.interview_state,a.name_id,a.pole_number,IFNULL(a.user_interview,0)
from user a,picture p where a.name_id in (select coverclick_name_id from user_click_user where click_name_id='user2016042621340718621825669800' and coverclick_name_id<>'usergolvon' and
coverclick_name_id<>'user2016042621340718621825669800' order by click_time desc) and a.examine_state=1 and a.photo = p.picture_id
order by a.name_id ASC limit 0,10