number of errors=2
number of warnings=0
select countrycode,name,geonameid,admincode1 from geoname where featurecode='PPLA' and (admincode1 is null or admincode1='00' or not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.featurecode='ADM1')) order by countrycode
countrycode name geonameid admincode1 EH Laayoune 2462881 null EH Dakhla 2463447 CE