Users with most badges of a certain name

1

Please login or register to vote for this query.

(click on this box to dismiss)

View users who have earned the most badges of a given name.

Stack Overflow

Q&A for professional and enthusiast programmers

select top 1000
  UserId as [User Link],
  count(*) as [Badge Count]
from Badges
where Name = ##BadgeName:string?Revival##
-- BadgeName: Badge Name (case sensitive):   "Show users with the highest number of this badge."
group by UserId
order by [Badge Count] desc;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results