Untitled query #74052

SQL

SELECT
    u.user_name
FROM
    revision AS r1
INNER JOIN
    revision AS r2 ON r1.rev_page = r2.rev_page AND r1.rev_id < r2.rev_id
INNER JOIN
    slots AS s1 ON r1.rev_id = s1.slot_revision_id
INNER JOIN
    slots AS s2 ON r2.rev_id = s2.slot_revision_id
INNER JOIN
    content AS c1 ON s1.slot_content_id = c1.content_id
INNER JOIN
    content AS c2 ON s2.slot_content_id = c2.content_id
INNER JOIN
    text AS t1 ON c1.content_address = CONCAT('tt:', t1.old_id)
INNER JOIN
    text AS t2 ON c2.content_address = CONCAT('tt:', t2.old_id)
INNER JOIN
    user AS u ON r2.rev_user = u.user_id
WHERE
    r1.rev_page = YOUR_PAGE_ID
    AND
    INSTR(t2.old_text, 'YOUR_LINK') > 0
    AND
    INSTR(t1.old_text, 'YOUR_LINK') = 0
ORDER BY
    r2.rev_id
LIMIT 1;
SQL

Checking query status...
