SELECT
    [Project2].[Project_id] AS [Project_id],
    [Project2].[C1] AS [C1],
    [Project2].[Id] AS [Id],
    [Project2].[CustomField_id] AS [CustomField_id],
    [Project2].[VALUE] AS [VALUE],
    [Project2].[LastChange] AS [LastChange],
    [Project2].[Project_id1] AS [Project_id1],
    [Project2].[Task_id] AS [Task_id],
    [Project2].[ListValue_id] AS [ListValue_id]
    FROM ( SELECT
        [Distinct1].[Project_id] AS [Project_id],
        [Join4].[Id1] AS [Id],
        [Join4].[CustomField_id] AS [CustomField_id],
        [Join4].[VALUE] AS [VALUE],
        [Join4].[LastChange] AS [LastChange],
        [Join4].[Project_id1] AS [Project_id1],
        [Join4].[Task_id] AS [Task_id],
        [Join4].[ListValue_id] AS [ListValue_id],
        CASE WHEN ([Join4].[Id1] IS NULL) THEN CAST(NULL AS INT) ELSE 1 END AS [C1]
        FROM   (SELECT DISTINCT
            [Extent1].[Project_id] AS [Project_id]
            FROM   [dbo].[CustomFieldValues] AS [Extent1]
            INNER JOIN [dbo].[TempRapports] AS [Extent2] ON [Extent1].[CustomField_id] = [Extent2].[Ressource_Id]
            INNER JOIN [dbo].[TempRapportsProjects] AS [Extent3] ON [Extent1].[Project_id] = [Extent3].[Project_Id]
            WHERE ([Extent3].[ID] = @p__linq__0) AND ([Extent2].[ID] = @p__linq__1) ) AS [Distinct1]
        LEFT OUTER JOIN  (SELECT [Extent4].[Id] AS [Id1], [Extent4].[CustomField_id] AS [CustomField_id], [Extent4].[VALUE] AS [VALUE], [Extent4].[LastChange] AS [LastChange], [Extent4].[Project_id] AS [Project_id1], [Extent4].[Task_id] AS [Task_id], [Extent4].[ListValue_id] AS [ListValue_id], [Extent5].[ID] AS [ID2], [Extent6].[ID] AS [ID3]
            FROM   [dbo].[CustomFieldValues] AS [Extent4]
            INNER JOIN [dbo].[TempRapports] AS [Extent5] ON [Extent4].[CustomField_id] = [Extent5].[Ressource_Id]
            INNER JOIN [dbo].[TempRapportsProjects] AS [Extent6] ON [Extent4].[Project_id] = [Extent6].[Project_Id] ) AS [Join4] ON ([Join4].[ID3] = @p__linq__0) AND ([Join4].[ID2] = @p__linq__1) AND ([Distinct1].[Project_id] = [Join4].[Project_id1])
    )  AS [Project2]
    ORDER BY [Project2].[Project_id] ASC, [Project2].[C1] ASC OPTION (OPTIMIZE FOR UNKNOWN)
-- p__linq__0: '8a17ffe0-0729-42e8-8ae7-2b95663aaff6' (Type = Guid, IsNullable = false)
-- p__linq__1: '78a4aaa9-9d24-47ba-81b8-45cc618a860e' (Type = Guid, IsNullable = false)