Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT stop_times.departure_time, routes.route_long_name, trips.trip_headsign, calendar.monday, calendar.tuesday, calendar.wednesday, calendar.thursday, calendar.friday, calendar.saturday, calendar.sunday
- FROM stop_times, trips, routes, calendar
- WHERE stop_times.stop_id = '1571' AND stop_times.trip_id = trips.trip_id AND trips.route_id = routes.route_id AND trips.service_id = calendar.service_id AND 20180801 >= calendar.start_date AND 20180801 <= calendar.end_date
- ORDER BY routes.route_short_name, trips.service_id, stop_times.departure_time
Add Comment
Please, Sign In to add comment