Suggested Edits Reputation League

1

Please login or register to vote for this query.

(click on this box to dismiss)

This tool tells the top users of a SE site except for its Meta counterpart (if it exists) in terms of the reputation earned from suggesting edits. The following rules in the specified order are used to determine the rank of a user: 1. Higher the number of Approved Suggestions on visible posts, lower the rank. 2. Higher the Approval Rate, lower the rank. 3. Higher the Overall Reputation, lower the rank. 4. Older the user, lower the rank.

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

-- Approval Rate is defined as the number of Approved Suggestions on visible posts
-- divided by the number of Rejected Suggestions (whatever may be the reason) on visible posts
-- times 100%.
select top ##n:int?100##
row_number() over(order by count(se.ApprovalDate) desc,
count(se.ApprovalDate)*100.0/(count(se.ApprovalDate)+count(se.RejectionDate)+.00001) desc,
u.Reputation desc) as Rank, --zeroth column
u.Id as [User Link], --first column
count(se.ApprovalDate) as '# Approved Suggestions', --second column
case
when count(se.ApprovalDate)*2 > 1000 then 1000
else count(se.ApprovalDate)*2
end as 'Reputation From Suggesting Edits', --third column
concat(cast(round(count(se.ApprovalDate)*100.0/(count(se.ApprovalDate)+count(se.RejectionDate)+.00001),2) as decimal(5,2)),'%') as 'Approval Rate',--fourth column
u.Reputation as 'Overall Reputation' --fifth column
from Users u
join SuggestedEdits se on se.OwnerUserId=u.Id
join Posts p on p.Id=se.PostId
group by u.Id,u.Reputation
order by count(se.ApprovalDate) desc,
count(se.ApprovalDate)*100.0/(count(se.ApprovalDate)+count(se.RejectionDate)+.00001) desc,
u.Reputation desc
--n: # Users

Enter Parameters

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