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
fork query

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
Results Messages Graph Execution Plan
Download CSV Download XML
:records rows returned in :time ms:cached