nlwiki Broken web.archive.org and archive.today links

SQL

/*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
WHERE
    p.page_namespace = 0 -- Only include content namespace
    AND EXISTS (
        SELECT 1
        FROM externallinks el
        WHERE el.el_from = p.page_id
		AND el.el_to_domain_index LIKE '%.archive%'
    )
    AND p.page_title = 'Krukut_(Taman_Sari)'
GROUP BY
    p.page_id
HAVING
    last_edit < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 5 YEAR), '%Y%m%d%H%i%s')
ORDER BY RAND()
LIMIT 1000; -- Adjust limit as needed
*/
SELECT *
FROM externallinks el
WHERE el.el_from = 3655261
AND el.el_to_path LIKE '%web.archive.org/web/20121202090212/http://bps.go.id/eng/download_file/Population_of_Indonesia_by_Village_2010.pdf'
AND el.el_to_domain_index LIKE '%org.archive.web.%'

/*SELECT
    p.page_id,
    p.page_title
FROM
    page p
WHERE p.page_title = 'Krukut_(Taman_Sari)'*/
SQL

Checking query status...
