This query is marked as a draft This query has been published by ಮಲ್ನಾಡಾಚ್ ಕೊಂಕ್ಣೊ.

SQL

AخA
 
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);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...