SELECT t0.tfts,t0.tlts,t0.text,t0._message_ident,t0.source,t0.target,t0.name,t7.severity FROM
(
SELECT t0.tfts,t0.tlts,t0.text,t0._message_ident,t0.source,t0.target,t6.name FROM
(
SELECT t0.tfts,t0.tlts,t0.text,t0._message_ident,t0.source,t3.target FROM
(
SELECT MAX(t0.time AT TIME ZONE 'GMT') AS tlts,MIN(t0.time AT TIME ZONE 'GMT') AS tfts,t0.text,t0._message_ident,t2.source FROM
(
SELECT t0._message_ident, t0.time,t1.text
FROM (SELECT t0._message_ident ,t0.time FROM Prelude_CreateTime AS t0 WHERE (t0.time >= '2006-03-21 10:34:16' AND t0.time <= '2006-03-21 10:49:16')
AND t0._parent_type = 'A' AND t0._message_ident BETWEEN 1302 AND 10000 GROUP BY 1,2) AS t0
LEFT JOIN (SELECT MAX(t1._message_ident) as _message_ident,t1.text FROM Prelude_Classification AS t1
WHERE t1._message_ident BETWEEN 1302 AND 10000 GROUP BY 2
UNION
SELECT MIN(t1._message_ident) as _message_ident,t1.text FROM Prelude_Classification AS t1
WHERE t1._message_ident BETWEEN 1302 AND 10000 GROUP BY 2
) AS t1 ON (t1._message_ident = t0._message_ident)
EXCEPT
SELECT t0._message_ident, t0.time,t1.text
FROM (SELECT t0._message_ident ,t0.time FROM Prelude_CreateTime AS t0 WHERE (t0.time >= '2006-03-21 10:34:16' AND t0.time <= '2006-03-21 10:49:16')
AND t0._parent_type = 'A' AND t0._message_ident BETWEEN 1302 AND 10000 GROUP BY 1,2) AS t0
LEFT JOIN (SELECT MAX(t1._message_ident) as _message_ident,t1.text FROM Prelude_Classification AS t1
WHERE t1._message_ident BETWEEN 1302 AND 10000 GROUP BY 2
UNION
SELECT MIN(t1._message_ident) as _message_ident,t1.text FROM Prelude_Classification AS t1
WHERE t1._message_ident BETWEEN 1302 AND 10000 GROUP BY 2
) AS t1 ON (t1._message_ident = t0._message_ident)
WHERE t1._message_ident IS NULL
) AS t0
LEFT JOIN (SELECT MAX(t2._message_ident) as _message_ident,t2.address AS source 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 10000 GROUP BY 2
) AS t2 ON (t0._message_ident = t2._message_ident)
WHERE t2._message_ident IS NOT NULL
GROUP BY t0.text, t0._message_ident,t2.source
) AS t0
LEFT JOIN (SELECT MAX(t3._message_ident) as _message_ident,t3.address AS target 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 10000 GROUP BY 2
) AS t3 ON (t0._message_ident = t3._message_ident)
WHERE t3._message_ident IS NOT NULL
) AS t0
LEFT JOIN (SELECT MAX(t6._message_ident) AS _message_ident,t6.name FROM Prelude_Analyzer AS t6 WHERE t6._index = -1 AND t6._parent_type = 'A'
AND t6._message_ident BETWEEN 1302 AND 10000 GROUP BY 2) AS t6 ON (t6._message_ident=t0._message_ident )
WHERE t6._message_ident IS NOT NULL
) AS t0
LEFT JOIN (SELECT MAX(t7._message_ident) AS _message_ident ,t7.severity FROM Prelude_Impact AS t7 WHERE t7._message_ident BETWEEN 1302 AND 10000 GROUP BY 2) AS t7
ON (t7._message_ident =t0._message_ident )
WHERE t7._message_ident IS NOT NULL
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
