MediaWiki namespace edits (cross-wiki)

SQL

SELECT 'enwiki' as _dbname, CONCAT('MediaWiki:', page_title) as _title, rev_id, rev_timestamp, rev_user_text, rev_comment
FROM enwiki_p.revision_userindex, enwiki_p.page
WHERE rev_page = page_id AND page_namespace = 8 AND page_title LIKE '%.js' AND rev_timestamp > '20171009000000'
ORDER BY rev_timestamp DESC

UNION ALL

SELECT 'metawiki' as _dbname, CONCAT('MediaWiki:', page_title) as _title, rev_id, rev_timestamp, rev_user_text, rev_comment
FROM metawiki_p.revision_userindex, metawiki_p.page
WHERE rev_page = page_id AND page_namespace = 8 AND page_title LIKE '%.js' AND rev_timestamp > '20171009000000'
ORDER BY rev_timestamp DESC

LIMIT 1000;
SQL

Checking query status...
