2025-02-28     2025-03-01     2025-03-02

adm2 without ppla2

number of errors=0
number of warnings=0
country=SE

select geonameid,countrycode,admincode1,admincode2,ansiname from geoname where featurecode = 'ADM2' and admincode1 is not null and admincode1 <>'00' and admincode2 is not null and countrycode || admincode1 || admincode2 not in (select countrycode || admincode1 || admincode2 from geoname where featurecode in ('PPLC','PPLA','PPLA2') and countrycode is not null and admincode1 is not null and admincode1 <>'00' and admincode2 is not null) and countrycode='SE' order by countrycode,admincode1,admincode2

geonameid	countrycode	admincode1	admincode2	ansiname