detailledservice (view)

68 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: destination_id, destination_name, line_id, line_name

CREATE VIEW detailledservice AS select main.id as id, main.name as name, h.id as destination_id, h.name as destination_name, main.line_id, l.name as line_name from ( select s.id, s.line_id, s.name, max( p.time ) as max_time from service s inner join passage p on p.service_id = s.id inner join stop h on h.id = p.stop_id group by s.id, s.name ) main inner join passage on main.id = passage.service_id and main.max_time = passage.time inner join stop h on h.id = passage.stop_id inner join line l on l.id = main.line_id;