SELECT name AS "Sensorito" , count(_ident) AS "Alertas" , ROUND( (100.0*count(_ident))/3321,5) AS "%" , min(time) AS "Desde" , max(time) AS "Hasta" FROM
(
SELECT * FROM
(
SELECT t6.name, tlast._ident, t0.time AT TIME ZONE 'GMT' AS "time"
FROM Prelude_Alert AS top
LEFT JOIN Prelude_DetectTime AS t0 ON (t0._message_ident =top._ident AND t0._message_ident BETWEEN 443 AND 855 AND t0.time >= '2006-03-13 11:00:56' AND t0.time <= '2006-03-13 13:30:59')
LEFT JOIN Prelude_Analyzer AS t6 ON (t6._message_ident=top._ident AND t6._message_ident BETWEEN 443 AND 855 AND t6._index = -1 and t6._parent_type = 'A')
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident =top._ident AND tlast._ident BETWEEN 443 AND 855 AND t0.time >= '2006-03-13 11:00:56' AND t0.time <= '2006-03-13 13:30:59')
GROUP BY t6.name, tlast._ident, t0.time ORDER BY tlast._ident DESC
) AS taux
EXCEPT
SELECT * FROM
(
SELECT t6.name, tlast._ident, t0.time AT TIME ZONE 'GMT' AS "time"
FROM Prelude_Alert AS top
LEFT JOIN Prelude_DetectTime AS t0 ON (t0._message_ident =top._ident AND t0._message_ident BETWEEN 443 AND 855 AND t0.time >= '2006-03-13 11:00:56' AND t0.time <= '2006-03-13 13:30:59')
LEFT JOIN Prelude_Analyzer AS t6 ON (t6._message_ident=top._ident AND t6._message_ident BETWEEN 443 AND 855 AND t6._index = -1 and t6._parent_type = 'A')
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident =top._ident AND tlast._ident BETWEEN 443 AND 855 AND t0.time >= '2006-03-13 11:00:56' AND t0.time <= '2006-03-13 13:30:59')
GROUP BY t6.name, tlast._ident, t0.time ORDER BY tlast._ident DESC
) AS taux WHERE taux._ident IS NULL
) AS tlast
GROUP BY 1 ORDER BY 2 DESC LIMIT 25
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
