CSD U2 worthy pages

SQL

select case when page_namespace = 2 then CONCAT('# [[User:', page_title, ']]') else 
       CONCAT('# [[User talk:', page_title, ']]') end as 'U2 worthy page',
       page_len as 'Page length',
       rev_timestamp as 'Creation date',
       actor_name as 'Page creator'
from revision
join (select
      page_namespace,
      page_id,
      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)
join actor on rev_actor = actor_id;
SQL

Checking query status...
