CSD U2 worthy pages

Forked from https://en.wikipedia.org/wiki/Wikipedia:Database_reports/Ownerless_pages_in_the_user_space/Configuration and updated to work with changed database schema

SQL

select case when pt_namespace = 2 then CONCAT('# [[User:', pt_title, ']]') else CONCAT('# [[User talk:', pt_title, ']]') end as U2 page
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 page_title NOT regexp '([0-9A-E][0-9A-E][0-9A-E]:[0-9A-E].|[1-9].|[1-9]{2}.|[1-9]{3}.)'
      AND ISNULL(user_name)) AS pgtmp
ON pgtmp.page_id = rev_page
AND rev_timestamp = (SELECT
                       MIN(rev_timestamp)
                     FROM revision
                     WHERE rev_page = pgtmp.page_id);

SQL

Checking query status...