Untitled query #87668

SQL

SELECT DATE_FORMAT(log_timestamp, '%Y-%m-%d') AS deletion_date,
       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 deletion_count
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%')
GROUP BY deletion_date, deletion_type
ORDER BY deletion_date DESC, deletion_count DESC;
SQL

Checking query status...
