Duplicate lines in SWQL output

Question

Why does this query create near-duplicate lines in the output? The only difference is the AccountID column. One of the account ID's is correct the other seems random.

SELECT DISTINCT
       [EntityUri],
       [SuppressFrom] AS [UtcSuppressFrom],
       [SuppressUntil] AS [UtcSuppressUntil],
       ToLocal([SuppressFrom]) AS [LocalSuppressFrom],
       ToLocal([SuppressUntil]) AS [LocalSuppressUntil],
       CASE
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%' AND [EntityUri] NOT LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/%'
             THEN [N].[Caption]
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Interfaces/InterfaceID=%'
             THEN [I].[FullName]
          ELSE 'SomethingElse'
       END AS [Element],
       CASE
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%' AND [EntityUri] NOT LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/%'
             THEN [N].[DetailsUrl]
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Interfaces/InterfaceID=%'
             THEN [I].[DetailsUrl]
          ELSE 'SomethingElse'
       END AS [DetailsUrl],
       CASE
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%' AND [EntityUri] NOT LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/%'
             THEN [N].[Status]
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Interfaces/InterfaceID=%'
             THEN [I].[Status]
          ELSE 30
       END AS [Status],
       [AE].AccountID
FROM Orion.AlertSuppression AS [AlertSup]
LEFT OUTER JOIN Orion.Nodes AS [N]
   ON [AlertSup].[EntityUri] = [N].[Uri]
LEFT OUTER JOIN Orion.NPM.Interfaces AS [I]
   ON [AlertSup].[EntityUri] = [I].[Uri]
LEFT OUTER JOIN Orion.AuditingEvents AS [AE]
   ON [AE].AuditEventMessage LIKE CONCAT('%', CASE
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%' AND [EntityUri] NOT LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/%'
             THEN [N].[NodeName]
          WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Interfaces/InterfaceID=%'
             THEN [I].[InterfaceCaption]
          ELSE 'Wrong'
       END, '%') AND [EntityUri] LIKE CONCAT('%=', [AE].NetObjectID)
INNER JOIN Orion.AuditingActionTypes AS [AT]
   ON [AE].ActionTypeID = [AT].ActionTypeID
WHERE [AT].ActionTypeDisplayName LIKE '%mute%'Sample output:swis://orion.school.Edu/Orion/Orion.Nodes/NodeID=5732022-06-08 01:30:002022-06-08 12:00:002022-06-07 21:30:002022-06-08 08:00:00Switch1/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:5731domain\accountid30swis://orion.school.Edu/Orion/Orion.Nodes/NodeID=5732022-06-08 01:30:002022-06-08 12:00:002022-06-07 21:30:002022-06-08 08:00:00Switch1/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:5731domain\accountid99