LEFT JOIN bus ON bus.journey = vehicle_journey.code AND
ADDTIME(TIME(NOW()), SEC_TO_TIME(3600INNER JOIN vehicle_journey_days ON vehicle_journey_days.journey_reference = vehicle_journey.referenceINNER JOIN journey_pattern ON <em
SELECT journey.codeJOIN journey_day ON journey_day.journey = journey.codeJOIN link ON link.section = pattern.section
WHERE journey_day.day =5 AND TIME(NOW()) BETWEEN <