2025-09-11     2025-09-12     2025-09-13

check countrycode and distance of served city

number of errors=0
number of warnings=0
Group=ckgGrpAirpIcao

select geonameid,name,countrycode,iata,icao from dmp_airport where isactive and iata is not null and icao is not null and cityid is null and name like '%International%'

geonameid	name	countrycode	iata	icao