Number of users who can run for mod on SO

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

SELECT u.*
FROM Users u
JOIN Badges b1 ON u.Id = b1.UserId AND b1.Name = 'Civic Duty'
JOIN Badges b2 ON u.Id = b2.UserId AND b2.Name = 'Strunk & White'
JOIN Badges b3 ON u.Id = b3.UserId AND b3.Name = 'Deputy'
JOIN Badges b4 ON u.Id = b4.UserId AND b4.Name = 'Convention'
WHERE u.Reputation >= 3000;

Enter Parameters

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