SELECT * FROM tour LEFT JOIN boat on tour.boatID = boat.boatID
LEFT JOIN boat_en ON boat_en.boatID = boat.boatID
LEFT JOIN country on tour.countryID = country.countryID
LEFT JOIN country_en ON country_en.countryID = country.countryID
LEFT JOIN itinerary on tour.itineraryID = itinerary.itineraryID
LEFT JOIN itinerary_en ON itinerary_en.itineraryID = itinerary.itineraryID WHERE tour.boatID = 46198831 AND tour.itineraryID = language AND tour.dateStart = 'ru';
Неправильный запрос