Wrongly awarded badges


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],
       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',
'Citizen Patrol',
'Strunk & White',
'Civic Duty',
'Peer Pressure',
group by UserId, Name, Class
having count(*) > 1
order by max(Date) desc, Count desc, UserId, Name

Enter Parameters

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