Most active misdeleters

SQL

select 
(select actor_name from actor_logging where actor_id=log_actor) as "Deleting admin",
count(*) as "count"
from logging_logindex join comment_logging on comment_id=log_comment_id
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|WP):((Articles|Miscellany)[ _]for[ _]deletion|(Files|Templates|Categories|Redirects)[ _]for[ _]discussion).*"
      and comment_text not like "Per%TfD outcome%" -- since one prolific admin uses a nonstandard format for these
      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 not regexp "^(CSD )?[GARFCUgarfcu][0-9]{1,2}($|[.,/])?" -- exclude cases containing just a code, or a code followed
      -- by an explanation with a comma, period or slash. I deliberately don't exclude just [GARFCU][0-9]{1,2} as that's
      -- too broad and risks too many false negatives
      and comment_text not like "%per the discussion at [[Wikipedia:Categories%" -- nonstandard format that CfD uses for some reason
     )
and (log_timestamp like "202204%")
group by log_actor
order by count(*) desc;
SQL

Checking query status...
