SELECT * FROM (SELECT DISTINCT date_trunc('hour',tim) AS "time" , COUNT(tlast._ident) AS "filtered"
FROM
(SELECT top._ident AS _ident FROM Prelude_Alert AS top
LEFT JOIN Prelude_Impact AS t7 ON (t7._message_ident = top._ident ) WHERE top._ident BETWEEN 6481 AND 16239 ORDER BY top._ident DESC LIMIT 9758) AS top
LEFT JOIN
(SELECT t0.time AT TIME ZONE 'GMT' AS tim, t0._message_ident FROM Prelude_DetectTime AS t0 WHERE t0._message_ident BETWEEN 6481 AND 16239 ORDER BY t0._message_ident DESC LIMIT 9758) AS t0 ON (top._ident = t0._message_ident )
LEFT JOIN
(SELECT t6.name AS sens,t6._index, t6._parent_type , t6._message_ident FROM Prelude_Analyzer AS t6
LEFT JOIN Prelude_Impact AS t7 ON (t7._message_ident = t6._message_ident) WHERE (t7.severity = 'high') AND t6._index = -1 AND t6._parent_type = 'A' AND t6._message_ident BETWEEN 6481 AND 16239 ORDER BY t6._message_ident DESC LIMIT 9758) AS t6 ON (top._ident = t6._message_ident)
LEFT JOIN
(SELECT t7.severity AS sev, t7._message_ident FROM Prelude_Impact AS t7 WHERE (t7.severity = 'high') AND t7._message_ident BETWEEN 6481 AND 16239 ORDER BY t7._message_ident DESC LIMIT 9758) AS t7 ON (top._ident = t7._message_ident )
LEFT JOIN
(SELECT tlast._ident AS _ident FROM Prelude_Alert AS tlast
LEFT JOIN Prelude_Impact AS t7 ON (t7._message_ident = tlast._ident)
WHERE (t7.severity = 'high') AND tlast._ident BETWEEN 6481 AND 16239 ORDER BY tlast._ident DESC LIMIT 9758) AS tlast ON (top._ident = tlast._ident)
GROUP BY 1
) AS total
except
SELECT * FROM (SELECT DISTINCT date_trunc('hour',tim) AS "time" , COUNT(tlast._ident) AS "filtered"
FROM
(SELECT top._ident AS _ident FROM Prelude_Alert AS top
LEFT JOIN Prelude_Impact AS t7 ON (t7._message_ident = top._ident ) WHERE top._ident BETWEEN 6481 AND 16239 ORDER BY top._ident DESC LIMIT 9758) AS top
LEFT JOIN
(SELECT t0.time AT TIME ZONE 'GMT' AS tim, t0._message_ident FROM Prelude_DetectTime AS t0 WHERE t0._message_ident BETWEEN 6481 AND 16239 ORDER BY t0._message_ident DESC LIMIT 9758) AS t0 ON (top._ident = t0._message_ident )
LEFT JOIN
(SELECT t6.name AS sens,t6._index, t6._parent_type , t6._message_ident FROM Prelude_Analyzer AS t6
LEFT JOIN Prelude_Impact AS t7 ON (t7._message_ident = t6._message_ident) WHERE (t7.severity = 'high') AND t6._index = -1 AND t6._parent_type = 'A' AND t6._message_ident BETWEEN 6481 AND 16239 ORDER BY t6._message_ident DESC LIMIT 9758) AS t6 ON (top._ident = t6._message_ident)
LEFT JOIN
(SELECT t7.severity AS sev, t7._message_ident FROM Prelude_Impact AS t7 WHERE (t7.severity = 'high') AND t7._message_ident BETWEEN 6481 AND 16239 ORDER BY t7._message_ident DESC LIMIT 9758) AS t7 ON (top._ident = t7._message_ident )
LEFT JOIN
(SELECT tlast._ident AS _ident FROM Prelude_Alert AS tlast
LEFT JOIN Prelude_Impact AS t7 ON (t7._message_ident = tlast._ident)
WHERE (t7.severity = 'high') AND tlast._ident BETWEEN 6481 AND 16239 ORDER BY tlast._ident DESC LIMIT 9758) AS tlast ON (top._ident = tlast._ident)
GROUP BY 1
) as total where total.filtered is null
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
