Top gold-badge earners and their gold badges

1

Please login or register to vote for this query.

(click on this box to dismiss)

Islam

Q&A for Muslims, experts in Islam, and those interested in learning more about Islam

select 
  users.DisplayName,
  a.number,
  Badges.Name
from
  Badges inner join Users on Badges.UserId = Users.Id
  inner join
  (select 
    DisplayName,
    Count(*) as number
  from
    Badges inner join Users on Badges.UserId = Users.Id
  where
    Name like ('Copy Editor') or
    Name like ('Electorate') or
    Name like ('Famous Question') or
    Name like ('Fanatic') or
    Name like ('Great Answer') or
    Name like ('Great Question') or
    Name like ('Legendary') or
    Name like ('Marshal') or
    Name like ('Populist') or
    Name like ('Publicist') or
    Name like ('Reversal') or
    Name like ('Stellar Question') or
    Name like ('Steward') or
    Name like ('Unsung Hero')
  group by
    DisplayName) a
  on a.displayname = users.displayname
   where
    Name like ('Copy Editor') or
    Name like ('Electorate') or
    Name like ('Famous Question') or
    Name like ('Fanatic') or
    Name like ('Great Answer') or
    Name like ('Great Question') or
    Name like ('Legendary') or
    Name like ('Marshal') or
    Name like ('Populist') or
    Name like ('Publicist') or
    Name like ('Reversal') or
    Name like ('Stellar Question') or
    Name like ('Steward') or
    Name like ('Unsung Hero')
order by a.number desc, a.displayname asc, badges.name asc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results