Links to ArbCom case shortcuts (enwiki)

SQL

WITH hist AS
    (SELECT rev_text_id, actor_name
     FROM revision r
         INNER JOIN actor a ON r.rev_actor = a.actor_id
     WHERE rev_page = 17328042
     ORDER BY rev_text_id DESC)
SELECT old_id, actor_name, old_text
WITH (SELECT LEAD(old_text)) AS prev_text
FROM hist h
    INNER JOIN text t ON h.rev_text_id = t.old_id
WHERE LENGTH(old_text) - LENGTH(REGEXP_REPLACE(old_text, "\\.*(WP:\\w+\\).*", ""))
          != LENGTH(prev_text) - LENGTHLENGTH(REGEXP_REPLACE(prev_text, "\\.*(WP:\\w+\\).*", ""))
ORDER BY old_id DESC
LIMIT 1

SQL

Checking query status...