select count(*) as PleaseAcceptCount, UserId, max(`CreationDate`) as LastOffense from socomments where UserId is not NULL and `Text` like '%accept%' group by UserId order by count(*) desc