SELECT

  page_id,

  page_namespace,

  page_title,

  page_len

FROM

  page

  LEFT JOIN user ON user_name = REPLACE(SUBSTRING_INDEX(page_title, '/', 1), '_', ' ')

WHERE

  page_namespace IN (2, 3)

  AND page_is_redirect = 0

  AND NOT IS_IPV4(SUBSTRING_INDEX(page_title, '/', 1))

  AND NOT IS_IPV6(SUBSTRING_INDEX(page_title, '/', 1))

  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 ISNULL(user_name);