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.BranchNameCZAustria \nBelgium \nCanada \nCzech Republic \nSELECT CountryID FROM website.websites WHERE CountryName = 'Czech Republic'Far Eastern Europe \nFrance \nGermany \nHungary \nIreland \nItaly \nLatin America \nLithuania \nNetherlands \nNordic Region \nPoland \nRomania \nSlovakia \nSpain \nSwitzerland \nUkraine \nUnited Kingdom \nUnited States \nRest of the World \n
Language
Český
Nederlands (Dutch)
English
Français (French)
Deutsch (German)
Magyar (Hungarian)
Italiano (Italian)
Polski (Polish)
Русский (Russian)
Română (Romanian)
Slovenský (Slovakian)
Español (Spanish)
Warning: Content does not exist">