number of errors=46
number of warnings=0
country=FI
select geonameid,countrycode,admincode1,admincode2,ansiname from geoname where featurecode = 'ADM2' and admincode1 is not null and admincode1 <>'00' and admincode2 is not null and countrycode || admincode1 || admincode2 not in (select countrycode || admincode1 || admincode2 from geoname where featurecode in ('PPLC','PPLA','PPLA2') and countrycode is not null and admincode1 is not null and admincode1 <>'00' and admincode2 is not null) and countrycode='FI' order by countrycode,admincode1,admincode2
geonameid countrycode admincode1 admincode2 ansiname 9610695 FI 01 014 Raaseporin 9610696 FI 01 015 Porvoo 9610697 FI 01 016 Loviisa 9610642 FI 02 021 Aboland-Turunmaa 9610643 FI 02 022 Salo 9610675 FI 02 024 Vakka-Suomi 9610676 FI 02 025 Loimaa 9610678 FI 04 041 Rauma 9610680 FI 04 044 Pohjois-Satakunta 9610682 FI 05 052 Riihimaeki 9610683 FI 05 053 Forssa 9610684 FI 06 061 Luoteis-Pirkanmaa 9610685 FI 06 063 Etelae-Pirkanmaa 9610687 FI 06 068 Lounais-Pirkanmaa 9610688 FI 06 069 Ylae-Pirkanmaa 9610691 FI 08 082 Kotka-Hamina 9610693 FI 09 093 Imatra 9610644 FI 10 103 Savonlinna 9610645 FI 10 105 Pieksaemaeki 9610646 FI 11 111 Ylae-Savo 9610648 FI 11 113 Koillis-Savo 9610649 FI 11 114 Varkaus 9610650 FI 11 115 Sisae-Savo 9610652 FI 12 124 Keski-Karjala 9610653 FI 12 125 Pielisen Karjala 9610655 FI 13 132 Joutsa 9610657 FI 13 133 Keuruu 9610658 FI 13 134 Jaemsae 9610659 FI 13 135 AEaenekoski 9610660 FI 13 138 Saarijaervi-Viitasaari 9610661 FI 14 141 Suupohja 9610664 FI 14 144 Kuusiokunnat 9610665 FI 14 146 Jaerviseutu 9610576 FI 15 153 Sydosterbotten 9610669 FI 15 154 Jakobstadsregionen 9610670 FI 16 161 Kaustinen 9610673 FI 17 173 Oulunkaari 9610699 FI 17 175 Haapavesi-Siikalatva 9610701 FI 17 177 Ylivieska 9610702 FI 17 178 Koillismaa 9610703 FI 18 181 Kehys-Kainuu 9610706 FI 19 192 Kemi-Tornio 9610707 FI 19 193 Torniolaakso 9610708 FI 19 194 Itae-Lappi 9610709 FI 19 196 Tunturi-Lappi 9610712 FI 19 197 Pohjois-Lappi