SELECT TOP 1000 [t2].[ID] AS [t2_ID], [t3].[_type] AS [t3__type], [t2].[CapitalConfirmation] AS [t2_CapitalConfirmation] FROM [LotParticipantFiles] t2 LEFT JOIN [DocumentFiles] t3 ON t3.[ID] = t2.[ID] WHERE t2.[CapitalConfirmation] IN (@p1)