Unreferenced articles over 21 years old

SQL

SELECT p.page_id, p.page_title, r.rev_timestamp AS creation_timestamp
FROM categorylinks cl
JOIN page p ON cl.cl_from = p.page_id
JOIN revision r ON p.page_id = r.rev_page
JOIN (
    SELECT rev_page, MIN(rev_timestamp) AS first_rev_timestamp
    FROM revision
    GROUP BY rev_page
) first_rev ON r.rev_page = first_rev.rev_page AND r.rev_timestamp = first_rev.first_rev_timestamp
WHERE cl.cl_to = 'All_articles_lacking_sources'
AND p.page_namespace = 0
AND r.rev_timestamp < '20030615000000'
ORDER BY r.rev_timestamp ASC;

SQL

Checking query status...