number of errors=12
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 La Verigă 13257345 22 92961 V FRST 0 RO Pârâul Vălcănescu 13259419 25 34618 H STMI 0 RO Pârâul Gavriluvca 13259376 34 106746 H STMI 0 RO Pârâul pre Stânci 13259414 34 106746 H STMI 0 RO Pârâul Măgura Mare 13259386 34 106746 H STMI 0 RO Pârâul Prinosul Mare 13259415 34 34618 H STMI 0 RO Pădurea Gimbăşeanca 13259543 41 93021 V FRST 0 RO Valea Grecului 13259508 41 93236 H RVN 0 RO Picioruş 13259525 41 93236 T HLL 0 RO La Marinache 13259495 41 94376 S FRM 0 RO Jegălia Fermă 13259512 41 94535 L FLD 0 RO Moraviţa-Varsac Vatin 13306352 VO 4 S PSTB 0