To AfC reviewers

SQL

SELECT 
    RANK() OVER (ORDER BY COUNT(rc_id) DESC) AS rank,
    COUNT(rc_id) AS reviews, 
    actor_name, 
    SUM(comment_text LIKE "%Publishing accepted%") AS "accept",
    SUM(comment_text LIKE "Declining submission:%") AS "decline",
    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 "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
LEFT JOIN 
    ipblocks ON actor_user = ipb_user
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 "%Publishing accepted%")
    AND rc_timestamp >= NOW() - INTERVAL 1 DAY
GROUP BY 
    rc_actor
ORDER BY 
    reviews DESC
LIMIT 100;
SQL

Checking query status...
