56,940
社区成员




select username
form (
select if(fromUserid=(select id form p where username='TestUser'),toUserid,fromUserid) as uid ,max(sendtime) as msendtime
from message
where (fromuser=(select id form p where username='TestUser') or toUserid=(select id form p where username='TestUser') )
group by if(fromUserid=(select id form p where username='TestUser'),toUserid,fromUserid)
) a, p
where a.uid=p.id
order by msendtime desc
limit 10