SELECT DisplayName AS Name, COUNT(Badges.Name) AS Badges ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

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') AND
    Users.Id = 22656
    GROUP BY DisplayName
ORDER BY Badges DESC

Enter Parameters

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