number of errors=31
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 Brezoaia 13302017 04 175260 V FRST 0 RO La Lacuraţii 13302296 04 175260 L FLD 0 RO La Crâng 13302256 04 175260 L FLD 0 RO Dealul Mocanului 13302125 04 175260 T HLL 0 RO Dealul Măcrişului 13302120 04 175260 T SLP 0 RO Valea Diaconeasa 13302000 04 175260 H RVN 0 RO Dealul Diaconeasa 13302007 04 175260 T HLL 0 RO Dealul Pârlituri 13301973 04 175787 T SLP 0 RO Valea Prisăcii 13302047 04 175787 H RVN 0 RO Dealul Cocârţa 13302229 04 175787 T SLP 0 RO Biserica Ortodoxă Lărgăşeni 13302006 04 175787 S CH 0 RO Pădurea Chiosu 13301989 04 176445 V FRST 0 RO Dealul Puieşti 13301778 07 165470 S TRIG 0 RO Haltă Paloş-Ardeal 13303465 20 40768 S RSTP 0 RO Poiana Grasa 13303504 20 40768 V MDW 0 RO Biserica Ortodoxă Drăuşeni 13303449 20 40768 S CH 0 RO Biserica Drăuşeni 13303603 20 40768 S CH 0 RO La Pruni 13303642 20 40768 V MDW 0 RO Dealul Gorgănelului 13303645 20 40768 T HLL 0 RO Lunca Pârâului 13303720 20 41248 V MDW 0 RO Dusul Mare 13305705 32 107083 S TRIG 0 RO Şindilitu 13299569 32 107662 T MT 0 RO Lacul Mozolea 13295036 35 127126 H MRSH 0 RO Pârâul Izvorul Mare 13304503 38 100308 H STMC 0 RO Biserica Şendreşti 13301658 38 23494 S CH 0 RO Iazul Bârca 13304647 38 97919 H PND 0 RO Dealul Ţiglău 13304619 38 98113 T HLL 0 RO Valea Tufeşti 13304439 38 98916 H STMI 0 RO Dealul Bodeşti 13304502 38 98916 T HLL 0 RO Dealul Ţarinii 13304479 38 99290 T HLL 0 RO Dealul Gogu 13301966 40 24524 T HLL 0