each adm3 lat/lng should be within its bounding box

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

select geoname.geonameid,countrycode,name,admincode1 as adm1,featureclass as fcl,geoname.featurecode as fcode,'http://map.immofacts.ch/servlet/geonames?srv=781&lat=' || GEONAME.longlat[1] || '&lng=' || GEONAME.longlat[0] as shape from geoname_bbox,geoname where geoname.geonameid=geoname_bbox.geonameid and (south>longlat[1] or longlat[1]>north or (westeast)) or (west>east and ((longlat[0]<0 and longlat[0]>west) or (longlat[0]>0 and longlat[0]

[{key=IN,number=2}, {key=KR,number=1}]

geonameid	countrycode	name	adm1	fcl	fcode	shape	
12685116	IN	Vatva	09	A	ADM3	http://map.immofacts.ch/servlet/geonames?srv=781&lat=22.966&lng=72.649	
12684936	IN	Tarak Lengdi Cicle	30	A	ADM3	http://map.immofacts.ch/servlet/geonames?srv=781&lat=27.757&lng=93.84	
8691955	KR	Sinin-dong	19	A	ADM3	http://map.immofacts.ch/servlet/geonames?srv=781&lat=36.321&lng=127.441