SQL
AخA
select
page_namespace,
CONCAT('[[User:', page_title, ']]') as U2_page,
page_len,
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
AND rev_timestamp = (SELECT
MIN(rev_timestamp)
FROM revision
WHERE rev_page = pgtmp.page_id)
limit 1;
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.