Q&A about the site for developers and end users of the Sitecore CMS and multichannel marketing software
SELECT TOP 10 UserId AS [User Link], COUNT(*) FROM Badges WHERE Name IN ('Copy Editor', 'Electorate', 'Famous Question', 'Fanatic', 'Great Answer', 'Great Question', 'Legendary', 'Marshal', 'Populist', 'Publicist', 'Reversal', 'Stellar Question', 'Steward', 'Unsung Hero') GROUP BY UserId ORDER BY COUNT(*) DESC