Country Any Belgium Denmark France Germany Ireland Italy Luxembourg Netherlands Other countries Qatar Saudi Arabia Spain Sweden Switzerland UK United Arab Emirates
Location Any SELECT location.id_location,location.location FROM location INNER JOIN country_location ON country_location.id_location = location.id_location WHERE id_country = (SELECT id FROM country WHERE short='') ORDER BY location