To AfC reviewers

SQL

SELECT 
    RANK() OVER (ORDER BY COUNT(rc_id) DESC) AS Rank,
    COUNT(rc_id) AS Reviews, 
    actor_name AS Reviewer, 
    SUM(comment_text LIKE "%Publishing accepted%") AS "Accept",
    SUM(comment_text LIKE "Declining submission:%") AS "Decline",
    SUM(comment_text like "Commenting on submission%") as "Comment",
    SUM(comment_text LIKE "Rejecting submission:%") AS "Reject",
    CONCAT(ROUND(SUM(comment_text LIKE "%Publishing accepted%") * 100 / COUNT(rc_id), 1), "%") AS "Accept %",
    CONCAT(ROUND(SUM(comment_text LIKE "Declining submission:%") * 100 / COUNT(rc_id), 1), "%") AS "Decline %",
    CONCAT(ROUND(SUM(comment_text LIKE "Commenting on submission%") * 100 / COUNT(rc_id), 1), "%") AS "Comment %",
    CONCAT(ROUND(SUM(comment_text LIKE "Rejecting submission:%") * 100 / COUNT(rc_id), 1), "%") AS "Reject %"
FROM 
    recentchanges_userindex
LEFT JOIN 
    actor ON rc_actor = actor_id
LEFT JOIN 
    comment ON rc_comment_id = comment_id
WHERE 
    (rc_namespace = 118 OR rc_namespace = 2) 
    AND rc_type < 5 
    AND (comment_text LIKE "Declining submission:%" 
         OR comment_text LIKE "Rejecting submission:%"
         OR comment_text LIKE "Commenting on submission%"
         OR comment_text LIKE "%Publishing accepted%")
    AND rc_timestamp >= NOW() - INTERVAL 365 DAY
GROUP BY 
    rc_actor
ORDER BY 
    Reviews DESC
LIMIT 100;
SQL

Checking query status...
