number of errors=26
number of warnings=0
country=MX
select countrycode,name,geonameid,admincode1,admincode2,featureclass,featurecode,relevance from geoname where countrycode in ('MX') 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 ('MX')) order by relevance desc,admincode1,admincode2
countrycode name geonameid admincode1 admincode2 featureclass featurecode relevance MX El Vergel 13417276 07 049 P PPL 0 MX Venustiano Carranza 13437741 09 104 P PPLX 0 MX Chachamoles 13419938 10 049 P PPL 0 MX Mancera 13421223 11 113 P PPL 0 MX El Ranchito 13421229 11 113 P PPL 0 MX La Palma Cuata 13421529 12 082 P PPL 0 MX Majada de los Encinos 13421528 12 123 P PPL 0 MX Barranca Tecama 13421618 12 191 H RVN 0 MX La Trinidad 13421694 12 242 P PPL 0 MX Ciénega 13421267 22 031 P PPL 0 MX Las Hormigas 13423855 22 031 P PPL 0 MX Lagunita 13418699 22 031 P PPL 0 MX Ayim 13417683 23 079 P PPL 0 MX San Isidro 13417684 23 098 P PPL 0 MX Juntura Dos 13417685 23 098 P PPL 0 MX Chan-Suytum 13418169 23 102 P PPL 0 MX La Cobriza 13419525 25 026 P PPL 0 MX Colorado 13417624 25 029 P PPL 0 MX Los Alisos 13417623 25 029 P PPL 0 MX Batarapa 13417625 25 046 P PPL 0 MX El Ranchito 13424273 25 046 P PPL 0 MX Rancho Viejo 13417561 25 046 P PPL 0 MX El Corralón 13424272 25 046 P PPL 0 MX Malpaso 13422559 27 061 P PPL 0 MX Mayorazgo 13416604 28 123 P PPL 0 MX Tierra Blanca 13419978 32 061 P PPL 0