/* 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 > "20150101010101" # Taking about a decade ...

and log_namespace = 0 # Only articles?

and user_name like "%WMF%"

ORDER BY log_timestamp DESC;