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.

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

-- 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