number of errors=15
number of warnings=0
country=NO
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='NO' order by countrycode,admincode1,admincode2,admincode3
geonameid countrycode admincode1 admincode2 admincode3 ansiname 6940966 NO 12 0301 01 Gamle Oslo District 6940975 NO 12 0301 02 Gruenerlokka District 6940976 NO 12 0301 03 Sagene District 6940977 NO 12 0301 04 St. Hanshaugen District 6940978 NO 12 0301 05 Frogner District 6940979 NO 12 0301 06 Ullern District 6940980 NO 12 0301 07 Vestre Aker District 6940981 NO 12 0301 08 Nordre Aker District 6940982 NO 12 0301 09 Bjerke District 6940983 NO 12 0301 10 Grorud District 6940985 NO 12 0301 12 Alna District 6940987 NO 12 0301 14 Nordstrand District 6940988 NO 12 0301 15 Sondre Nordstrand District 6940989 NO 12 0301 16 Sentrum 6940990 NO 12 0301 17 Marka