SELECT offers.offerid
FROM offers
JOIN (SELECT flights.flightsid  FROM flights    ORDER BY depdatetime    LIMIT 1)
ON offers.flightsid = firstflight.flightsid
JOIN flights ON  offers.flightsid = flights.flightsid
WHERE flights.depid = 'LHR';