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)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

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