Extreme Suggested Edit Approvers


Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

/* This returns top 200 users who have reviewed atleast 250 suggested edits
and have approved the highest percentage of edits*/

select top 200 UserId as [User Link],
       round(cast(approved*100 as float)/total ,1) ApprovedPercentage
 from (
       select UserId,
              count(case when VoteTypeId = 2 then 1 end) approved,
              count(case when VoteTypeId = 3 then 1 end) rejected,
              count(VoteTypeId) total
         from SuggestedEditVotes
        group by UserId
       ) as grouped
 where total >= 250
 order by ApprovedPercentage desc;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results