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 = 46198834 AND tour.itineraryID = images AND tour.dateStart = '5af87100147ee3eb1b3d0144_5af20a4ab75307b45ac4f174__.png';

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