SELECT airline_destinations.airport_id,
       airlines.name,
       airport_cities.city_id
FROM airline_destinations
JOIN airlines ON airline_destinations.airline_id = airlines.airline_id
JOIN airports ON airports.airport_id = airline_destinations.airport_id
JOIN airport_cities ON airports.airport_id = airport_cities.airport_id
WHERE upper(airlines.name) LIKE upper(:name)