/* 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");