SELECT t6.name AS "Sensor" , COUNT(tlast._ident) AS "Alerts" , ROUND( (100.0*COUNT(tlast._ident))/257,5) , MIN(t0.time) AS "FTS" , MAX(t0.time) AS "LTS" FROM Prelude_Alert AS top
LEFT JOIN Prelude_Analyzer AS t6 ON ( top._ident = t6._message_ident AND t6._parent_type = 'A' AND t6._index = -1)
LEFT JOIN Prelude_CreateTime AS t0 ON (t0.time >= '2006-02-14 11:15:00.0' AND t0.time <= '2006-2-14 11:30:00.0' AND t0._message_ident = top._ident AND t0._parent_type = 'A')
LEFT JOIN Prelude_Alert AS tlast ON ( t0.time >= '2006-02-14 11:15:00.0' AND t0.time <= '2006-2-14 11:30:00.0' AND tlast._ident = top._ident)
GROUP BY t6.name
EXCEPT
SELECT t6.name AS "Sensor" , COUNT(tlast._ident) AS "Alerts" , ROUND( (100.0*COUNT(tlast._ident))/257,5) , MIN(t0.time) AS "FTS" , MAX(t0.time) AS "LTS" FROM Prelude_Alert AS top
LEFT JOIN Prelude_Analyzer AS t6 ON ( top._ident = t6._message_ident AND t6._parent_type = 'A' AND t6._index = -1)
LEFT JOIN Prelude_CreateTime AS t0 ON (t0.time >= '2006-02-14 11:15:00.0' AND t0.time <= '2006-2-14 11:30:00.0' AND t0._message_ident = top._ident AND t0._parent_type = 'A')
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident IS NULL AND t0.time IS NULL AND tlast._ident = top._ident)
GROUP BY t6.name ORDER BY 2 DESC
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
