number of errors=0
number of warnings=0
country=AU
select geonameid,countrycode,admincode1,admincode2,admincode3,ansiname from geoname where featurecode = 'ADM3' and not exists (select 1 from geoname ppla3 where featurecode in ('PPLC','PPLA','PPLA2','PPLA3') and GEONAME.countryCode=ppla3.countryCode and GEONAME.admincode1=ppla3.admincode1 and GEONAME.admincode2=ppla3.admincode2 and GEONAME.admincode3=ppla3.admincode3) and countrycode='AU' order by countrycode,admincode1,admincode2,admincode3
geonameid countrycode admincode1 admincode2 admincode3 ansiname