number of errors=74
number of warnings=0
country=AT
select countrycode,name,geonameid,admincode1,admincode2,admincode3,featureclass,featurecode,relevance from geoname where countrycode in ('AT') 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 ('AT')) order by countrycode,admincode1,admincode2,admincode3
countrycode name geonameid admincode1 admincode2 admincode3 featureclass featurecode relevance AT Alplhorn 2958192 02 091 09172 T PK 5 AT Leiterhorn 2917997 02 091 09172 T MT 5 AT Persilkopf 2854806 02 091 09172 T PK 3 AT Niederbrunnsulzen Kogel 2917401 02 091 09172 T MT 4 AT Drei Jäger 2935154 02 091 09172 T PK 3 AT Großes Palfelhorn 2915710 02 091 09172 T PK 4 AT Lerchkogel 2878508 02 091 09173 T MT 5 AT Burgberg 2941428 02 091 09180 T MT 4 AT Wetterwandeck 2809948 02 091 09180 T MT 6 AT Steinkarl Spitze 2827882 02 091 09180 T PK 4 AT Untere Wettersteinspitze 2819597 02 091 09180 T MT 5 AT Kotbach Spitze 2902903 02 091 09180 T PK 5 AT Bäralpel Kopf 2952529 02 091 09180 T PK 5 AT Vordere Schlichtenkarspitze 2816311 02 091 09180 T PK 4 AT Wörner 2806130 02 091 09180 T MT 6 AT Lerchfleckspitze 2878509 02 091 09180 T MT 5 AT Nesselberg 2866436 02 091 09182 T MT 4 AT Planberg 2947950 02 091 09182 T MT 5 AT Reinhardsberg 2848794 02 091 09187 T MT 4 AT Scheibelberg 2840041 02 091 09189 T MT 3 AT Schwarzenberg 2834992 02 097 09777 T MT 4 AT Rauhhorn 2849946 02 097 09780 T MT 6 AT Schänzlekopf 2840431 02 097 09780 T MT 6 AT Muttlerkopf 2867307 02 097 09780 T MT 4 AT Wiedhag 2809564 02 097 09780 T MT 4 AT Fiderepaß 2926920 02 097 09780 T PASS 4 AT Hammerspitzen 2835632 02 097 09780 T PK 4 AT Rauheck 2850003 02 097 09780 T MT 6 AT B’schießer 2942966 02 097 09780 T MT 4 AT Obere Gottesackerwände 2860999 02 097 09780 T MT 6 AT Lechler Kanz 2879777 02 097 09780 T MT 3 AT Nösslbach 2770423 04 413 41308 P PPL 3 AT Lamberg 2773108 04 413 41308 S FRM 1 AT Reith 2767609 04 413 41308 P PPL 3 AT Fürling 2779121 04 413 41308 P PPL 3 AT Gintersberg 2778551 04 413 41308 P PPL 3 AT Hehenberg 2776606 04 413 41308 P PPL 3 AT Katzing 2774602 04 413 41308 P PPL 3 AT Perwolfing 2769051 04 413 41308 P PPL 3 AT Bahnhof Aigen-Schlägl 2782859 04 413 41308 S RSTN 1 AT Gattergassling 2778792 04 413 41308 P PPL 3 AT Harau 2776882 04 413 41308 P PPL 3 AT Lanzerstorf 2772940 04 413 41330 P PPL 4 AT Gries 11919633 05 506 50205 P PPL 3 AT Pongratzen 2768523 06 603 60303 P PPL 3 AT Pesendorf 2781810 06 610 61031 P PPL 4 AT Lappach 2772934 06 610 61031 P PPL 3 AT Rosenbichl 2607796 06 610 61031 T HLL 3 AT Rainerkapelle 2607798 06 610 61031 S CH 1 AT Baldauberg 2607802 06 610 61031 P PPL 3 AT Hollbauer 2607755 06 610 61031 S FRM 1 AT Mitteregg 2607797 06 610 61031 P PPL 3 AT Baldau 2782026 06 610 61031 P PPL 3 AT Kurzragnitz 2773234 06 610 61031 P PPL 3 AT Alla 2782804 06 610 61040 P PPL 3 AT Stiefing 2764334 06 610 61040 P PPL 3 AT Schwasdorf 2765392 06 610 61040 P PPL 3 AT Aug 2782187 06 610 61040 P PPL 3 AT Hart bei Wildon 2776806 06 610 61040 P PPL 4 AT Lichendorf 2772557 06 610 61046 P PPL 3 AT Greith 2778027 06 610 61046 P PPL 3 AT Schloss Weissenegg 2761600 06 610 61046 S CSTL 1 AT Wurzing 2760781 06 610 61047 P PPL 3 AT Zanitzen 2760739 06 620 62016 P PPL 3 AT Moos 11592986 06 620 62029 P PPL 3 AT Fressenberg 11592995 06 620 62029 P PPL 3 AT Fötschach 11592984 06 620 62030 P PPL 3 AT Fluttendorf 2779455 06 623 62346 P PPL 3 AT Passo Giramondo 2773142 06 UD 030040 T PASS 5 AT Giogo Veranis 3164568 06 UD 030040 T PASS 5 AT Dosso Gais 3176409 06 UD 030054 T MT 5 AT Großer Pal 3171604 06 UD 030071 T MT 5 AT Passo Pecol di Ciaula 3171349 06 UD 030073 T PASS 4 AT Kronalpe 3178032 06 UD 030076 T MT 4