CREATE TABLE contar7 as SELECT t6.name, date_trunc('hour',t0.time) AS "Time" , count(tlast._ident) AS "Filtered" FROM Prelude_Alert AS top
LEFT JOIN Prelude_Impact AS t7 ON ( top._ident = t7._message_ident)
LEFT JOIN Prelude_Analyzer AS t6 ON ( t6.name = 'PAM' AND top._ident = t6._message_ident AND t6._parent_type = 'A' AND t6._index = -1)
LEFT JOIN Prelude_CreateTime AS t0 ON ( t0._message_ident = top._ident AND t0._parent_type = 'A')
LEFT JOIN Prelude_Alert AS tlast ON ( (t6.name = 'PAM') and t7._message_ident IS NOT NULL AND tlast._ident = top._ident)
WHERE (t0.time >= '2005-12-11 23:00:00.0' AND t0.time <= '2005-12-24 23:00:00.0') GROUP BY 1,2 ORDER BY 1
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
