SELECT t0.address, t1.port, t1.iana_protocol_name, t0.netmask AS "Máscara de red", t2.category AS "Categoría", t3.tty AS "tty",
tlast._ident
FROM Prelude_Alert AS top
LEFT JOIN Prelude_Address AS t0
ON (top._ident = 14713 AND t0._message_ident = top._ident)
LEFT JOIN Prelude_Service AS t1
ON (top._ident = t1._message_ident AND t0._parent_type = 'S' AND t1._parent_type = 'S' AND t0._parent0_index = -1)
LEFT JOIN Prelude_User AS t2
ON (t2._message_ident = top._ident AND t2._parent_type = 'S' AND t2._parent0_index = -1)
LEFT JOIN Prelude_UserId AS t3
ON (t3._message_ident = top._ident AND t3._parent_type = 'S' AND t3._parent0_index = -1)
LEFT JOIN Prelude_Alert AS tlast
ON (tlast._ident = top._ident AND t0._parent_type = 'S' AND t1._parent_type = 'S' AND t0._parent0_index = -1)
WHERE t0._message_ident = 14713 and t0._index != -1 and t0._parent0_index = -1 and t0._parent_type = 'S'
ORDER BY t0._index ASC
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
