SELECT DISTINCT dbo.AuditLocationData.Value FROM dbo.AuditLocationData JOIN dbo.AuditLocation ON dbo.AuditLocation.Id=dbo.AuditLocationData.AuditLocationIdJOIN dbo.Audits ON dbo.Audits.Id = dbo.AuditLocationData.AuditId WHERE dbo.AuditLocation.ColumnOrder=0 AND dbo.Audits.Id IN ('F59B8CBF-E943-467E-9FDA-000E91CCE625','8EA1CFD1-601D-4261-A602-000DEE320CC0') ORDER BY dbo.AuditLocationData.Value