To AfC reviewers

SQL

SELECT 
    RANK() OVER (ORDER BY COUNT(r.rev_id) DESC) AS Rank,
    COUNT(r.rev_id) AS Reviews, 
    a.actor_name AS Reviewer, 
    SUM(c.comment_text LIKE '%Publishing accepted%') AS Accept,
    SUM(c.comment_text LIKE 'Declining submission:%') AS Decline,
    SUM(c.comment_text LIKE 'Commenting on submission%') AS Comment,
    SUM(c.comment_text LIKE 'Rejecting submission:%') AS Reject,
    CONCAT(ROUND(SUM(c.comment_text LIKE '%Publishing accepted%') * 100 / COUNT(r.rev_id), 1), '%') AS `Accept %`,
    CONCAT(ROUND(SUM(c.comment_text LIKE 'Declining submission:%') * 100 / COUNT(r.rev_id), 1), '%') AS `Decline %`,
    CONCAT(ROUND(SUM(c.comment_text LIKE 'Commenting on submission%') * 100 / COUNT(r.rev_id), 1), '%') AS `Comment %`,
    CONCAT(ROUND(SUM(c.comment_text LIKE 'Rejecting submission:%') * 100 / COUNT(r.rev_id), 1), '%') AS `Reject %`
FROM 
    revision r
INNER JOIN 
    actor a ON r.rev_actor = a.actor_id
INNER JOIN 
    comment c ON r.rev_comment_id = c.comment_id
WHERE 
    r.rev_timestamp >= NOW() - INTERVAL 1 DAY
    AND (c.comment_text LIKE 'Declining submission:%' 
         OR c.comment_text LIKE 'Rejecting submission:%'
         OR c.comment_text LIKE 'Commenting on submission%'
         OR c.comment_text LIKE '%Publishing accepted%')
GROUP BY 
    r.rev_actor
ORDER BY 
    Reviews DESC
LIMIT 100;
SQL

Checking query status...
