test - Quarry

SQL

USE metawiki_p;
SELECT actor_name, REPLACE(log_title, "@global", "") AS username, log_timestamp, log_comment
FROM logging_compat
JOIN actor
ON log_actor = actor_id
AND actor_name LIKE "%(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
GROUP BY username
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...
