SELECT DISTINCT sens AS "Sensorito" , COUNT(tlast._ident) AS "Alertas" , ROUND( (100.0*COUNT(tlast._ident))/3321,5) AS "%" , MIN(tim) AS "Desde" , MAX(tim) AS "Hasta"
FROM
(SELECT top._ident AS _ident FROM Prelude_Alert AS top
WHERE top._ident BETWEEN 6525 AND 16239 ORDER BY top._ident DESC LIMIT 9714) AS top
LEFT JOIN
(SELECT t6.name AS sens,t6._index, t6._parent_type , t6._message_ident FROM Prelude_Analyzer AS t6
WHERE t6._index = -1 AND t6._parent_type = 'A' AND t6._message_ident BETWEEN 6525 AND 16239 ORDER BY t6._message_ident DESC LIMIT 9714) AS t6 ON (top._ident = t6._message_ident)
LEFT JOIN
(SELECT t0.time AT TIME ZONE 'GMT' AS tim, t0._message_ident FROM Prelude_DetectTime AS t0
WHERE t0._message_ident BETWEEN 6525 AND 16239 ORDER BY t0._message_ident DESC LIMIT 9714) AS t0 ON (top._ident = t0._message_ident )
LEFT JOIN
(SELECT tlast._ident AS _ident FROM Prelude_Alert AS tlast
WHERE tlast._ident BETWEEN 6525 AND 16239 ORDER BY tlast._ident DESC LIMIT 9714) AS tlast ON (top._ident = tlast._ident)
GROUP BY t6.sens ORDER BY 2 DESC
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
