number of errors=226
number of warnings=0
select countrycode,admincode1,ansiname,geonameid from geoname where featurecode = 'ADM1' and admincode1 is not null and admincode1 <>'00' and countrycode || admincode1 not in (select countrycode || admincode1 from geoname where featurecode in ('PPLC','PPLA','PPLG') and countrycode is not null and admincode1 is not null and admincode1 <>'00') order by countrycode,admincode1
all countries, exeptions: skoje is ppla of 10 adm1
[{key=SC,number=19}, {key=BS,number=11}, {key=BM,number=10}, {key=CK,number=10}, {key=JE,number=10}, {key=MH,number=9}, {key=UM,number=9}, {key=MO,number=8}, {key=NR,number=7}, {key=CD,number=6}, {key=HK,number=6}, {key=LU,number=6}, {key=AZ,number=5}, {key=LV,number=5}, {key=MT,number=5}, {key=PH,number=5}, {key=BW,number=4}, {key=TF,number=4}, {key=BH,number=3}, {key=GG,number=3}, {key=IM,number=3}, {key=MA,number=3}, {key=SI,number=3}, {key=AG,number=2}, {key=AS,number=2}, {key=AX,number=2}, {key=CI,number=2}, {key=DZ,number=2}, {key=IN,number=2}, {key=KG,number=2}, {key=KI,number=2}, {key=MP,number=2}, {key=MV,number=2}, {key=OM,number=2}, {key=PF,number=2}, {key=RU,number=2}, {key=SB,number=2}, {key=TV,number=2}, {key=UA,number=2}, {key=YE,number=2}, {key=BB,number=1}, {key=BE,number=1}, {key=BF,number=1}, {key=BG,number=1}, {key=BY,number=1}, {key=CO,number=1}, {key=CV,number=1}, {key=CZ,number=1}, {key=ET,number=1}, {key=GE,number=1}, {key=GN,number=1}, {key=HR,number=1}, {key=HU,number=1}, {key=ID,number=1}, {key=IQ,number=1}, {key=LA,number=1}, {key=LC,number=1}, {key=LS,number=1}, {key=LY,number=1}, {key=MG,number=1}, {key=MK,number=1}, {key=MS,number=1}, {key=MX,number=1}, {key=MY,number=1}, {key=NO,number=1}, {key=PA,number=1}, {key=PG,number=1}, {key=RO,number=1}, {key=SN,number=1}, {key=SO,number=1}, {key=SR,number=1}, {key=SY,number=1}, {key=TJ,number=1}, {key=TL,number=1}, {key=TW,number=1}, {key=TZ,number=1}, {key=VE,number=1}, {key=WS,number=1}]
countrycode admincode1 ansiname geonameid AG 08 Parish of Saint Philip 3576015 AG 09 Redonda 3576037 AS 030 Rose Atoll 7309441 AS 050 Western District 5880873 AX 212 Alands landsbygd 9611692 AX 213 Alands skaergard 9611694 AZ 30 Lankaran Sahari 409418 AZ 47 Shaki Rayon 585031 AZ 56 Shusha 409419 AZ 61 Xankandi Sahari 409421 AZ 67 Yevlakh Rayon 584650 BB 03 Saint George 3373572 BE VLG Flanders 3337388 BF 13 Southwest Region 6930714 BG 58 Sofia 727012 BH 15 Muharraq Governorate 290333 BH 17 Southern Governorate 7090972 BH 19 Northern Governorate 7090974 BM 01 Devonshire Parish 3573251 BM 02 Hamilton 3573195 BM 04 Paget Parish 3573103 BM 05 Pembroke Parish 3573095 BM 06 Saint George 3573062 BM 07 Saint George's Parish 3573057 BM 08 Sandys Parish 3573050 BM 09 Smith's Parish 3573031 BM 10 Southampton Parish 3573026 BM 11 Warwick Parish 3572972 BS 22 Harbour Island District 3572238 BS 32 Berry Islands District 3571809 BS 38 Central Andros District 8030543 BS 42 Grand Cay District 8030547 BS 43 Hope Town District 8030548 BS 44 Mangrove Cay 8030549 BS 46 North Abaco District 8030551 BS 48 North Eleuthera District 8030553 BS 50 South Abaco District 8030555 BS 51 South Andros 8030556 BS 52 South Eleuthera 8030557 BW 08 North East District 933210 BW 16 Lobatse 11778171 BW 17 Selibe Phikwe 11778172 BW 18 Sowa Town 11778173 BY 05 Minsk Oblast 625142 CD 18 Kasai Province 214140 CD 19 Kwango 2313860 CD 21 Lomami 11288214 CD 22 Lualaba 922727 CD 25 Mongala 208741 CD 29 Tanganika 205253 CI 82 Lagunes 11153057 CI 98 Yamoussoukro Autonomous District 10629377 CK 11695124 Aitutaki 11695124 CK 11695126 Atiu 11695126 CK 11695127 Mangaia 11695127 CK 11695384 Manihiki 11695384 CK 11695385 Ma'uke 11695385 CK 11695386 Mitiaro 11695386 CK 11695387 Palmerston 11695387 CK 11695388 Penrhyn 11695388 CK 11695389 Pukapuka 11695389 CK 11695390 Rakahanga 11695390 CO 33 Departamento de Cundinamarca 3685413 CV 13 Concelho dos Mosteiros 3411924 CZ 88 Stredocesky kraj 3339576 DZ BB Bordj Badji Mokhtar 12226383 DZ IS In Salah 12226387 ET 51 Oromiya Region 444185 GE 70 Racha-Lechkhumi and Kvemo Svaneti 865542 GG 6417213 Saint Pierre du Bois 6417213 GG 6417223 Forest 6417223 GG 6417230 Vale 6417230 GN L Labe Region 8335089 HK HEA Eastern 7533608 HK HSO Southern 7533609 HK KKC Kowloon City 7533612 HK NIS Islands District 1819708 HK NKT Kwai Tsing 7533615 HK NNO North 7533617 HR 20 Zagreb County 3337531 HU 16 Pest megye 3046431 ID 40 Provinsi Kepulauan Riau 1996551 IM 9782171 German 9782171 IM 9782180 Lonan 9782180 IM 9782192 Rushen 9782192 IN 10 State of Haryana 1270260 IN 23 State of Punjab 1259223 IQ 19 Halabja Governorate 12218240 JE 3237073 Saint Saviour 3237073 JE 3237200 Saint Brelade 3237200 JE 3237203 Grouville 3237203 JE 3237212 Saint Mary 3237212 JE 3237214 Saint Lawrence 3237214 JE 3237221 Saint Peter 3237221 JE 3237229 Saint Ouen 3237229 JE 3237497 Saint John 3237497 JE 3237530 Trinity 3237530 JE 3237716 Saint Martin 3237716 KG 02 Chuyskaya Oblast' 1538652 KG 10 Osh City 10300944 KI 02 Line Islands 4030940 KI 03 Phoenix Islands 7521379 LA 28 Xaisomboun Province 11395958 LC 12 Canaries 11351387 LS 17 Qacha's Nek 932219 LU CA Capellen 2960696 LU CL Clervaux 2960683 LU EC Canton d'Echternach 2960629 LU ES Canton d'Esch-sur-Alzette 2960599 LU RM Remich 2960152 LU VD Vianden 2960020 LV 12 Jelgavas novads 459278 LV 24 Rezeknes Novads 456197 LV 33 Ventspils Municipality 454307 LV AN Augsdaugava Municipality 12276858 LV DN South Kurzeme Municipality 12276857 LY 65 Al Kufrah 88932 MA 08 Draa-Tafilalet 11281881 MA 11 Laayoune-Sakia El Hamra 11281885 MA 12 Dakhla-Oued Ed-Dahab 11281886 MG 27 Vatovavy Region 12494968 MH 007 Ailinginae Atoll 7303491 MH 060 Bikar Atoll 7303496 MH 070 Bikini Atoll 7303497 MH 073 Bokak Atoll 7303513 MH 100 Erikub Atoll 7303500 MH 130 Jemo Island 7303520 MH 360 Rongrik Atoll 7303511 MH 385 Taka Atoll 7303512 MH 400 Ujelang Atoll 7303515 MK 19 Cesinovo-Oblesevo 862977 MO 11875154 Nossa Senhora de Fatima 11875154 MO 11875155 Santo Antonio 11875155 MO 11875156 Sao Lazaro 11875156 MO 11875157 Se 11875157 MO 11875158 Sao Lourenco 11875158 MO 11875159 Nossa Senhora do Carmo 11875159 MO 11875160 Cotai 11875160 MO 11875161 Sao Francisco Xavier 11875161 MP 085 Northern Islands Municipality 7733156 MP 100 Rota Municipality 4041530 MS 02 Parish of Saint Georges 3578044 MT 08 Il-Fgura 8299707 MT 14 L-Ghasri 8299713 MT 42 Il-Qala 8299741 MT 45 Ir-Rabat 8299744 MT 51 Saint Lucia 8299750 MV 30 Alifu Atholhu 1282497 MV 40 Maale 1337624 MX 10 Estado de Durango 4011741 MY 12 Selangor 1733037 NO 01 Akershus fylke 3163480 NR 03 Anetan District 2110448 NR 06 Boe District 2110441 NR 07 Buada District 2110440 NR 08 Denigomodu District 2110437 NR 09 Ewa District 2110435 NR 11 Meneng District 2110431 NR 12 Nibok District 2110423 OM 02 Al Batinah South Governorate 411736 OM 09 Az Zahirah 411739 PA NT Naso Tjer Di 12508964 PF 03 Iles Tuamotu-Gambier 4030621 PF 05 Iles Australes 4034366 PG 01 Central Province 2133763 PH 01 Ilocos 7521301 PH 05 Bicol 7521310 PH 06 Western Visayas 7521304 PH 08 Eastern Visayas 7521307 PH 10 Northern Mindanao 7521295 RO 43 Ilfov 865518 RU 42 Leningrad Oblast 536199 RU 47 Moscow Oblast 524925 SB 06 Guadalcanal Province 2108831 SB 13 Rennell and Bellona 7280293 SC 01 Anse aux Pins 241450 SC 03 Anse Etoile 241447 SC 06 Baie Lazare 241439 SC 07 Baie Sainte Anne 241438 SC 09 Bel Air 241426 SC 11876017 Outer Islands 11876017 SC 12 Glacis 241336 SC 12200079 Ile Perseverance I 12200079 SC 12200080 Ile Perseverance II 12200080 SC 14 Grand Anse Praslin 241331 SC 17 Mont Buxton 241252 SC 18 Mont Fleuri 241251 SC 19 Plaisance 241224 SC 20 Pointe Larue 241221 SC 22 Saint Louis 241181 SC 24 Grand Anse Mahe 241330 SC 28 Au Cap 448410 SC 29 Les Mamelles 448408 SC 30 Roche Caiman 448409 SI 35 Hrpelje-Kozina 3239050 SI N7 Obcina Zirovnica 3344893 SI P1 Obcina Rence-Vogrsko 8133587 SN 07 Region de Thies 2244800 SO 21 Gobolka Awdal 6268943 SR 18 Distrikt Sipaliwini 3383062 SY 08 Damascus Countryside 170652 TF 01 Iles Saint-Paul et Nouvelle-Amsterdam 1547221 TF 02 Archipel des Crozet 936339 TF 04 La Terre-Adelie 6690917 TF 05 Iles Eparses de l'ocean Indien 6690916 TJ RR Districts of Republican Subordination 6452615 TL ER Ermera 1644865 TV NKL Nukulaelae 7601983 TV NMA Nanumea 2110345 TW 03 Taipei 7280290 TZ 31 Simiyu Region 8469238 UA 11 Autonomous Republic of Crimea 703883 UA 13 Kyiv Oblast 703446 UM 050 Baker Island 5854907 UM 100 Howland Island 5854922 UM 150 Jarvis Island 5854926 UM 200 Johnston Atoll 5854929 UM 250 Kingman Reef 5854936 UM 300 Midway Atoll 5854943 UM 350 Navassa Island 4743755 UM 400 Palmyra Atoll 5854952 UM 450 Wake Atoll 4041685 VE 24 Dependencias Federales 3640846 WS 05 Gaga'emauga 4035314 YE 16 Sanaa 71132 YE 28 Socotra 9645387