l AS (
SELECT k.*, z.route_id
FROM k
LEFT JOIN bart_trips z
ON k.trip_id = z.trip_id
)