Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT geom_sl FROM ( SELECT * FROM (SELECT speed_m_s*3.6 AS speed , geom_sl , id_sentence_line FROM ( SELECT * FROM ( SELECT * FROM otmisnet.machine WHERE (id_client = 1 OR id_client = 2 OR id_client = 3 OR id_client = 4 OR id_client = 5 ) ) AS ctx_1 NATURAL JOIN (SELECT *,id_sequence AS id_sentence_line FROM onetgeo.sentence_line) AS sentence_line NATURAL JOIN ( SELECT * FROM (SELECT bounding,tstzrange(to_timestamp((timestamp_init::NUMERIC / 1000.0)::DOUBLE PRECISION), to_timestamp((timestamp_end::NUMERIC / 1000.0)::DOUBLE PRECISION)) AS timerange,(date_part('hour', to_timestamp((timestamp_init/1000)::DOUBLE PRECISION) AT TIME ZONE 'BRT')) AS time_h, date_part('doy'::text, timezone('BRT'::text, to_timestamp((services.timestamp_init / 1000)::DOUBLE PRECISION))) + date_part('year'::text, timezone('BRT'::text, to_timestamp((services.timestamp_init / 1000)::DOUBLE PRECISION))) * 366::DOUBLE PRECISION AS DAY, date_part('month'::text, timezone('BRT'::text, to_timestamp((services.timestamp_init / 1000)::DOUBLE PRECISION))) + date_part('year'::text, timezone('BRT'::text, to_timestamp((services.timestamp_init / 1000)::DOUBLE PRECISION))) * 12::DOUBLE PRECISION AS MONTH,id_machine,id_sequence,timestamp_init,timestamp_end FROM onetgeo.services) AS s WHERE timerange && tstzrange(to_timestamp(1.3885344E9), to_timestamp(1.397523540999E9) ) AND (timerange && tstzrange(to_timestamp(1.3937184E9), to_timestamp(1.393808340999E9) ) ) ) AS ctx_0 NATURAL JOIN otmisnet.client) AS reduced ) AS projection) AS reduced
Advertisement
Add Comment
Please, Sign In to add comment