Gold badges (sans tag badges)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- copied from http://data.stackexchange.com/math/query/254031/ten-users-with-most-gold-badges
-- and updated list of gold badges (before I knew it was possible to edit other users' queries)
SELECT TOP 20 UserId AS [User Link], COUNT(*) 
FROM Badges
WHERE Name IN ('Socratic', 'Stellar Question', 'Great Question', 'Famous Question', 'Illuminator', 'Great Answer', 'Populist', 'Reversal', 'Unsung Hero', 'Fanatic', 'Legendary', 'Marshal', 'Constable', 'Sheriff', 'Steward', 'Copy Editor', 'Electorate', 'Publicist')
GROUP BY UserId
ORDER BY COUNT(*) DESC

Enter Parameters

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