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

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