Users with Gold Badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT DisplayName AS Name, COUNT(Badges.Name) AS Badges FROM Users,Badges 
 WHERE Users.Id = Badges.UserId AND 
  Badges.Name IN 
   ('Copy Editor',
    'Electorate', 
    'Famous Question', 
    'Fanatic', 
    'Great Answer', 
    'Great Question', 
    'Legendary', 
    'Marshal', 
    'Populist', 
    'Publicist', 
    'Reversal', 
    'Stellar Question',     
    'Steward', 
    'Unsung Hero') 
    GROUP BY DisplayName
ORDER BY Badges DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached