Guest User

Untitled

a guest
Oct 27th, 2014
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.49 KB | None | 0 0
  1. 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