SELECT date_trunc('hour',time) as "Time", SUM(cont) as "Total"
FROM
(
SELECT COUNT(tlast._ident) AS "cont" ,
t0.time AT TIME ZONE 'GMT' AS "time"
FROM
(
SELECT t._ident FROM prelude_alert as t WHERE t._ident BETWEEN 6481 AND 16239
) AS top
LEFT JOIN Prelude_DetectTime AS t0
ON (t0._message_ident =top._ident AND t0._message_ident BETWEEN 6481 AND 16239)
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident =top._ident AND tlast._ident BETWEEN 6481 AND 16239)
GROUP BY t0.time ORDER BY 2 DESC LIMIT 9758
) AS tlast
WHERE tlast.cont != 0
GROUP BY 1
ORDER BY 1 DESC
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
