USE metawiki_p;

SELECT actor_name, log_timestamp, REPLACE(log_title, "@global", "") AS username

FROM logging_userindex

JOIN actor ON log_actor = actor_id

AND actor_name ="ERoss (WMF)"

AND log_action = "setstatus"

AND log_params LIKE "%locked%"

HAVING username IN (

  select REPLACE(gu_name, " ", "_")

  FROM globaluser

  WHERE gu_name LIKE "%WMF)"

  AND gu_locked = 1 )

AND HAVING username NOT IN (

  SELECT page_title

  FROM page

  JOIN categorylinks ON page_id = cl_from

  AND cl_to = "Former_Wikimedia_Foundation_staff_accounts" );