nlwiki External links with double http, excluding archives in main namespace

SQL

SELECT page_namespace AS ns, page_title, el_to
FROM externallinks, page
WHERE
	el_from=page_id AND page_namespace IN (0,1,4,6,8,10,12,14,100,828) AND
    page_title NOT REGEXP '/[Aa]rchief' AND
	el_to REGEXP '^https?://' AND
    el_index_60 NOT REGEXP '^https?://('
    	'at\\.ac\\.onb\\.webarchiv|'
    	'au\\.gov\\.nla\\.webarchive|'
        'ca\\.gc\\.bac-lac\\.webarchive|'
        'de\\.webwiki\\.www|'
        'com\\.archive-(be|nl|org)|'
    	'com\\.wikiwix\\.archive|'
        'edu\\.stanford\\.swap|'
        'edu\\.unt\\.cybercemetery|'
        'eu\\.archiefweb|'
        'gov\\.loc\\.webarchive|'
        'is\\.vefsafn\\.wayback|'
        'nl\\.presurf\\.zeeland|'
        'nl\\.sitearchief\\.archief[0-9]+|'
        'nl\\.pagefreezer\\.publiek|'
        'org\\.(bibalex\\.)?(archive\\.web|waybackmachine)(\\.replay)?|'
        'org\\.archive\\.wayback|'
        'org\\.archive-it\\.wayback|'
        'org\\.ghostarchive|'
        'org\\.mementoweb\\.timetravel|'
        'org\\.wayback\\.archive|'
        'pt\\.arquivo|'
        'uk\\.gov\\.nationalarchives\\.webarchive|'
        'uk\\.org\\.webarchive\\.www'
        ')\\.' AND
	el_to NOT REGEXP '^https?://archive\\.(fo|is|li|md|ph|today|vn)($|/)' AND
    el_to REGEXP '^(https?:)?//[^\\?#]*https?://'
ORDER BY el_to
LIMIT 100
SQL

Checking query status...
