To AfC reviewers

SQL

SELECT 
    RANK() OVER (ORDER BY COUNT(log_id) DESC) AS Rank,
    COUNT(log_id) AS Reviews, 
    actor_name AS Reviewer, 
    SUM(log_comment LIKE "%Publishing accepted%") AS "Accept",
    SUM(log_comment LIKE "Declining submission:%") AS "Decline",
    SUM(log_comment LIKE "Commenting on submission%") AS "Comment",
    SUM(log_comment LIKE "Rejecting submission:%") AS "Reject",
    CONCAT(ROUND(SUM(log_comment LIKE "%Publishing accepted%") * 100 / COUNT(log_id), 1), "%") AS "Accept %",
    CONCAT(ROUND(SUM(log_comment LIKE "Declining submission:%") * 100 / COUNT(log_id), 1), "%") AS "Decline %",
    CONCAT(ROUND(SUM(log_comment LIKE "Commenting on submission%") * 100 / COUNT(log_id), 1), "%") AS "Comment %",
    CONCAT(ROUND(SUM(log_comment LIKE "Rejecting submission:%") * 100 / COUNT(log_id), 1), "%") AS "Reject %"
FROM 
    logging
LEFT JOIN 
    actor ON log_actor = actor_id
WHERE 
    log_namespace = 118 OR log_namespace = 2
    AND log_type = 'review'
    AND (log_comment LIKE "Declining submission:%" 
         OR log_comment LIKE "Rejecting submission:%"
         OR log_comment LIKE "Commenting on submission%"
         OR log_comment LIKE "%Publishing accepted%")
    AND log_timestamp >= '2024-01-01'
    AND log_timestamp < '2024-01-31'
GROUP BY 
    log_actor, actor_name
ORDER BY 
    Reviews DESC
LIMIT 100;
SQL

Checking query status...
