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

SQL

AخA
 
select replace(concat("[[:{{subst:ns:",log_namespace,"}}:",replace(log_title,"_"," "),"]]"),":{{subst:ns:0}}:",":") as 'Page',
actor_name as "Deleting admin",
count(log_namespace,log_title) as "Count"
where log_type="delete" and log_action="delete"
and (comment_text not like "%[[WP:CSD#%"
      and comment_text not regexp "\\[\\[WP:[GARFCU][0-9]{1,2}.*"
      and comment_text not regexp "^\\[\\[Wikipedia:((Articles|Miscellany)[ _]for[ _]deletion|(Files|Templates|Categories|Redirects)[ _]for[ _]discussion).*"
      and comment_text not like "Expired [[WP:PROD|PROD]]%"
      and comment_text not like "Multiple reasons: speedy deletion criteria%"
      and comment_text not like "This file is now on Wikimedia Commons at%"
      and comment_text not like "Listed at [[Wikipedia:Copyright problems]] for over seven days%"
      and comment_text not like "%BLPPROD%"
      and comment_text not regexp ".*[Gg][35].*" -- these tend to use odd formats, so exclude them
      and comment_text != "G8"
     )
and (log_timestamp like "2022%")
group by actor_name
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...