Deletions by type

SQL

SELECT COUNT(log_id) AS deletions,actor_name AS user,
	SUM(comment_text LIKE "%G1%") AS "G1",
    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",
    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"
FROM logging
JOIN comment ON logging.log_comment_id=comment.comment_id
JOIN actor ON logging.log_actor=actor.actor_id
WHERE log_timestamp>'20220000000000' AND log_type='delete' AND comment_text LIKE '%CSD%'
GROUP BY log_actor ORDER BY deletions DESC;
SQL

Checking query status...
