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
FROM hist h
    INNER JOIN text t ON h.rev_text_id = t.old_id
WHERE
    WITH (SELECT LEAD(old_text)) AS prev_text
    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...