10

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.

Q&A for programming puzzle enthusiasts and code golfers

-- 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 exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Civic Duty')
   and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Strunk & White')
   and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Deputy')
   and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Convention')
   and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Yearling')
order by DisplayName asc

fork query

created nov 7 11 random