No region names for canada. about countries-regions-cities HOT 2 OPEN

update countries set name = 'Guernsey' where code = 'gg';
update regions set name = 'British Columbia' where id = 486;
update regions set name = 'Saskatchewan' where id = 487;
update regions set name = 'Quebec' where id = 488;
update regions set name = 'Alberta' where id = 489;
update regions set name = 'Newfoundland and Labrador' where id = 490;
update regions set name = 'Ontario' where id = 491;
update regions set name = 'Nova Scotia' where id = 492;
update regions set name = 'Yukon' where id = 493;
update regions set name = 'Northwest Territories' where id = 494;
update regions set name = 'Nunavut' where id = 495;
update regions set name = 'Prince Edward Island' where id = 496;
update regions set name = 'New Brunswick' where id = 497;
update regions set name = 'Manitoba' where id = 498;

SELECT C.name, R.id FROM regions R
LEFT OUTER JOIN cities C
ON C.region_id = R.id
WHERE R.country_id = 33;