nlwiki Pages not updated in the last 5 years with >=1 external link(s)

SQL

USE nlwiki_p; -- Replace with the desired Wikimedia database (e.g., enwiki_p for English Wikipedia)

-- Select pages that haven't been updated in the last 5 years and have at least one external link
SELECT
    p.page_id,
    p.page_title,
    MAX(r.rev_timestamp) AS last_edit
FROM
    page p
JOIN
    revision r ON r.rev_page = p.page_id
JOIN
    externallinks el ON el.el_from = p.page_id
WHERE
    p.page_namespace = 0 -- Only include content namespace (adjust as needed)
GROUP BY
    p.page_id
HAVING
    MAX(r.rev_timestamp) < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 5 YEAR), '%Y%m%d%H%i%s')
LIMIT 100; -- Adjust limit as needed

SQL

Checking query status...