SELECT dbo.DateAsUnix(TimestampUTC)  AS timestamp, (SELECT DisplayName From Source WITH (NOLOCK) WHERE ID=SourceID)  AS node, Priority  AS priority, (SELECT COALESCE(CAST(QuantityID as NVARCHAR(5)), String) From EventString WITH (NOLOCK) WHERE ID=CauseID)  AS cause_ion, (SELECT String From EventString WITH (NOLOCK) WHERE ID=CauseValueID)  AS cause_value, (SELECT COALESCE(CAST(QuantityID as NVARCHAR(5)), String) From EventString WITH (NOLOCK) WHERE ID=EffectID)  AS effect_ion, (SELECT String From EventString WITH (NOLOCK) WHERE ID=EffectValueID)  AS effect_value, dbo.DateAsUnix(AckTimeUTC)  AS ack_time, UserName  AS user_name, ID  AS recordID, NULL  AS replacement, Remark  AS remark
FROM dbo.EventLog2 WITH (NOLOCK) LEFT JOIN dbo.EventAcknowledgement WITH (NOLOCK) ON EventLogID=ID
WHERE Priority >= '128'
ORDER BY TimestampUTC DESC OPTION (FAST 50)