number of errors=24
number of warnings=0
country=RO
select countrycode,name,geonameid,admincode1,admincode2,featureclass,featurecode,relevance from geoname where countrycode in ('RO') and not featureCode in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMD') and not featurecode in ('STM') and admincode1 is not null and admincode1<>'00' and admincode2 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.featurecode='ADM2' and b.countrycode in ('RO')) order by relevance desc,admincode1,admincode2
countrycode name geonameid admincode1 admincode2 featureclass featurecode relevance RO Cabana Podragu 13403000 03 42101 S GHSE 0 RO Gruiul de Vârf 13395720 05 11236 T SPUR 0 RO Vârful Arpaşul Mare 13403201 09 14049 T PK 0 RO Lacul Iezer 13403200 09 14049 L RESN 0 RO Izvorul Bândea 13402999 09 17771 H SPNG 0 RO Lacul Geamăna de Jos 13403003 09 17771 H LK 0 RO Lacul Geamăna de Sus 13403276 09 17771 H LK 0 RO La Livezi 13397865 12 157031 L FLD 0 RO Movila lui Grosu 13358129 14 159963 T HLL 0 RO Dealul Saxanului 13358084 14 159963 T RDGE 0 RO Valea Măgurei 13357221 16 18331 H CNL 0 RO Pădurea Tihuleşti 13358472 18 166770 V FRST 0 RO Pădurea Plopeanca 13393710 29 153623 V FRST 0 RO Valea Vreaua 13393767 29 153623 H STMI 0 RO Dudu 13393687 29 153623 S CMP 0 RO Rudari 13393801 29 155083 V FRST 0 RO Vârful Ştefleşti 13361868 33 174254 S TRIG 0 RO Valea Cioara 13373258 35 128472 H RVN 0 RO Balta Crivinoaga 13393694 35 129040 H MRSH 0 RO Dealul Cărpănos 13397624 36 52785 T RDGE 0 RO Păntuţa 13361499 39 143735 T SLP 0 RO Făgetul Panţi 13361640 39 143735 T SLP 0 RO Pârâul Lotriorul 13361604 39 145827 H STMI 0 RO Fărcaşul 13361679 39 146021 T SPUR 0