Untitled query #87668

SQL

SELECT
       CASE 
         WHEN comment_text RLIKE '\\bG13\\b' THEN 'G13 Abandoned Draft'
         WHEN comment_text RLIKE '\\bG11\\b' THEN 'G11 Advertising'
         WHEN comment_text LIKE '%AfD%' THEN 'Articles for Deletion (AfD)'
         WHEN comment_text LIKE '%PROD%' THEN 'Proposed Deletion (PROD)'
         ELSE 'Other'
       END AS deletion_type,
       COUNT(*) AS total_deletions
FROM logging_userindex
JOIN comment_logging ON comment_id = log_comment_id
JOIN actor_logging ON actor_id = log_actor
WHERE actor_name = "Liz"
  AND log_type = 'delete'
  AND log_action = 'delete'
  AND (comment_text RLIKE '\\bG[0-9]+\\b' OR comment_text LIKE '%AfD%' OR comment_text LIKE '%PROD%')
  AND YEAR(log_timestamp) = 2024
GROUP BY deletion_type
ORDER BY total_deletions DESC;
SQL

Checking query status...
