select name AS "Sensorito", COUNT(total._ident) as "num", ROUND( (100.0*COUNT(total._ident))/3321,5) AS "%", MAX(total.time), MIN(total.time)
FROM
(
SELECT * FROM
(
SELECT t6.name, tlast._ident, t0.time AT TIME ZONE 'GMT' AS "time" FROM Prelude_Alert AS toplast
LEFT JOIN Prelude_Impact AS t7 ON (t7._message_ident = toplast._ident)
LEFT JOIN Prelude_Analyzer AS t6 ON (t6._message_ident = t7._message_ident and t6._parent_type = 'A' AND t6._index = -1)
LEFT JOIN Prelude_Detecttime AS t0 ON (t0._message_ident = t6._message_ident)
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident = t0._message_ident and t0._message_ident BETWEEN 6481 AND 16239)
GROUP BY 1,2,3 ORDER BY tlast._ident DESC LIMIT 9758
) AS TOT
except
SELECT * FROM
(
SELECT t6.name, tlast._ident,t0.time AT TIME ZONE 'GMT' AS "time" FROM Prelude_Alert AS toplast
LEFT JOIN Prelude_Impact AS t7 ON (t7._message_ident = toplast._ident)
LEFT JOIN Prelude_Analyzer AS t6 ON (t6._message_ident = t7._message_ident and t6._parent_type = 'A' AND t6._index = -1)
LEFT JOIN Prelude_Detecttime AS t0 ON (t0._message_ident = t6._message_ident)
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident = t0._message_ident and t0._message_ident BETWEEN 6481 AND 16239)
GROUP BY 1,2,3 ORDER BY tlast._ident DESC LIMIT 9758
) AS TOT
WHERE TOT._ident is null
) AS total
GROUP BY 1 ORDER BY 3 DESC
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
