number of errors=4
number of warnings=0
country=NL
select countrycode,provider,name,featurecode,code,admincode1,admincode2,admincode3,admincode4,admincode5,geonameid from countrysubdiv_code where validtill is null and not exists (select 1 from geoname where geoname.countrycode='NL' and geoname.featurecode='ADM2' and geoname.admincode1=countrysubdiv_code.admincode1 and geoname.admincode2=countrysubdiv_code.admincode2) and countrycode='NL' and featurecode='ADM2' and provider='cbs' order by admincode1,admincode2,admincode3,admincode4,admincode5
345 from cbs
countrycode provider name featurecode code admincode1 admincode2 admincode3 admincode4 admincode5 geonameid NL cbs Weesp ADM2 270457 07 0457 null null null 2744903 NL cbs Brielle ADM2 280501 11 0501 null null null 2758325 NL cbs Hellevoetsluis ADM2 280530 11 0530 null null null 2754453 NL cbs Westvoorne ADM2 280614 11 0614 null null null 2744605