Untitled query #88099

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 r.rev_timestamp >= NOW() - INTERVAL 12 MONTH
    AND (comment.comment_text LIKE "%Publishing accepted%"
         AND comment.comment_text LIKE "Declining submission:%"
         AND comment.comment_text LIKE "Commenting on submission%"
         AND comment.comment_text LIKE "Rejecting submission:%")
GROUP BY
    r.rev_actor
ORDER BY
    Reviews DESC;
SQL

Checking query status...
