Deletions by type

SQL

SELECT COUNT(log_id) AS deletions,actor_name AS user,
	SUM(comment_text LIKE "%G1%") AS "G1",/* G */
    SUM(comment_text LIKE "%G2%") AS "G2",
    SUM(comment_text LIKE "%G3%") AS "G3",
    SUM(comment_text LIKE "%G4%") AS "G4",
    SUM(comment_text LIKE "%G5%") AS "G5",
    SUM(comment_text LIKE "%G6%") AS "G6",
    SUM(comment_text LIKE "%G7%") AS "G7",
    SUM(comment_text LIKE "%G8%") AS "G8",
    SUM(comment_text LIKE "%G9%") AS "G9",
    SUM(comment_text LIKE "%G10%") AS "G10",
    SUM(comment_text LIKE "%G11%") AS "G11",
    SUM(comment_text LIKE "%G12%") AS "G12",
    SUM(comment_text LIKE "%G13%") AS "G13",
    SUM(comment_text LIKE "%G14%") AS "G14",
    SUM(comment_text LIKE "%A1%") AS "A1",/* A */
    SUM(comment_text LIKE "%A2%") AS "A2",
    SUM(comment_text LIKE "%A3%") AS "A3",
    SUM(comment_text LIKE "%A5%") AS "A5",
    SUM(comment_text LIKE "%A7%") AS "A7",
    SUM(comment_text LIKE "%A9%") AS "A9",
    SUM(comment_text LIKE "%A10%") AS "A10",
    SUM(comment_text LIKE "%A11%") AS "A11",
    SUM(comment_text LIKE "%R2%") AS "R2",/* R */
    SUM(comment_text LIKE "%R3%") AS "R3",
    SUM(comment_text LIKE "%R4%") AS "R4",
    SUM(comment_text LIKE "%F1%") AS "F1",/* F */
    SUM(comment_text LIKE "%F2%") AS "F2",
    SUM(comment_text LIKE "%F3%") AS "F3",
    SUM(comment_text LIKE "%F4%") AS "F4",
    SUM(comment_text LIKE "%F5%") AS "F5",
    SUM(comment_text LIKE "%F6%") AS "F6",
    SUM(comment_text LIKE "%F7%") AS "F7",
    SUM(comment_text LIKE "%F8%") AS "F8",
    SUM(comment_text LIKE "%F9%") AS "F9",
    SUM(comment_text LIKE "%F10%") AS "F10",
    SUM(comment_text LIKE "%F11%") AS "F11",
    SUM(comment_text LIKE "%C1%") AS "C1",/* F */
    SUM(comment_text LIKE "%C2%") AS "C2",
    SUM(comment_text LIKE "%U1%") AS "U1",/* U */
    SUM(comment_text LIKE "%U2%") AS "U2",
    SUM(comment_text LIKE "%U5%") AS "U5",
    SUM(comment_text LIKE "%P1%") AS "P1",/* P */
    SUM(comment_text LIKE "%P2%") AS "P2"
FROM logging
JOIN comment ON logging.log_comment_id=comment.comment_id
JOIN actor ON logging.log_actor=actor.actor_id
WHERE log_timestamp>'20180000000000' AND log_timestamp<'20190000000000' AND log_type='delete' AND comment_text LIKE '%CSD%'
GROUP BY log_actor ORDER BY deletions DESC;
SQL

Checking query status...
