Suggested Edit Review Stats


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

/* This returns stats about your suggested edit reviews*/

DECLARE @UserId int = ##UserId##

select total,
       round(cast(approved*100 as float)/total ,1) ApprovedPercentage,
       round(cast(rejected*100 as float)/total ,1) RejectedPercentage
 from (
       select count(case when VoteTypeId = 2 then 1 end) approved,
              count(case when VoteTypeId = 3 then 1 end) rejected,
              count(VoteTypeId) total
         from SuggestedEditVotes
        where UserId = @UserId
       ) as grouped;

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results