ARBECR CSD Deletions

SQL

SELECT actor_name, CAST(log_timestamp AS DATETIME) AS 'time', log_title, log_namespace, comment_text
FROM logging
JOIN actor_logging ON actor_id = log_actor
JOIN comment_logging ON comment_id = log_comment_id
WHERE log_action = 'delete'
  AND log_type = 'delete'
  AND log_timestamp >= '2023'
  AND comment_text LIKE '%G5%'
  AND (comment_text LIKE '%general sanctions%' OR comment_text LIKE '%WP:ECR%' OR comment_text LIKE '%CT/A-I%' OR comment_text LIKE '%GS/AA%' OR comment_text LIKE '%GS/RUSUKR%')
ORDER BY log_timestamp DESC;
SQL

Checking query status...
