-------------------------------------------------------
-- airline destinations
-------------------------------------------------------
SELECT 
    airlines.airline_id, airports.*
FROM
    airline_destinations
 JOIN 
    airlines
   ON
    airline_destinations.airline_id = airlines.airline_id
-- here the problem comes with the id, 
-- not all the airlines have been saved 
-- and not all the destinations have been saved with the same id we have for the airlines.
JOIN
    airports
ON
    airline_destinations.airport_id = airports.airport_id
WHERE
    airlines.airline_id
LIKE
    :name

