WITH d AS (
SELECT ST_MakeLine(the_geom ORDER BY trip_id, stop_sequence_true ASC) AS the_geom,
trip_id, stop_sequence AS stop_sequence_start, (stop_sequence+1) AS stop_sequence_end,
array_agg(stop_id ORDER BY stop_sequence_true) AS stop_id_array
FROM c
GROUP BY trip_id, stop_sequence
)