enwiki articles created by ips before 2006

SQL

SELECT CONCAT('[[',
              (CASE page_namespace
               WHEN 0 THEN ''
               WHEN 1 THEN 'Talk:'
               WHEN 2 THEN 'User:'
               WHEN 3 THEN 'User talk:'
               WHEN 4 THEN 'Wikipedia:'
               WHEN 5 THEN 'Wikipedia talk:'
               WHEN 6 THEN ':File:'
               WHEN 7 THEN 'File talk:'
               WHEN 10 THEN ':Template:'
               WHEN 11 THEN 'Template talk:'
               WHEN 14 THEN ':Category:'
               WHEN 15 THEN 'Category talk:'
               WHEN 100 THEN 'Portal:'
               WHEN 101 THEN 'Portal talk:'
               WHEN 108 THEN 'Book:'
               WHEN 109 THEN 'Book talk:'
               WHEN 118 THEN 'Draft:'
               WHEN 119 THEN 'Draft talk:'
               ELSE CONCAT('{{ns:', page_namespace, '}}:')
              END),
              REPLACE(page_title, '_', ' '),
              ']]') AS 'page',
       rev_user_text AS 'creator'
FROM revision_userindex
JOIN page
     ON page_id = rev_page
WHERE rev_parent_id = 0;
SQL

Checking query status...
