Top 100 users with most gold badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

select top 100 b.userid, u.displayname, count(*) as gold
from badges b
inner join users u on u.id = b.userid
where name in ('Socratic', 'Stellar Question', 'Great Question', 'Famous Question', 'Illuminator', 'Great Answer', 'Populist', 'Reversal', 'Unsung Hero', 'Fanatic', 'Legendary', 'Marshal', 'Constable', 'Sheriff', 'Steward', 'Copy Editor', 'Electorate', 'Publicist')
group by b.userid, u.displayname
order by gold desc

Enter Parameters

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