Users with largest number of "trackable" badges

1

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

SELECT TOP(##num?100##)
  u.Id AS [User Link],
  COUNT(DISTINCT b.Name) AS BadgeCount,
  activity = 'site://users/' + CAST(u.Id AS varchar) + '?tab=topactivity|Activity tab'
FROM Users u INNER JOIN Badges b ON b.UserId = u.Id
WHERE b.Name in (
'Altruist',
'Benefactor',
'Curious',
'Inquisitive',
'Socratic',
'Investor',
'Explainer',
'Promoter',
'Scholar',
'Student',
'Explainer',
'Refiner',
'Illuminator',
'Revival',
'Necromancer',
'Self-Learner',
'Teacher',
'Autobiographer',
'Commentator',
'Enthusiast',
'Fanatic',
'Mortarboard',
'Epic',
'Legendary',
'Citizen Patrol',
'Deputy',
'Marshal',
'Civic Duty',
'Cleanup',
'Critic',
'Custodian',
'Disciplined',
'Editor',
'Strunk & White',
'Copy Editor',
'Electorate',
'Excavator',
'Archaeologist',
'Organizer',
'Peer Pressure',
'Proofreader',
'Suffrage',
'Supporter',
'Tag Editor',
'Research Assistant',
'Taxonomist',
'Vox Populi'
)
GROUP BY u.Id
ORDER BY COUNT(DISTINCT b.Name) DESC

Enter Parameters

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