number of errors=10
number of warnings=0
country=DK
select geonameid,countrycode,admincode1,admincode2,admincode3,ansiname from geoname where featurecode = 'ADM3' and not exists (select 1 from geoname ppla3 where featurecode in ('PPLC','PPLA','PPLA2','PPLA3') and GEONAME.countryCode=ppla3.countryCode and GEONAME.admincode1=ppla3.admincode1 and GEONAME.admincode2=ppla3.admincode2 and GEONAME.admincode3=ppla3.admincode3) and countrycode='DK' order by countrycode,admincode1,admincode2,admincode3
geonameid countrycode admincode1 admincode2 admincode3 ansiname 13308799 DK 17 101 1 Indre By 13308793 DK 17 101 10 Amager Vest 13308795 DK 17 101 2 Osterbro 13308800 DK 17 101 3 Norrebro 13308794 DK 17 101 4 Vesterbro-Kongens Enghave 13308796 DK 17 101 5 Valby 13308798 DK 17 101 6 Vanlose 13308797 DK 17 101 7 Bronshoj-Husum 13308801 DK 17 101 8 Bispebjerg 13308802 DK 17 101 9 Amager Ost