Untitled query #88143

SQL

SELECT
    ROW_NUMBER() OVER (ORDER BY (SUM(comment_text LIKE "%Publishing accepted%") 
                                + SUM(comment_text LIKE "Declining submission:%") 
                                + SUM(comment_text LIKE "Commenting on submission%") 
                                + SUM(comment_text LIKE "Rejecting submission:%")) DESC) AS Rank,
    (SUM(comment_text LIKE "%Publishing accepted%") 
    + SUM(comment_text LIKE "Declining submission:%") 
    + SUM(comment_text LIKE "Commenting on submission%") 
    + SUM(comment_text LIKE "Rejecting submission:%")) 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 / 
                 (SUM(comment_text LIKE "%Publishing accepted%") 
                 + SUM(comment_text LIKE "Declining submission:%") 
                 + SUM(comment_text LIKE "Commenting on submission%") 
                 + SUM(comment_text LIKE "Rejecting submission:%")), 1), "%") AS "Accept %",
    CONCAT(ROUND(SUM(comment_text LIKE "Declining submission:%") * 100 / 
                 (SUM(comment_text LIKE "%Publishing accepted%") 
                 + SUM(comment_text LIKE "Declining submission:%") 
                 + SUM(comment_text LIKE "Commenting on submission%") 
                 + SUM(comment_text LIKE "Rejecting submission:%")), 1), "%") AS "Decline %",
    CONCAT(ROUND(SUM(comment_text LIKE "Commenting on submission%") * 100 / 
                 (SUM(comment_text LIKE "%Publishing accepted%") 
                 + SUM(comment_text LIKE "Declining submission:%") 
                 + SUM(comment_text LIKE "Commenting on submission%") 
                 + SUM(comment_text LIKE "Rejecting submission:%")), 1), "%") AS "Comment %",
    CONCAT(ROUND(SUM(comment_text LIKE "Rejecting submission:%") * 100 / 
                 (SUM(comment_text LIKE "%Publishing accepted%") 
                 + SUM(comment_text LIKE "Declining submission:%") 
                 + SUM(comment_text LIKE "Commenting on submission%") 
                 + SUM(comment_text LIKE "Rejecting submission:%")), 1), "%") AS "Reject %"
FROM
    revision_userindex r
JOIN
    actor ON r.rev_actor = actor.actor_id
JOIN
    comment ON r.rev_comment_id = comment.comment_id
JOIN
    page ON r.rev_page = page.page_id
WHERE
    (
        (page.page_namespace IN (118, 2) AND comment.comment_text LIKE "%Publishing accepted%")
        OR
        (page.page_namespace IN (0, 118, 2) AND (
            comment.comment_text LIKE "Declining submission:%" 
            OR comment.comment_text LIKE "Commenting on submission%" 
            OR comment.comment_text LIKE "Rejecting submission:%"))
    )
    AND r.rev_timestamp >= NOW() - INTERVAL 12 MONTH
GROUP BY
    r.rev_actor
ORDER BY
    Reviews DESC;
LIMIT 100;
SQL

Checking query status...
