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