Users locked by WMF HR but not listed as former staff

Example query to make updates easier for
https://meta.wikimedia.org/wiki/Category:Former_Wikimedia_Foundation_staff_accounts
https://meta.wikimedia.org/wiki/Template:WMF_Staff

SQL

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" );

SQL

Checking query status...