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: http://stackoverflow.com/election/2

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- Possible moderator candidates
-- All Users which have the necessary reputation and Badges for
-- the 2011 Stack Overflow Moderator election: http://stackoverflow.com/election/2

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 = 'Pundit')
  --  and exists (Select Id from Badges b where b.UserId = Users.Id and b.Name = 'Yearling')
order by Id asc

view current version

edited jan 28 12 Jeremy Banks

created nov 7 11 sam.saffron