Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
select Name, [UserId] as [User Link], max(badges.id) as Id, max(Date) as Date from badges inner join tags t on t.tagname = name group by userid, name having count(*) = 1 order by Id desc