Stale IP sox on enwiki

SQL

SELECT p.page_title
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 (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...
