number of errors=1
number of warnings=0
select countrycode,admincode1,admincode2,ansiname,geonameid from geoname where featurecode = 'ADM2' and (admincode1 is null or admincode1='' or admincode2 is null or admincode2='') order by countrycode,ansiname
countrycode admincode1 admincode2 ansiname geonameid CN null 8739734 Chongqing 8739734