nlwiki External links with double http, excluding archives

SQL

SELECT page_namespace AS ns, page_title, el_to
FROM externallinks, page
WHERE
	el_from=page_id AND page_namespace IN (0,6,8,10,12,14,100,828) AND
	el_to REGEXP '^https?://' AND
    el_index_60 NOT REGEXP '^https?://('
    	'com\\.wikiwix\\.archive|'
        'eu\\.archiefweb|'
        'org\\.(bibalex\\.)?(archive\\.web|waybackmachine)(\\.replay)?|'
        'org\\.archive-it\\.wayback|'
        'org\\.wayback\\.archive|'
        'pt\\.arquivo|'
        'uk\\.gov\\.nationalarchives\\.webarchive'
        ')\\.' AND
	el_to NOT REGEXP '^https?://archive\\.(fo|today|is)($|/)' AND
    el_to REGEXP '^(https?:)?//[^\\?#]*https?://'
LIMIT 100

SQL

Checking query status...