Stale IP sox on enwiki (with timestamps)

SQL

SELECT p.page_title, CONCAT("https://en.wikipedia.org/wiki/Special:Contribs/", p.page_title) AS link,
        (SELECT ipc.ipc_rev_timestamp
                            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)
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
         OR p.page_namespace = 3)
    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)
SQL

Checking query status...
