Wrongly awarded badges

1

Please login or register to vote for this query.

(click on this box to dismiss)

Badges people should not have

Stack Overflow

Q&A for professional and enthusiast programmers

select UserId as [User Link],
       Name,
       CASE WHEN Class = 3 THEN 'Bronze'
            WHEN Class = 2 THEN 'Silver'
            WHEN Class = 1 THEN 'Gold' END as Class,
       max(Date) as [Latest Award],
       Count(*) as Count
from Badges
where Name in ('Teacher',
'Student',
'Editor',
'Cleanup',
'Organizer',
'Supporter',
'Critic',
'Citizen Patrol',
'Autobiographer',
'Scholar',
'Taxonomist',
'Strunk & White',
'Self-Learner',
'Generalist',
'Hacker',
'Beta',
'Commentator',
'Civic Duty',
'Disciplined',
'Peer Pressure',
'Tumbleweed',
'Enthusiast',
'Fanatic',
'Pundit',
'Mortarboard',
'Epic',
'Legendary',
'Electorate')
group by UserId, Name, Class
having count(*) > 1
order by max(Date) desc, Count desc, UserId, Name

Enter Parameters

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