Userspace pages of IPs with no contributions or logs

SQL

SELECT CONCAT('https://en.wikipedia.org/wiki/User', CASE WHEN p.page_namespace = 3 THEN '_talk:' ELSE ':' END, p.page_title) AS URL
FROM enwiki_p.page p
LEFT JOIN enwiki_p.actor a ON a.actor_user IS NULL AND a.actor_name = SUBSTRING_INDEX(p.page_title, '/', 1)
WHERE p.page_namespace = 2
AND p.page_is_redirect = 0
AND a.actor_id IS NULL
AND (
  IS_IPV4(SUBSTRING_INDEX(p.page_title, '/', 1))
  OR
  IS_IPV6(SUBSTRING_INDEX(p.page_title, '/', 1))
)
/*
AND p.page_title NOT LIKE '%.css'
AND p.page_title NOT LIKE '%.cs'
AND p.page_title NOT LIKE '%.js'
AND p.page_title NOT LIKE '%.charset'
AND p.page_id NOT IN (
  SELECT cl.cl_from FROM
  enwiki_p.categorylinks cl
  WHERE cl.cl_to IN ('User_soft_redirects', 'Wikipedia_doppelganger_accounts') -- Exclude these categories
)
AND p.page_id NOT IN (
  SELECT tl.tl_from FROM
  enwiki_p.templatelinks tl
  WHERE tl.tl_target_id = 32197 -- Exclude pages tagged with sockpuppet template
)*/
SQL

Checking query status...
