select count(*), u.user_idfrom aaa upjoin user uon u.user_id=up.user_idwhere accepted=1group by user_idhaving count(*)>1 order by 1
No comments:
Post a Comment