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
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)
LEFT JOIN Prelude_Analyzer AS t6 ON (t6._index = -1 AND t6._parent_type = 'A' AND t6._message_ident=t0._message_ident AND t6._message_ident BETWEEN 443 AND 855)
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident =t6._message_ident AND tlast._ident BETWEEN 443 AND 855)
GROUP BY t6.name, tlast._ident, t0.time ORDER BY tlast._ident DESC LIMIT 9758
) AS taux
EXCEPT
SELECT * FROM (
SELECT t6.name, tlast._ident, t0.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)
LEFT JOIN Prelude_Analyzer AS t6 ON (t6._index = -1 AND t6._parent_type = 'A' AND t6._message_ident=t0._message_ident AND t6._message_ident BETWEEN 443 AND 855)
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident =t6._message_ident AND tlast._ident BETWEEN 443 AND 855)
GROUP BY t6.name, tlast._ident, t0.time ORDER BY tlast._ident DESC LIMIT 9758
) 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.
