ARBECR CSD Deletions

Fork of ARBECR CSD Deletions by Sideswipe9th

This query is marked as a draft This query has been published by Alpha3031.

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 log_timestamp > '2018'
  AND comment_text LIKE '%G5%'
  AND (comment_text LIKE '%general sanctions%' OR comment_text LIKE '%ECR%' OR comment_text LIKE '%CT/%' OR comment_text LIKE '%GS/%')
ORDER BY log_timestamp DESC;

SQL

Checking query status...