2025-06-19     2025-06-20     2025-06-21

countrysubdivs match countrycode

number of errors=0
number of warnings=0

select cc,countrycode,type from countrysubdivtype,countrysubdivision where countrysubdivision.countrysubdivtypeid=countrysubdivtype.typeid and cc<>countrycode

[]

cc	countrycode	type