number of errors=127
number of warnings=0
Group=chkGrpShp
select countrycode,geonameid,name,admincode1 from geoname where featureclass='A' and geoname.featurecode='ADM1' and not exists (select countrycode from geoname_shape where level=2 and geoname_shape.countrycode=geoname.countrycode and geoname_shape.admincode1=geoname.admincode1) order by 1
[{key=AI,number=14}, {key=JE,number=12}, {key=CK,number=11}, {key=GG,number=11}, {key=MH,number=8}, {key=MO,number=8}, {key=TV,number=8}, {key=XK,number=7}, {key=KY,number=6}, {key=BS,number=4}, {key=KI,number=3}, {key=KZ,number=3}, {key=SC,number=3}, {key=TF,number=3}, {key=TK,number=3}, {key=TT,number=3}, {key=MA,number=2}, {key=MD,number=2}, {key=ME,number=2}, {key=PG,number=2}, {key=WS,number=2}, {key=GE,number=1}, {key=IL,number=1}, {key=KG,number=1}, {key=LA,number=1}, {key=LB,number=1}, {key=MK,number=1}, {key=MN,number=1}, {key=MT,number=1}, {key=SD,number=1}, {key=TM,number=1}]
countrycode geonameid name admincode1 AI 11205440 North Side 11205440 AI 11205438 South Hill 11205438 AI 11205437 West End 11205437 AI 11205433 East End 11205433 AI 11205442 George Hill 11205442 AI 11205393 Sandy Hill 11205393 AI 11205392 Sandy Ground 11205392 AI 11205439 The Quarter 11205439 AI 11205396 The Valley 11205396 AI 11205389 Blowing Point 11205389 AI 11205441 Island Harbour 11205441 AI 11205436 North Hill 11205436 AI 11205444 The Farrington 11205444 AI 11205443 Stoney Ground 11205443 BS 8030558 Spanish Wells District 53 BS 3572238 Harbour Island District 22 BS 3571815 New Providence District 23 BS 8030548 Hope Town District 43 CK 11695124 Aitutaki 11695124 CK 11695388 Penrhyn 11695388 CK 11695386 Mitiaro 11695386 CK 11695385 Ma'uke 11695385 CK 11695387 Palmerston 11695387 CK 11695390 Rakahanga 11695390 CK 11695126 Atiu 11695126 CK 11695425 Rarotonga 11695425 CK 11695389 Pukapuka 11695389 CK 11695384 Manihiki 11695384 CK 11695127 Mangaia 11695127 GE 611716 K'alak'i T'bilisi 51 GG 6417233 Saint Sampson 6417233 GG 6417229 Castel 6417229 GG 6417213 Saint Pierre du Bois 6417213 GG 8989934 Alderney 8989934 GG 6417223 Forest 6417223 GG 6417228 Saint Peter Port 6417228 GG 6417224 Saint Martin 6417224 GG 6417215 Saint Saviour 6417215 GG 6417226 Saint Andrew 6417226 GG 6417214 Torteval 6417214 GG 6417230 Vale 6417230 IL 11821181 Judea and Samaria Area WE JE 3237073 Saint Saviour 3237073 JE 3237221 Saint Peter 3237221 JE 3237072 Saint Clement 3237072 JE 3237497 Saint John 3237497 JE 3237200 Saint Brelade 3237200 JE 3237203 Grouville 3237203 JE 3237229 Saint Ouen 3237229 JE 3237864 Saint Helier 3237864 JE 3237530 Trinity 3237530 JE 3237716 Saint Martin 3237716 JE 3237212 Saint Mary 3237212 JE 3237214 Saint Lawrence 3237214 KG 10300944 Osh City 10 KI 4030940 Line Islands 02 KI 2110215 Gilbert Islands 01 KI 7521379 Phoenix Islands 03 KY 10375969 Bodden Town 10375969 KY 10375971 East End 10375971 KY 10375972 Sister Island 10375972 KY 10375968 West Bay 10375968 KY 10346796 George Town 10346796 KY 10375970 North Side 10375970 KZ 12510145 Ulytau Region 12510145 KZ 1537272 Shymkent 1537272 KZ 12510144 Jetisu Region 12510144 LA 11395958 Xaisomboun Province 28 LB 6201371 Mohafazat Baalbek-Hermel 11 MA 11281886 Dakhla-Oued Ed-Dahab 12 MA 11281885 Laâyoune-Sakia El Hamra 11 MD 858895 Gagauzia 51 MD 618363 Raionul Dubăsari 72 ME 12640530 Zeta 25 ME 12104729 Tuzi 24 MH 7303496 Bikar Atoll 060 MH 7303491 Ailinginae Atoll 007 MH 7303513 Bokak Atoll 073 MH 7303512 Taka Atoll 385 MH 7303511 Rongrik Atoll 360 MH 7303500 Erikub Atoll 100 MH 7303515 Ujelang Atoll 400 MH 7303520 Jemo Island 130 MK 11398357 Grad Skopje F6 MN 2055112 Govĭ-Sumber 24 MO 11875161 São Francisco Xavier 11875161 MO 11875155 Santo António 11875155 MO 11875156 São Lázaro 11875156 MO 11875158 São Lourenço 11875158 MO 11875154 Nossa Senhora de Fátima 11875154 MO 11875157 Sé 11875157 MO 11875159 Nossa Senhora do Carmo 11875159 MO 11875160 Cotai 11875160 MT 8299723 L-Imtarfa 24 PG 8521660 Jiwaka 22 PG 8521658 Hela 21 SC 11876017 Outer Islands 11876017 SC 12200079 Ile Perseverance I 12200079 SC 12200080 Ile Perseverance II 12200080 SD 408659 West Kordofan State 62 TF 6690916 Îles Éparses de l'océan Indien 05 TF 936339 Archipel des Crozet 02 TF 6690917 La Terre-Adélie 04 TK 4031112 Fakaofo F TK 4031091 Nukunonu N TK 4031116 Atafu A TM 162182 Ashgabat S TT 3573606 Tobago 11 TT 7521943 Point Fortin PTF TT 7521946 San Juan/Laventille SJL TV 2110341 Nui NUI TV 2110345 Nanumea NMA TV 7601981 Vaitupu VAI TV 2110384 Funafuti FUN TV 7601982 Nukufetau NKF TV 7601980 Nanumanga NMG TV 7601983 Nukulaelae NKL TV 7601979 Niutao NIT WS 4035314 Gaga‘emauga 05 WS 4035425 Aiga-i-le-Tai 02 XK 10097357 Gjilan District 10097357 XK 10096859 Gjakova District 10096859 XK 10097359 Pec District 10097359 XK 10097360 Pristina District 10097360 XK 10097361 Prizren District 10097361 XK 10097358 Mitrovica District 10097358 XK 10096138 Ferizaj District 10096138