SELECT airports.name,
       airport_runways.direction,
       airport_runways.ft,
       airport_runways.m,
       airport_runways.surface
FROM airports
JOIN airport_runways ON airport_runways.airport_id = airports.airport_id
WHERE airports.name LIKE :name