Untitled query #67999

SQL

select replace(concat("[[:{{subst:ns:",log_namespace,"}}:",replace(log_title,"_"," "),"]]"),":{{subst:ns:0}}:",":") as 'Page',
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 "WantedTemplates%"
     )
and not exists (select 1 from page where page_namespace=0 and page_title=log_title)
-- Exclude mass deletions of pages created by socks
and exists (select 1 from archive where ar_namespace=0 and ar_title=log_title and ar_timestamp < log_timestamp-1000000)
and not (comment_text like "%Mass deletion%" and exists (
  select comment_text from actor_archive join archive on ar_actor=actor_id join ipblocks on ipb_user=actor_user join comment_ipblocks on comment_id=ipb_reason_id
	where ar_namespace=0 and ar_title=log_title and ar_parent_id=0
	and (comment_text like "%Sockpuppet%investigations%" or comment_text like "%multiple%accounts%" or comment_text like "%checkuser%")
))
and log_namespace=0
and actor_id=(select actor_id from actor where actor_name="Plastikspork")
and log_timestamp like "202309%"
order by log_timestamp desc;
SQL

Checking query status...
