EXPLAIN
SELECT TIMESTAMP(cal.cal_date, time_départ.departure_time) AS départ
     , TIMESTAMP(cal.cal_date, time_arrivée.arrival_time) AS arrivée
     , trip.headsign
     , route.long_name
FROM tec_trips trip
INNER JOIN tec_routes route
  ON route.id = trip.route_id
INNER JOIN tec_calendar_dates cal
  ON cal.service_id = trip.service_id
 AND cal.cal_date = DATE('2026-06-27')
INNER JOIN tec_stop_times time_départ
  ON trip.id = time_départ.trip_id
 AND time_départ.departure_time > TIME('00:00:00')
INNER JOIN tec_stop_times time_arrivée
  ON trip.id = time_arrivée.trip_id
 AND time_arrivée.arrival_time > time_départ.departure_time
INNER JOIN tec_stops départ
  ON départ.id = time_départ.stop_id
 AND départ.name = 'Montpellier Saint-Roch'
INNER JOIN tec_stops arrivée
  ON arrivée.id = time_arrivée.stop_id
 AND arrivée.name = 'Strasbourg'
WHERE 1=1
ORDER BY départ;