Tamzin's sandbox

SQL

SELECT p.page_title, CONCAT("https://en.wikipedia.org/wiki/Special:Contribs/", p.page_title) 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
  OR p.page_namespace = 3
)
AND (
  SELECT ipc.ipc_rev_timestamp
  FROM ip_changes ipc
  WHERE ipc.ipc_hex = HEX(INET6_ATON(p.page_title))
  ORDER BY ipc.ipc_rev_timestamp DESC
  LIMIT 1
) < 20201010000000
LIMIT 1
SQL

Checking query status...
