benak/#177
prosím o kontrolu, přidal jsem:
AND date_trunc('millisecond', "last_position"."updated_at") > '2020-11-20T09:45:22.396Z'celý dotaz sestavený sequelize:
SELECT "vehiclepositions_trips"."agency_name_real", "vehiclepositions_trips"."agency_name_scheduled", "vehiclepositions_trips"."cis_line_id", "vehiclepositions_trips"."cis_line_short_name", "vehiclepositions_trips"."cis_trip_number", "vehiclepositions_trips"."gtfs_route_id", "vehiclepositions_trips"."gtfs_route_short_name", "vehiclepositions_trips"."gtfs_trip_headsign", "vehiclepositions_trips"."gtfs_trip_id", "vehiclepositions_trips"."id", "vehiclepositions_trips"."origin_route_name", "vehiclepositions_trips"."sequence_id", "vehiclepositions_trips"."start_asw_stop_id", "vehiclepositions_trips"."start_cis_stop_id", "vehiclepositions_trips"."start_cis_stop_platform_code", "vehiclepositions_trips"."start_time", "vehiclepositions_trips"."start_timestamp", "vehiclepositions_trips"."vehicle_registration_number", "vehiclepositions_trips"."vehicle_type_id", "vehiclepositions_trips"."wheelchair_accessible", "last_position"."asw_last_stop_id" AS "last_position.asw_last_stop_id", "last_position"."bearing" AS "last_position.bearing", "last_position"."cis_last_stop_id" AS "last_position.cis_last_stop_id", "last_position"."cis_last_stop_sequence" AS "last_position.cis_last_stop_sequence", "last_position"."delay" AS "last_position.delay", "last_position"."delay_stop_arrival" AS "last_position.delay_stop_arrival", "last_position"."delay_stop_departure" AS "last_position.delay_stop_departure", "last_position"."is_canceled" AS "last_position.is_canceled", "last_position"."last_stop_arrival_time" AS "last_position.last_stop_arrival_time", "last_position"."last_stop_departure_time" AS "last_position.last_stop_departure_time", "last_position"."last_stop_id" AS "last_position.last_stop_id", "last_position"."last_stop_sequence" AS "last_position.last_stop_sequence", "last_position"."lat" AS "last_position.lat", "last_position"."lng" AS "last_position.lng", "last_position"."next_stop_arrival_time" AS "last_position.next_stop_arrival_time", "last_position"."next_stop_departure_time" AS "last_position.next_stop_departure_time", "last_position"."next_stop_id" AS "last_position.next_stop_id", "last_position"."next_stop_sequence" AS "last_position.next_stop_sequence", "last_position"."origin_time" AS "last_position.origin_time", "last_position"."origin_timestamp" AS "last_position.origin_timestamp", "last_position"."shape_dist_traveled" AS "last_position.shape_dist_traveled", "last_position"."speed" AS "last_position.speed", "last_position"."tracking" AS "last_position.tracking", "last_position"."trips_id" AS "last_position.trips_id", "last_position"."updated_at" AS "last_position.updated_at", "vehicle_type"."description_cs" AS "vehicle_type.description_cs", "vehicle_type"."description_en" AS "vehicle_type.description_en", "vehicle_type"."id" AS "vehicle_type.id" FROM "vehiclepositions_trips" AS "vehiclepositions_trips" INNER JOIN "v_vehiclepositions_last_position" AS "last_position" ON "vehiclepositions_trips"."id" = "last_position"."trips_id" AND date_trunc('millisecond', "last_position"."updated_at") > '2020-11-20T09:45:22.396Z' AND "last_position"."tracking" = 2 LEFT OUTER JOIN "vehiclepositions_vehicle_types" AS "vehicle_type" ON "vehiclepositions_trips"."vehicle_type_id" = "vehicle_type"."id" WHERE "vehiclepositions_trips"."gtfs_trip_id" IS NOT NULL;