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%"

JOIN centralauth_p.globaluser gu

ON REPLACE(gu.gu_name, " ", "_") = REPLACE(log_title, "@global", "")

AND gu.gu_name LIKE '%WMF)'

AND gu.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" );