| $sql = "SELECT st.*, t.*, r.*, strftime('%Y%m%d', '22:34:12') as today, strftime('%Y%m%d', '22:34:12', '1 day') as tomorrow, time('22:34:12') as now |
| ON st.trip_id = t.trip_id |
| ON t.route_id = r.route_id |
| ON t.service_id = c.service_id |
| LEFT JOIN calendar_dates cd |
| ON t.service_id = cd.service_id |
| st.stop_id IN (".implode(", ", array_fill(0, count($stops), "?")).") AND |
| time(now) < time('23:30:00') AND |
| time(st.departure_time) BETWEEN time(now) AND time(now, '30 minutes') AND |
| c.start_date <= today AND |
| time(now) >= time('23:30:00') AND |
| time(st.departure_time) >= time(now) AND |
| c.start_date <= today AND |
| time(st.departure_time) <= time(now, '30 minutes') AND |
| c.start_date <= tomorrow AND |
| c.$dow = ".(int)Gtfs\Calendar\CalendarDay::AVAILABLE." |
| exception_type = ".(int)Gtfs\CalendarDate\ExceptionType::ADDED." |
| ORDER BY departure_time ASC"; |