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

SQL

AخA
 
select log_namespace, log_title, comment_text, log_timestamp from logging_logindex join comment_logging on comment_id=log_comment_id
where log_type="delete" and log_action="delete"
and 
  (comment_text like "%G6%")
  and comment_text not regexp ".*\\[\\[WP:(CSD#)?(?!G6)[GARFCU][0-9]{1,2}.*" -- Ignore the G6 entirely and focus on the other criteria
  and comment_text not like "%Obviously created in error" -- "Deleting empty dated maintenance categories for dates in the past"
  and comment_text not like "%created in error%"
  and comment_text not like "%Deleted to make way for move" -- "Deleting redirects or other pages blocking page moves"
  and log_title not regexp "_(from|as_of|to_be_decided_after)_([123]?[0-9]_)?(January|February|March|April|May|June|July|August|September|October|November|December)_20[012][0-9]"
  -- "Deleting empty dated maintenance categories for dates in the past"
  and comment_text not regexp -- "Deleting templates orphaned as the result of a consensus at WP:TfD. (generalizing to other fora)"
   "^\\[\\[WP:(CSD#)?G6\\|G6]]: \\[\\[Wikipedia:((Articles|Miscellany)[ _]for[ _]deletion|(Files|Templates|Categories|Redirects)[ _]for[_ ]discussion).*"
  and log_title not like "%Archives/%Archives/%Archives%"
 -- Large deletions that should probably be listed but I don't want to flood the table
  and not (log_namespace=2 and log_title like "ClueBot_III%")
  and comment_text != "[[WP:CSD#G6|G6]]: [[WP:BOTN#Double redirects for user's scripts]]"
and log_timestamp like "2022%"
order by log_timestamp desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...