number of errors=1
number of warnings=0
Group=chkGrpSubdivision
select countrysubdivision.countrycode,featurecode,geoname.geonameid,geoname.ansiname, geonameslevel,admlevel from geoname,countrysubdivision where geonameid = subdivisionid and featurecode='ADM2' and (geonameslevel<>2 or geonameslevel is null) order by 1
[{key=FR,number=1}]
countrycode featurecode geonameid ansiname geonameslevel admlevel FR ADM2 3038033 Alsace 1 1