Untitled query #83189

SQL

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);
SQL

Checking query status...
