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.

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

select top 100
u.Id as [User Link], --first column
count(se.ApprovalDate) as '# Accepted 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
--u.Reputation as 'Overall Reputation', --forth column
round(count(se.ApprovalDate)*100.0/(count(se.ApprovalDate)+count(se.RejectionDate)),2) as 'Approval Rate' --fifth column
from Users u
join SuggestedEdits se on se.OwnerUserId=u.Id
GROUP BY u.Id
ORDER BY count(se.ApprovalDate) desc,
count(se.ApprovalDate)*100.0/(count(se.ApprovalDate)+count(se.RejectionDate)) desc
--u.Reputation desc

view current version

edited may 29 20

created may 29 20 Gariman01