Moderator Candidate Score

8

Please login or register to vote for this query.

(click on this box to dismiss)

This tells you your moderator candidate score, as explained in http://meta.stackexchange.com/a/247138/164200.

Stack Overflow

Q&A for programmers

declare @user_id int = ##UserId##
declare @rep_score as int
declare @badge_score as int

select @rep_score = cast((Reputation / 1000) as int)
from Users
where Id = @user_id

if @rep_score > 20
  set @rep_score = 20

select distinct @badge_score = count(*)
from Badges
where UserId = @user_id
and Name in ('Civic Duty', 'Cleanup', 'Constituent', 'Convention', 'Copy Editor',
             'Deputy', 'Electorate', 'Enthusiast', 'Explainer', 'Investor',
             'Marshal', 'Organizer', 'Quorum', 'Refiner', 'Reviewer',
             'Sportsmanship', 'Steward', 'Strunk & White', 'Tag Editor',
             'Yearling')

print @badge_score + @rep_score

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results