Moderator candidates by last access date

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

Craft CMS Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results