Country
SELECT DISTINCT b.BranchID, b.BranchName, b.CountryID FROM website.branches b WHERE
b.BranchID IN (SELECT DISTINCT(w.BranchID) FROM website.websites w WHERE
w.CountryID NOT IN (0,1,8,19,24,53,86,106,113,115,116,126,132,134,138,183,197,200,210,221,232,258,260,261,269)
AND w.ContactBranch NOT IN ('Asia Pacific', 'Argentina', 'Brazil', 'Chile', 'Mexico'))
ORDER BY b.BranchName = 'International', b.BranchNameCNAustria \nSELECT CountryID FROM website.websites WHERE CountryName = 'Austria'Belgium \nSELECT CountryID FROM website.websites WHERE CountryName = 'Belgium'Canada \nSELECT CountryID FROM website.websites WHERE CountryName = 'Canada'Czech Republic \nSELECT CountryID FROM website.websites WHERE CountryName = 'Czech Republic'Far Eastern Europe \nSELECT CountryID FROM website.websites WHERE CountryName = 'Georgia'France \nSELECT CountryID FROM website.websites WHERE CountryName = 'France'Germany \nSELECT CountryID FROM website.websites WHERE CountryName = 'Germany'Hungary \nSELECT CountryID FROM website.websites WHERE CountryName = 'Hungary'Ireland \nSELECT CountryID FROM website.websites WHERE CountryName = 'Ireland'Italy \nSELECT CountryID FROM website.websites WHERE CountryName = 'Italy'Latin America \nSELECT CountryID FROM website.websites WHERE CountryName = 'Chile'Lithuania \nSELECT CountryID FROM website.websites WHERE CountryName = 'Lithuania'Netherlands \nSELECT CountryID FROM website.websites WHERE CountryName = 'Netherlands'Nordic Region \nSELECT CountryID FROM website.websites WHERE CountryName = 'Denmark'Poland \nSELECT CountryID FROM website.websites WHERE CountryName = 'Poland'Romania \nSELECT CountryID FROM website.websites WHERE CountryName = 'Romania'Slovakia \nSELECT CountryID FROM website.websites WHERE CountryName = 'Slovakia'Spain \nSELECT CountryID FROM website.websites WHERE CountryName = 'Spain'Switzerland \nSELECT CountryID FROM website.websites WHERE CountryName = 'Switzerland'Ukraine \nSELECT CountryID FROM website.websites WHERE CountryName = 'Ukraine'United Kingdom \nSELECT CountryID FROM website.websites WHERE CountryName = 'United Kingdom'United States \nSELECT CountryID FROM website.websites WHERE CountryName = 'United States'Rest of the World \nSELECT CountryID FROM website.websites WHERE CountryName = 'International'
Language
Český (Czech)
English
Français (French)
Deutsch (German)
Magyar (Hungarian)
Italiano (Italian)
Polski (Polish)
Русский (Russian)
Română (Romanian)
Slovenský (Slovakian)
Español (Spanish)