SELECT s_addr, t_addr from (
SELECT s_addr, t_addr, cont, tlts
FROM
(
SELECT t2.address AS s_addr, t3.address AS t_addr, COUNT(tlast._ident) AS cont, MAX(t0.time) AS tlts
FROM (SELECT t._ident FROM prelude_alert as t WHERE t._ident BETWEEN 1286 AND 1427) AS top
LEFT JOIN (SELECT t.time, t._message_ident from Prelude_CreateTime AS t WHERE t._parent_type = 'A' and t._message_ident BETWEEN 1286 AND 1427
and (t.time >= '2006-03-16 17:56:00' AND t.time <= '2006-03-16 18:00:50') GROUP BY 1,2) AS t0 ON (t0._message_ident =top._ident)
LEFT JOIN (SELECT t.address, t._message_ident from Prelude_Address AS t WHERE t._parent_type = 'S' and t._index = 0 AND t._parent0_index = -1 AND
t._message_ident BETWEEN 1286 AND 1427 GROUP BY 1,2) AS t2 ON (t2._message_ident =top._ident)
LEFT JOIN (SELECT t.address, t._message_ident from Prelude_Address AS t WHERE t._parent_type = 'T' and t._index = 0 AND t._parent0_index = -1 AND
t._message_ident BETWEEN 1286 AND 1427 GROUP BY 1,2) AS t3 ON (t3._message_ident =top._ident)
LEFT JOIN (SELECT t._ident FROM prelude_alert as t WHERE t._ident BETWEEN 1286 AND 1427) AS tlast ON ((t0.time >= '2006-03-16 17:56:00' AND t0.time <= '2006-03-16 18:00:50') AND tlast._ident =top._ident)
GROUP BY 1,2 ORDER BY 2 DESC LIMIT 142
) AS tlast WHERE tlast.cont != 0 ORDER BY 4 DESC
) as t
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
