SQL
AخA
SELECT page_title, page_is_redirect, CAST(MIN(rev_timestamp) AS DATETIME) AS creation
FROM page
JOIN revision ON rev_page = page_id
WHERE page_namespace = 0
AND page_title RLIKE '[^_]\\('
GROUP BY page_id
ORDER BY MIN(rev_timestamp) DESC;
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.