DECLARE @documentId int = ?  ; SELECT L.code as [Language_Code] ,L.isoCode as [Language_IsoCode] ,L.active as [Language_Active] ,A.title as [Title] ,(SELECT TOP 1 U.uri FROM dbo.uris AS U WHERE U.documentID = D.documentID ORDER BY U.dateInsert DESC) as [Uri] ,S.domain as [Domain] FROM dbo.alternateContent AS A INNER JOIN dbo.languages AS L ON L.languageID = A.languageID INNER JOIN dbo.documents AS D ON D.documentID = A.linkedDocumentID LEFT JOIN dbo.sites as S ON S.siteID = D.siteID WHERE A.documentID = @documentId