Stale IP sox on enwiki

SQL

SELECT p.page_title, CONCAT("<a href='https://en.wikipedia.org/wiki/Special:Contribs/", p.page_title, "'>test</a>") AS link
FROM templatelinks tl
    INNER JOIN page p on tl.tl_from = p.page_id
WHERE tl.tl_namespace = 10
    AND (tl.tl_title = "Ipsock-self"
         OR tl.tl_title = "IPsock-self"
         OR tl.tl_title = "IPsock"
         OR tl.tl_title = "Ipsock"
         OR tl.tl_title = "IPsockpuppet"
         OR tl.tl_title = "IPSockpuppet"
         OR tl.tl_title = "IPSock"
         OR tl.tl_title = "IPsockblock"
         OR tl.tl_title = "IP sockpuppet"
         OR tl.tl_title = "IP sock")
    AND p.page_namespace = 2
    AND NOT EXISTS (SELECT 1
                    FROM ip_changes ipc
                    WHERE ipc.ipc_hex = HEX(INET6_ATON(p.page_title))
                        AND ipc.ipc_rev_timestamp > 20201010000000
                    ORDER BY ipc.ipc_rev_timestamp DESC
                    LIMIT 1)
LIMIT 1
SQL

Checking query status...
