Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT
stops.stop_name
, stop_times.departure_time_secs / 3600 AS departure_time_hours
, (stop_times.departure_time_secs / 60) - ((stop_times.departure_time_secs / 3600) * 60) AS departure_time_mins
, trips.trip_headsign
, routes.route_short_name
, calendars.monday
, calendars.tuesday
, calendars.wednesday
, calendars.thursday
, calendars.friday
, calendars.saturday
, calendars.sunday
FROM stops
JOIN stop_times ON stop_times.stop_id = stops.id
JOIN trips ON trips.id = stop_times.trip_id
JOIN routes ON routes.id = trips.route_id
JOIN calendars ON calendars.service_id = trips.service_id
WHERE
stops.stop_id LIKE '%38587'
AND calendars.wednesday = 1
ORDER BY stop_times.departure_time_secs
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.