SELECT CASE WHEN t2.address IS NULL OR t2.address = ' ' THEN '127.0.0.1' ELSE t2.address END,t0.address,MAX(t0.time)
FROM
(
SELECT t0._message_ident,t3.address,t0.time AT TIME ZONE 'GMT' AS time
FROM Prelude_CreateTime AS t0,Prelude_Address AS t3
WHERE (t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52') AND t0._parent_type = 'A'
AND t3._index = 0 AND t3._parent_type = 'T' AND t3._message_ident = t0._message_ident
GROUP BY 1, 2, 3
) AS t0
LEFT JOIN
(SELECT _message_ident, address FROM
(SELECT t2._message_ident,t2.address,t0.time FROM Prelude_Address AS t2,Prelude_CreateTime AS t0
WHERE t2._parent_type = 'S' and t2._message_ident = t0._message_ident AND t2._index = 0
AND t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52' AND t0._parent_type = 'A' GROUP BY 1,2,3) AS t2) as t2
ON (t2._message_ident = t0._message_ident)
LEFT JOIN
(SELECT _message_ident as _ident,time FROM
(SELECT t0._message_ident,t0.time FROM Prelude_CreateTime AS t0
WHERE t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52' AND t0._parent_type = 'A' GROUP BY 1,2) AS t0) as tlast
ON (t0._message_ident = tlast._ident)
WHERE tlast._ident IS NOT NULL
GROUP BY 1,2 ORDER BY 3 DESC,1,2
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
