SELECT

  page_namespace,

  CONCAT('[[User talk:', page_title, ']]') AS user_talk_page,

  CONCAT('[[Special:Contributions/', page_title, ']]') as user_contribs,

  page_len

FROM page

LEFT JOIN `user`

ON user_name = REPLACE(page_title, '_', ' ')

WHERE page_namespace = 3

AND page_is_redirect = 0

AND page_title NOT LIKE "%/%"

AND page_title NOT RLIKE "(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)"

AND user_name IS NULL;