Replicas browser and optimizer
This query is marked as a draft
This query has been published
/* Other common admin actions */ select log_id, log_type, log_action, user_name, user_editcount, user_registration, log_params from logging join actor on actor_id = log_actor join user on user_id = actor_user where log_type = "protect" and log_action != "move_prot" and log_timestamp > "20160101010101" 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");
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in