SELECT s_addr AS "Nombre" , t_addr AS "Terminal" , cont AS "Alertas", tlts AS "Hasta"
FROM
(
SELECT t2.address AS s_addr, t3.address AS t_addr, COUNT(tlast._ident) AS "cont" ,
MAX(t0.time AT TIME ZONE 'GMT' ) AS "tlts"
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_Address AS t2 ON (t2._index = 0 AND t2._parent_type = 'S' AND t2._parent0_index = 0 AND t2._message_ident =top._ident
AND t2._message_ident BETWEEN 6481 AND 16239)
LEFT JOIN Prelude_Address AS t3 ON (t3._index = 0 AND t3._parent_type = 'T' AND t3._parent0_index = 0 AND t3._message_ident =top._ident
AND t3._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 1,2 ORDER BY 2 DESC LIMIT 9758
) AS tlast
WHERE tlast.cont != 0
ORDER BY 4 DESC
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
