SELECT t1.text
FROM (SELECT t._ident FROM prelude_alert as t WHERE t._ident BETWEEN 1302 AND 3616) AS top
LEFT JOIN (SELECT t1._message_ident ,t1.text FROM Prelude_Classification AS t1 WHERE t1._message_ident BETWEEN 1302 AND 3616 GROUP BY 1,2) AS t1
ON (t1._message_ident =top._ident )
LEFT JOIN (SELECT t2._message_ident ,t2.address FROM Prelude_Address AS t2 WHERE t2._index = 0 AND t2._parent_type = 'S' AND t2._parent0_index = -1 AND t2._message_ident BETWEEN 1302 AND 3616 GROUP BY 1,2) AS t2
ON (t2._message_ident =top._ident AND (t2.address = '192.168.100.60'))
LEFT JOIN (SELECT t3._message_ident ,t3.address FROM Prelude_Address AS t3 WHERE t3._index = 0 AND t3._parent_type = 'T' AND t3._parent0_index = -1 AND t3._message_ident BETWEEN 1302 AND 3616 GROUP BY 1,2) AS t3
ON (t3._message_ident =top._ident AND (t3.address = '192.168.100.60'))
LEFT JOIN (SELECT t0._message_ident, t0.time FROM Prelude_CreateTime AS t0 WHERE t0._parent_type = 'A' AND t0._message_ident BETWEEN 1302 AND 3616 GROUP BY 1,2) AS t0
ON (t0._message_ident =top._ident AND t0._message_ident BETWEEN 1302 AND 3616 AND (t0.time >= '2006-03-21 10:34:16' AND t0.time <= '2006-03-21 10:49:16'))
LEFT JOIN (SELECT tlast._ident FROM Prelude_Alert AS tlast WHERE tlast._ident BETWEEN 1302 AND 3616 GROUP BY 1) AS tlast
ON ( ((t2.address = '192.168.100.60') AND (t3.address = '192.168.100.60'))
AND (t0.time >= '2006-03-21 10:34:16' AND t0.time <= '2006-03-21 10:49:16') AND tlast._ident =top._ident )
EXCEPT
SELECT t1.text
FROM (SELECT t._ident FROM prelude_alert as t WHERE t._ident BETWEEN 1302 AND 3616) AS top
LEFT JOIN (SELECT t1._message_ident ,t1.text FROM Prelude_Classification AS t1 WHERE t1._message_ident BETWEEN 1302 AND 3616 GROUP BY 1,2) AS t1
ON (t1._message_ident =top._ident )
LEFT JOIN (SELECT t2._message_ident ,t2.address FROM Prelude_Address AS t2 WHERE t2._index = 0 AND t2._parent_type = 'S' AND t2._parent0_index = -1 AND t2._message_ident BETWEEN 1302 AND 3616 GROUP BY 1,2) AS t2
ON (t2._message_ident =top._ident AND (t2.address = '192.168.100.60'))
LEFT JOIN (SELECT t3._message_ident ,t3.address FROM Prelude_Address AS t3 WHERE t3._index = 0 AND t3._parent_type = 'T' AND t3._parent0_index = -1 AND t3._message_ident BETWEEN 1302 AND 3616 GROUP BY 1,2) AS t3
ON (t3._message_ident =top._ident AND (t3.address = '192.168.100.60'))
LEFT JOIN (SELECT t0._message_ident, t0.time FROM Prelude_CreateTime AS t0 WHERE t0._parent_type = 'A' AND t0._message_ident BETWEEN 1302 AND 3616 GROUP BY 1,2) AS t0
ON (t0._message_ident =top._ident AND t0._message_ident BETWEEN 1302 AND 3616 AND (t0.time >= '2006-03-21 10:34:16' AND t0.time <= '2006-03-21 10:49:16'))
LEFT JOIN (SELECT tlast._ident FROM Prelude_Alert AS tlast WHERE tlast._ident BETWEEN 1302 AND 3616 GROUP BY 1) AS tlast
ON ( ((t2.address = '192.168.100.60') AND (t3.address = '192.168.100.60'))
AND (t0.time >= '2006-03-21 10:34:16' AND t0.time <= '2006-03-21 10:49:16') AND tlast._ident =top._ident )
WHERE tlast._ident IS NULL
GROUP BY 1
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
