number of errors=26
number of warnings=0
country=FI
select countrycode,name,geonameid,admincode1,admincode2,admincode3,featureclass,featurecode,relevance from geoname where countrycode in ('FI') and not featureCode in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMD') and admincode1 is not null and admincode1<>'00' and admincode2 is not null and admincode3 is not null and not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.admincode2=geoname.admincode2 and b.admincode3=geoname.admincode3 and b.featurecode='ADM3' and b.countrycode in ('FI')) order by countrycode,admincode1,admincode2,admincode3
countrycode name geonameid admincode1 admincode2 admincode3 featureclass featurecode relevance FI Haukilahti 13175302 11 105 593 H COVE 0 FI Haukiniemi 13175485 11 105 593 T PT 0 FI Likolahti 13175507 11 105 593 H COVE 0 FI Apteekkarinniemi 13175286 11 105 593 T PT 0 FI Gåsjärvträsket 13191100 15 161 236 H LK 0 FI Dubbas 13185229 15 162 272 L FLD 0 FI Ladugrundet 13184365 15 162 272 T PT 0 FI Pentholmspotten 13184608 16 154 288 H PNDI 0 FI Rödningen 13190907 16 154 288 H SWMP 0 FI Retumaa 13190998 16 154 288 H SWMP 0 FI Storkärret 13191015 16 154 288 L FLD 0 FI Fårgrunden 13184314 16 154 440 T PT 0 FI Heinistönjärvi 13182878 16 177 208 H PND 0 FI Heinistönneva 13182946 16 177 208 H SWMP 0 FI Mikkonniittu 13182833 16 177 208 H SWMP 0 FI Ymmyräiskangas 13182798 16 177 208 V FRST 0 FI Kivikangas 13182610 16 177 208 T HLL 0 FI Pahikaisenjärvi 13187390 16 177 208 H PND 0 FI Raasakka 13187089 16 177 208 L FLD 0 FI Kivikankahanräme 13183046 16 177 208 L FLD 0 FI Kärryladonniemi 13182580 16 177 208 V FRST 0 FI Hietakangas 13182859 16 177 208 L CLG 0 FI Uusi-Somero 13182384 16 177 208 T HLLS 0 FI Myllykangas 13187100 16 177 208 V FRST 0 FI Kuustonkangas 13186276 17 162 217 L CLG 0 FI Runsas 13187448 17 162 217 V FRST 0