Users eligible for 2011 Stack Overflow moderator elections

0

Please login or register to vote for this query.

(click on this box to dismiss)

All users which have the necessary reputation and badges for the 2011 Stack Overflow Moderator election taking part at the end of the year.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Users eligible for 2011 Stack Overflow moderator elections
-- All users which have the necessary reputation and badges for the 2011 Stack Overflow Moderator election taking part at the end of the year.

Select Id, DisplayName, Reputation
 from Users
 where Reputation > 3000
 and Id IN
 (
 SELECT b.UserId
 FROM Badges b
 WHERE b.Name IN ('Civic Duty', 
                  'Strunk & White',
                  'Deputy',
                  'Convention',
                  'Yearling')
 GROUP BY b.UserId
 HAVING COUNT(DISTINCT b.Name) = 5
 )
order by DisplayName asc

Enter Parameters

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