Name (Acronym)

SQL

/* Other common admin actions */
select log_id, log_type, log_action, user_name, user_editcount, user_registration, log_params from logging_userindex
join actor_logging on actor_id = log_actor join user on user_id = actor_user
where log_type = "delete" and log_action != "delete_redir" and log_action != "delete_redir2" and log_timestamp > "20170101010101"
and not exists (select 1 from user_groups where ug_user = actor_user and ug_group="sysop") 
and not exists (select 1 from user_former_groups where ufg_user = actor_user and ufg_group="sysop");
SQL

Checking query status...
