number of errors=10
number of warnings=0
Group=chkGrpUnlocode
select cc,code,countrycode,cc2,unlocode.name,geoname.name,geoname.featurecode,geoname.geonameid from UNLOCODE20241 as unlocode,geoname where geoname.geonameid=unlocode.geonameid and unlocode.cc <> countrycode and cc <> coalesce(cc2,'')
cc code countrycode cc2 name name featurecode geonameid AS API WS null Apia Apia Harbour BAY 4035412 CL CIQ AR null Paso Coyhaique/Coyhaique Paso Coihaique Alto PASS 3894422 ET MYS KE null Moyale Moyale PPL 186180 GB PPO GG null Saint Peter Port Saint Peter Port PPLC 3042287 GP MSB MF FR Marigot Marigot Sea Plane Base AIRS 8521389 IR AEU AE AE,IR Abu Musa Abū Mūsá PPL 400747 JP SMU RU null Sakimui Sakimui PPL 2121519 SZ UBO MZ MZ,ZA Ubombo Lebombo Mountains HLLS 984093 ZM TDM TZ null Tunduma Tunduma PPL 149402 SY WST IL null Wasit Wāsiţ PPLQ 162659