Untitled query #23951

SQL

use arwiki_p;
SELECT
  page_namespace,
  page_title,
  page_len,
  rev_user_text,
  rev_timestamp
FROM revision
JOIN (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 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)) AS pgtmp
ON pgtmp.page_id = rev_page
SQL

Checking query status...
