select replace(concat("[[:{{subst:ns:",log_namespace,"}}:",replace(log_title,"_"," "),"]]"),":{{subst:ns:0}}:",":") as 'Page',

(select actor_name from actor_logging where actor_id=log_actor) as "Deleting admin",

comment_text as "Edit summary",

log_timestamp as "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 "%G8%")

 and not (comment_text like "%XFDcloser%") -- trusting these since I know XfDCloser is coded properly

 and not (comment_text like "[[WP:CSD#G8|G8]]: Redirect to deleted page \"%") -- Can't validate these, so AGF-ing

 and not (comment_text like "%Redirect to a deleted or nonexistent page%")

 and not (

   comment_text like "%Talk page%of%deleted%page%"

   and log_namespace % 2 = 1

   and not exists (select 1 from page where page_namespace=log_namespace - 1 and page_title=log_title)

 )

 and not (

   comment_text like "%Subpage%of%deleted%page"

   and not exists (select 1 from page where page_namespace=log_namespace and page_title = SUBSTRING_INDEX(log_title,"/",1))

 )

and (log_timestamp like "2022%")

order by log_timestamp desc;