number of errors=23
number of warnings=83
Group=chkGrpSubdivision
select countrycode,name,iso_3166_2,fips,geonamesadmcode,case when iso_3166_2 is not null and fips is not null then 'ERR' else 'WRN' end as ERRWRN from countrysubdivision where geonameslevel>0 and subdivisionid is null and not countrycode in ('CS') and not (countrycode='US' and iso_3166_2 in ('AS','GU','MP','PR','UM','VI')) and not (countrycode='FR' and iso_3166_2 in ('CP','BL','MF','NC','PF','PM','TF','WF','YT')) and not (countrycode='NO' and iso_3166_2 in ('21','22')) and not (countrycode='FI' and iso_3166_2 in ('01')) and validtill is null order by countrycode,name
Number of countries=16;
[{key=HU,number=23}, {key=MC,number=17}, {key=TC,number=14}, {key=IO,number=8}, {key=ID,number=7}, {key=RS,number=6}, {key=CC,number=5}, {key=SG,number=5}, {key=CK,number=4}, {key=HM,number=4}, {key=CN,number=3}, {key=GW,number=3}, {key=GQ,number=2}, {key=KN,number=2}, {key=SC,number=2}, {key=TH,number=1}]
countrycode name iso_3166_2 fips geonamesadmcode errwrn CC Direction Island D null null WRN CC Home Island H null null WRN CC Horsburgh Island O null null WRN CC South Island S null null WRN CC West Island W null null WRN CK Manuae null null null WRN CK Nassau Island null null null WRN CK Surwarrow null null null WRN CK Takutea null null null WRN CN Aomen MO null null WRN CN Taiwan TW null null WRN CN Xianggang HK null null WRN GQ Región Continental C null null WRN GQ Región Insular I null null WRN GW Leste L null null WRN GW Norte N null null WRN GW Sul S null null WRN HM Flat Island F null null WRN HM Heard Island H null null WRN HM McDonald Island M null null WRN HM Shag Island S null null WRN HU Békéscsaba BC 26 26 ERR HU Debrecen DE 07 07 ERR HU Dunaújváros DU 27 27 ERR HU Eger EG 28 28 ERR HU Erd ER 43 43 ERR HU Győr GY 25 25 ERR HU Hódmezővásárhely HV 29 29 ERR HU Kaposvár KV 30 30 ERR HU Kecskemét KM 31 31 ERR HU Miskolc MI 13 13 ERR HU Nagykanizsa NK 32 32 ERR HU Nyíregyháza NY 33 33 ERR HU Pécs PS 15 15 ERR HU Salgótarján ST 41 41 ERR HU Sopron SN 34 34 ERR HU Szeged SD 19 19 ERR HU Székesfehérvár SF 35 35 ERR HU Szekszárd SS 42 42 ERR HU Szolnok SK 36 36 ERR HU Szombathely SH 37 37 ERR HU Tatabánya TB 38 38 ERR HU Veszprém VM 39 39 ERR HU Zalaegerszeg ZE 40 40 ERR ID Java JW null null WRN ID Kalimantan KA null null WRN ID Maluku ML null null WRN ID Nusa Tenggara NU null null WRN ID Papua PP null null WRN ID Sulawesi SL null null WRN ID Sumatera SM null null WRN IO Danger Island DI null null WRN IO Diego Garcia DG null null WRN IO Eagle Islands EA null null WRN IO Egmont Islands EG null null WRN IO Nelsons Island NI null null WRN IO Peros Banhos PB null null WRN IO Salomon Islands SI null null WRN IO Three Brothers TB null null WRN KN Nevis N null null WRN KN Saint Kitts K null null WRN MC Fontvieille FO null null WRN MC Jardin Exotique JE null null WRN MC La Colle CL null null WRN MC La Condamine CO null null WRN MC La Gare GA null null WRN MC Larvotto LA null null WRN MC La Source SO null null WRN MC Malbousquet MA null null WRN MC Monaco-Ville MO null null WRN MC Moneghetti MG null null WRN MC Monte-Carlo MC null null WRN MC Moulins MU null null WRN MC Port-Hercule PH null null WRN MC Sainte-Dévote SD null null WRN MC Saint-Roman SR null null WRN MC Spélugues SP null null WRN MC Vallon de la Rousse VR null null WRN RS Kosovo KM null null WRN RS Kosovski okrug 25 null null WRN RS Kosovsko-Mitrovački okrug 28 null null WRN RS Kosovsko-Pomoravski okrug 29 null null WRN RS Pećki okrug 26 null null WRN RS Prizrenski okrug 27 null null WRN SC Ile Perseverance I 27 null null WRN SC Ile Perseverance II 26 null null WRN SG Central Singapore 01 null 01 WRN SG North East 02 null 02 WRN SG North West 03 null 03 WRN SG South East 04 null 04 WRN SG South West 05 null 05 WRN TC Ambergris Cays AC null null WRN TC Dellis Cay DC null null WRN TC East Caicos EC null null WRN TC French Cay FC null null WRN TC Grand Turk GT null null WRN TC Little Water Cay LW null null WRN TC Middle Caicos MC null null WRN TC North Caicos NC null null WRN TC Parrot Cay RC null null WRN TC Pine Cay PN null null WRN TC Providenciales PR null null WRN TC Salt Cay SL null null WRN TC South Caicos SC null null WRN TC West Caicos WC null null WRN TH Pattaya S null S WRN