Carlossuarez46 pages reffing only geonames/Iranian census

Main namespace pages created by [[User:Carlossuarez46]] that currently have at least one external link to geonames.nga.mil, and no other external links except possibly to:
geohack.toolforge.org (coordinate templates),
web.archive.org (reference archival),
https://www.amar.org.ir/Portals/0/census/.

Currently only displays articles starting with "Bar" for performance reasons.

SQL

SELECT rev_timestamp, page_id, page_title
FROM revision
JOIN page ON page_id = rev_page
JOIN actor_revision ON actor_id = rev_actor
WHERE page_namespace = 0
  AND page_title LIKE 'Bar%'
  AND rev_parent_id = 0
  AND actor_name = 'Carlossuarez46'
  AND EXISTS (SELECT 1
              FROM externallinks
              WHERE el_from = rev_page
                AND (el_to LIKE 'http://geonames.nga.mil/%'
                     OR el_to LIKE 'https://geonames.nga.mil/%'))
  AND NOT EXISTS (SELECT 1
                  FROM externallinks
                  WHERE el_from = rev_page
                    AND NOT (el_to LIKE 'http://geonames.nga.mil/%'
                             OR el_to LIKE 'https://geonames.nga.mil/%'
                             OR el_to LIKE '//geohack.toolforge.org/%'
                             OR el_to LIKE 'https://www.amar.org.ir/Portals/0/census/%'
                             OR el_to LIKE 'https://web.archive.org/%'));

SQL

Checking query status...