valid admincode1,2,3 for DE

number of errors=22
number of warnings=0
country=DE

select countrycode,name,geonameid,admincode1,admincode2,admincode3,featureclass,featurecode,relevance from geoname where countrycode in ('DE') and not featureCode in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMD') and admincode1 is not null and admincode1<>'00' and admincode2 is not null and admincode3 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.admincode3=geoname.admincode3 and b.featurecode='ADM3' and b.countrycode in ('DE')) order by countrycode,admincode1,admincode2,admincode3

countrycode	name	geonameid	admincode1	admincode2	admincode3	featureclass	featurecode	relevance	
DE	Plönswerder	13463322	12	00	01003	T	ISL	0	
DE	Große Helle	13487531	12	00	12073	H	STM	0	
DE	Zollende	13487595	12	00	12073	P	PPL	0	
DE	Burgsee	13487535	12	00	12073	H	LK	0	
DE	Neuhof	13487625	12	00	12073	P	PPLL	0	
DE	Kleiner Eichberg	13487529	12	00	12073	T	HLL	0	
DE	Kleiner Peetzigsee	13487560	12	00	12073	H	LK	0	
DE	Fuchsberg	13487533	12	00	12073	T	HLL	0	
DE	Kaninchenberg	13487626	12	00	12073	T	HLL	0	
DE	Blumberger Mühle	13487554	12	00	12073	S	FRM	0	
DE	Glambecker Mühle	13487539	12	00	12073	S	FRM	0	
DE	Höllenberg	13487597	12	00	12073	T	HLL	0	
DE	Trefflochsberg	13487561	12	00	12073	T	HLL	0	
DE	Hessenhöhe	13487575	12	00	12073	P	PPLL	0	
DE	Hintenteich	13487606	12	00	12073	H	LK	0	
DE	Greiffenberg Siedlung	13487540	12	00	12073	P	PPLL	0	
DE	Müllerberge	13487609	12	00	12073	T	HLLS	0	
DE	Haßlebener Siedlung	13487534	12	00	12073	P	PPLL	0	
DE	Judenberg	13487574	12	00	12073	T	HLL	0	
DE	Großer Eichberg	13487582	12	00	12073	T	HLL	0	
DE	Weiler	13487583	12	00	12073	P	PPLF	0	
DE	Weinberg	13487564	12	00	12073	T	HLL	0