Untitled query #67999

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 = 'Plastikspork'
  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...
