Thryduulf's csds, by code

Thryduulf's deletion comments containing "CSD" or anything that looks like a csd code, sorted by csd code when it's at the start of the comment and unambiguous.

If the comment has anything that looks like it might be another csd code after the start, or even another mention of "CSD", it's left unchanged, in order to avoid any chance of obscuring comments that mention multiple csd codes.  (Even if it's the same csd code that was matched earlier; recognizing that in a single sql statement is more trouble than it's worth. So is counting multiple csd codes from a single comment into multiple bins.)

For [[WP:AN#Are CSD tags edits for the purposes of WP:G13?]] circa 9 October 2022.

SQL

SELECT REGEXP_REPLACE(comment_text,
                      '^(?:\\[*(?:WP:)?(?:CSD)?(?:\\|CSD)?[]#: ]*)([A-Z][0-9]+)\\b(?:\\|\\1\\b)?(?!.*?(CSD|\\b[GARFICUPTX][0-9]+\\b)).*',
                      '\\1') AS csdcode,
       COUNT(*)
FROM logging_userindex
JOIN actor_logging ON actor_id = log_actor
JOIN comment_logging ON comment_id = log_comment_id
WHERE actor_name = 'Thryduulf'
  AND log_type = 'delete'
  AND log_action = 'delete'
  AND (comment_text LIKE '%CSD%'
       OR comment_text REGEXP '\\b[GARFICUPTX][0-9]+\\b')
GROUP BY csdcode
ORDER BY CASE WHEN (csdcode REGEXP '^[A-Z][0-9]+$') THEN CONCAT(' ', csdcode) ELSE csdcode END ASC;

SQL

Checking query status...