56,687
社区成员
发帖
与我相关
我的任务
分享
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