Content-related OAs by WMF in en.wiki since 2002

Fork of Content-related OAs by WMF in fr.wiki in ~last decade by TrangaBellam

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

SQL

/* Office actions */
select log_timestamp, SUBSTRING(log_timestamp, 7, 2) AS log_day, SUBSTRING(log_timestamp, 5, 2) AS log_month, SUBSTRING(log_timestamp, 1, 4) AS log_year, log_title, log_action, user_name, log_params from logging_userindex
join actor_logging on actor_id = log_actor join user on user_id = actor_user
# where (log_type = "protect" OR log_type = "delete") # Doesn't throw new cases
where log_type = "protect"
and log_action != "move_prot"
and log_timestamp > "20020101010101" # Since 2002; but did staff have WMF accounts, then?
and log_namespace = 0 # Only articles?
and user_name like "%WMF%"
ORDER BY log_timestamp DESC;

SQL

Checking query status...