56,872
社区成员




select *
from user a inner join user_state b on a.id=b.userid
where not exists (select 1 from user_state where userid=b.userid and updatetime>b.updatetime)
select *
from (
select *
from user,user_state
where user_state.userid = user.id
order by user.id,updatetime desc
) t
group by user.id