2025-06-28     2025-06-29     2025-06-30

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