SELECT country.countryID, country.countryURL, country_en.countryName, country_en.countrySeason, country.countryTemperature, country.countryWhaterTemperature FROM country LEFT JOIN country_en ON country.countryID = country_en.countryID LEFT JOIN itinerary_country ON itinerary_country.countryID = country.countryID WHERE itinerary_country.itineraryID = LIMIT 1 OFFSET 0;

Неправильный запрос