number of errors=6
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 Pădurea Lepşa 13352730 15 178117 V FRST 0 RO Grindul Butucului 13310841 18 160458 L FLD 0 RO Valea Malului 13328536 34 18581 H RVN 0 RO Valea Babidrogani 13314760 35 103194 H RVN 0 RO Lacul Plămânariu 13314721 42 153589 H CNL 0 RO Pădurea Zarancu 13314700 42 153589 V FRST 0