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
    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 NOT IN ('archive.is', 'archive.today', 'archive.org', 'toolforge.org')
		AND el.el_to_domain_index NOT LIKE '%org.toolforge%'
    )
	AND p.page_title = 'Vaikaradhoo'
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 100; -- Adjust limit as needed
*/
/*SELECT *
        FROM externallinks el
        WHERE el.el_from = 1163978
        AND el.el_to_domain_index NOT IN ('archive.is', 'archive.today', 'archive.org', 'toolforge.org')
		AND el.el_to_domain_index NOT LIKE '%org.toolforge%'*/
        
SELECT el_to_domain_index, SUBSTRING_INDEX(
    REVERSE(SUBSTRING_INDEX(REVERSE(REPLACE(REPLACE('https://org.archive.web.', 'https://', ''), 'http://', '')), '.', 3)),
    '.', 2
  ) AS main_domain;
FROM externallinks
WHERE el_from = 1163978
SQL

Checking query status...
