Untitled query #88112

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

Checking query status...
