0

Please login or register to vote for this query.

(click on this box to dismiss)

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

view current version

edited jan 30 13

created jan 30 13 jon.doe9977