each adm should be within bounding box of parent ADM3

number of errors=12
number of warnings=0
Group=chkGrpBBox

select l.geonameid,l.countrycode,l.name,l.featurecode,p.geonameid,p.name,p.featurecode from geoname l,geoname p, geoname_bbox b where l.featurecode in ('ADM3','ADM4','ADM5') and p.featurecode='ADM3' and l.countrycode=p.countrycode and l.admincode1=p.admincode1 and l.admincode2=p.admincode2 and l.admincode3=p.admincode3 and p.geonameid=b.geonameid and (south>l.longlat[1] or l.longlat[1]>north or (westeast)) or (west>east and ((l.longlat[0]<0 and l.longlat[0]>west) or (l.longlat[0]>0 and l.longlat[0]

[{key=PH,number=5}, {key=BD,number=3}, {key=IN,number=2}, {key=KR,number=1}, {key=RW,number=1}]

geonameid	countrycode	name	featurecode	geonameid	name	featurecode	
11285108	BD	Dakshin Natai	ADM4	7645701	Brahmanbaria S.	ADM3	
11286968	BD	Sadekpur	ADM4	7645701	Brahmanbaria S.	ADM3	
11285196	BD	Hatiya	ADM4	7646893	Hatiya	ADM3	
12685116	IN	Vatva	ADM3	12685116	Vatva	ADM3	
12684936	IN	Tarak Lengdi Cicle	ADM3	12684936	Tarak Lengdi Cicle	ADM3	
8691955	KR	Sinin-dong	ADM3	8691955	Sinin-dong	ADM3	
12046537	PH	Mabato-Azufre	ADM4	1695286	Pangil	ADM3	
11815342	PH	Guinhawa	ADM4	1682621	Taysan	ADM3	
12046533	PH	Ilaya del Norte	ADM4	1696719	Paete	ADM3	
12046543	PH	Ilaya del Sur	ADM4	1696719	Paete	ADM3	
11815343	PH	Makina	ADM4	1728254	Balete	ADM3	
11187022	RW	Karama	ADM4	11186479	Gishamvu	ADM3