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/%'));