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