exec sp_executesql N'
SELECT 
    [Limit5].[ID] AS [ID], 
    [Limit5].[Subject] AS [Subject], 
    [Limit5].[Caption1] AS [Caption], 
    [Limit5].[C1] AS [C1], 
    [Limit5].[ID1] AS [ID1], 
    [Limit5].[C2] AS [C2], 
    [Limit5].[C3] AS [C3], 
    [Limit5].[C4] AS [C4], 
    [Limit5].[C5] AS [C5], 
    [Limit5].[IsPrivate] AS [IsPrivate], 
    [Limit5].[CreateDate] AS [CreateDate], 
    [Limit5].[LastChangeDate] AS [LastChangeDate], 
    [Limit5].[ID3] AS [ID2], 
    [Limit5].[C6] AS [C6], 
    [Limit5].[C7] AS [C7], 
    [Limit5].[ID2] AS [ID3], 
    [Limit5].[C8] AS [C8], 
    [Limit5].[C9] AS [C9], 
    [Limit5].[C10] AS [C10], 
    [Limit5].[C11] AS [C11], 
    [Limit5].[RecipientReadDate] AS [RecipientReadDate], 
    [Limit5].[C12] AS [C12], 
    [Limit5].[PlanCompleteDate] AS [PlanCompleteDate], 
    [Limit5].[C13] AS [C13], 
    [Limit5].[Caption] AS [Caption1], 
    [Limit5].[C14] AS [C14], 
    [Limit5].[C15] AS [C15], 
    [Limit5].[C16] AS [C16], 
    [Limit5].[ContentText] AS [ContentText], 
    [Limit5].[C17] AS [C17]
    FROM ( SELECT TOP (1) 
        [Project13].[ID] AS [ID], 
        [Project13].[Subject] AS [Subject], 
        [Project13].[PlanCompleteDate] AS [PlanCompleteDate], 
        [Project13].[RecipientReadDate] AS [RecipientReadDate], 
        [Project13].[CreateDate] AS [CreateDate], 
        [Project13].[LastChangeDate] AS [LastChangeDate], 
        [Project13].[ContentText] AS [ContentText], 
        [Project13].[IsPrivate] AS [IsPrivate], 
        [Project13].[ID2] AS [ID1], 
        [Project13].[ID3] AS [ID2], 
        [Project13].[ID4] AS [ID3], 
        [Project13].[Caption] AS [Caption], 
        [Project13].[Caption1] AS [Caption1], 
        CASE WHEN ([Project13].[SenderPersID] = @p__linq__1) THEN cast(1 as bit) WHEN ([Project13].[SenderPersID] <> @p__linq__1) THEN cast(0 as bit) END AS [C1], 
        [Project13].[LastName] + N'' '' + [Project13].[FirstName] + N'' '' + [Project13].[PatrName] + N'' ('' +  CAST( [Project13].[TabNum] AS nvarchar(max)) + N'')'' AS [C2], 
        CASE WHEN ([Project13].[ID2] = @p__linq__2) THEN cast(1 as bit) WHEN ([Project13].[ID2] <> @p__linq__2) THEN cast(0 as bit) END AS [C3], 
        [Project13].[LastName] + N'' '' + SUBSTRING([Project13].[FirstName], 0 + 1, 1) + SUBSTRING([Project13].[PatrName], 0 + 1, 1) + N'' ('' +  CAST( [Project13].[TabNum] AS nvarchar(max)) + N'')'' AS [C4], 
        CASE WHEN ([Project13].[ID2] = @p__linq__3) THEN cast(1 as bit) WHEN ([Project13].[ID2] <> @p__linq__3) THEN cast(0 as bit) END AS [C5], 
        [Project13].[LastName2] + N'' '' + [Project13].[FirstName2] + N'' '' + [Project13].[PatrName2] + N'' ('' +  CAST( [Project13].[TabNum2] AS nvarchar(max)) + N'')'' AS [C6], 
        CASE WHEN ([Project13].[ID4] = @p__linq__4) THEN cast(1 as bit) WHEN ([Project13].[ID4] <> @p__linq__4) THEN cast(0 as bit) END AS [C7], 
        [Project13].[LastName1] + N'' '' + [Project13].[FirstName1] + N'' '' + [Project13].[PatrName1] + N'' ('' +  CAST( [Project13].[TabNum1] AS nvarchar(max)) + N'')'' AS [C8], 
        CASE WHEN ([Project13].[ID3] = @p__linq__5) THEN cast(1 as bit) WHEN ([Project13].[ID3] <> @p__linq__5) THEN cast(0 as bit) END AS [C9], 
        [Project13].[LastName1] + N'' '' + SUBSTRING([Project13].[FirstName1], 0 + 1, 1) + SUBSTRING([Project13].[PatrName1], 0 + 1, 1) + N'' ('' +  CAST( [Project13].[TabNum1] AS nvarchar(max)) + N'')'' AS [C10], 
        CASE WHEN ([Project13].[ID3] = @p__linq__6) THEN cast(1 as bit) WHEN ([Project13].[ID3] <> @p__linq__6) THEN cast(0 as bit) END AS [C11], 
        CASE WHEN (CASE WHEN (([Project13].[RecipientPersID] = @p__linq__7) AND ([Project13].[SenderPersID] <> @p__linq__8) AND ([Project13].[RecipientReadDate] IS NULL)) THEN cast(1 as bit) WHEN ( NOT (([Project13].[RecipientPersID] = @p__linq__7) AND ([Project13].[SenderPersID] <> @p__linq__8) AND ([Project13].[RecipientReadDate] IS NULL))) THEN cast(0 as bit) END IS NULL) THEN cast(0 as bit) WHEN (([Project13].[RecipientPersID] = @p__linq__7) AND ([Project13].[SenderPersID] <> @p__linq__8) AND ([Project13].[RecipientReadDate] IS NULL)) THEN cast(1 as bit) WHEN ( NOT (([Project13].[RecipientPersID] = @p__linq__7) AND ([Project13].[SenderPersID] <> @p__linq__8) AND ([Project13].[RecipientReadDate] IS NULL))) THEN cast(0 as bit) END AS [C12], 
        CASE WHEN (((CASE WHEN (convert (datetime2, convert(varchar(255), [Project13].[PlanCompleteDate], 102) ,  102) IS NULL) THEN @p__linq__9 ELSE convert (datetime2, convert(varchar(255), [Project13].[PlanCompleteDate], 102) ,  102) END) <= (convert (datetime2, convert(varchar(255), SysDateTime(), 102) ,  102))) AND ([Project13].[RecipientPersID1] IS NOT NULL) AND ([Project13].[IsActive] = 1)) THEN cast(1 as bit) WHEN ( NOT (((CASE WHEN (convert (datetime2, convert(varchar(255), [Project13].[PlanCompleteDate], 102) ,  102) IS NULL) THEN @p__linq__9 ELSE convert (datetime2, convert(varchar(255), [Project13].[PlanCompleteDate], 102) ,  102) END) <= (convert (datetime2, convert(varchar(255), SysDateTime(), 102) ,  102))) AND ([Project13].[RecipientPersID1] IS NOT NULL) AND ([Project13].[IsActive] = 1))) THEN cast(0 as bit) END AS [C13], 
        CASE WHEN (([Project13].[RecipientPersID1] IS NOT NULL) AND ([Project13].[IsActive] = 1)) THEN cast(1 as bit) WHEN ( NOT (([Project13].[RecipientPersID1] IS NOT NULL) AND ([Project13].[IsActive] = 1))) THEN cast(0 as bit) END AS [C14], 
        CASE WHEN ([Project13].[CreateDate2] IS NULL) THEN [Project13].[CreateDate1] ELSE [Project13].[CreateDate3] END AS [C15], 
        CASE WHEN ([Project13].[C1] IS NULL) THEN [Project13].[CreateDate1] ELSE [Project13].[C2] END AS [C16], 
        CASE WHEN ( EXISTS (SELECT 
            1 AS [C1]
            FROM [dbo].[message_attachments] AS [Extent37]
            WHERE [Project13].[ID1] = [Extent37].[MsgID]
        )) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C17]
        FROM ( SELECT 
            [Project11].[ID] AS [ID], 
            [Project11].[Subject] AS [Subject], 
            [Project11].[PlanCompleteDate] AS [PlanCompleteDate], 
            [Project11].[ID1] AS [ID1], 
            [Project11].[SenderPersID] AS [SenderPersID], 
            [Project11].[RecipientPersID] AS [RecipientPersID], 
            [Project11].[RecipientReadDate] AS [RecipientReadDate], 
            [Project11].[CreateDate] AS [CreateDate], 
            [Project11].[LastChangeDate] AS [LastChangeDate], 
            [Project11].[ContentText] AS [ContentText], 
            [Project11].[IsPrivate] AS [IsPrivate], 
            [Project11].[ID2] AS [ID2], 
            [Project11].[LastName] AS [LastName], 
            [Project11].[FirstName] AS [FirstName], 
            [Project11].[PatrName] AS [PatrName], 
            [Project11].[TabNum] AS [TabNum], 
            [Project11].[ID3] AS [ID3], 
            [Project11].[LastName1] AS [LastName1], 
            [Project11].[FirstName1] AS [FirstName1], 
            [Project11].[PatrName1] AS [PatrName1], 
            [Project11].[TabNum1] AS [TabNum1], 
            [Project11].[ID4] AS [ID4], 
            [Project11].[LastName2] AS [LastName2], 
            [Project11].[FirstName2] AS [FirstName2], 
            [Project11].[PatrName2] AS [PatrName2], 
            [Project11].[TabNum2] AS [TabNum2], 
            [Project11].[Caption] AS [Caption], 
            [Project11].[IsActive] AS [IsActive], 
            [Project11].[Caption1] AS [Caption1], 
            [Project11].[RecipientPersID1] AS [RecipientPersID1], 
            [Project11].[CreateDate1] AS [CreateDate1], 
            [Project11].[CreateDate2] AS [CreateDate2], 
            [Project11].[CreateDate3] AS [CreateDate3], 
            [Project11].[C1] AS [C1], 
            (SELECT 
                MAX([Project12].[CreateDate]) AS [A1]
                FROM ( SELECT 
                    [Extent33].[ID] AS [ID], 
                    [Join28].[ID1] AS [ID1], 
                    [Join28].[CreateDate] AS [CreateDate], 
                    [Join28].[ID2] AS [ID2], 
                    [Join28].[ID3] AS [ID3]
                    FROM  [dbo].[message_comments] AS [Extent33]
                    LEFT OUTER JOIN  (SELECT [Extent34].[ID] AS [ID1], [Extent34].[CreateDate] AS [CreateDate], [Extent35].[ID] AS [ID2], [Extent36].[ID] AS [ID3]
                        FROM   [dbo].[message] AS [Extent34]
                        LEFT OUTER JOIN [dbo].[message_comments] AS [Extent35] ON [Extent34].[ID] = [Extent35].[ID]
                        LEFT OUTER JOIN [dbo].[message_task] AS [Extent36] ON [Extent34].[ID] = [Extent36].[ID] ) AS [Join28] ON [Extent33].[ID] = [Join28].[ID2]
                    WHERE [Project11].[ID] = [Extent33].[TaskID]
                )  AS [Project12]) AS [C2]
            FROM ( SELECT 
                [Project9].[ID] AS [ID], 
                [Project9].[Subject] AS [Subject], 
                [Project9].[PlanCompleteDate] AS [PlanCompleteDate], 
                [Project9].[ID1] AS [ID1], 
                [Project9].[SenderPersID] AS [SenderPersID], 
                [Project9].[RecipientPersID] AS [RecipientPersID], 
                [Project9].[RecipientReadDate] AS [RecipientReadDate], 
                [Project9].[CreateDate] AS [CreateDate], 
                [Project9].[LastChangeDate] AS [LastChangeDate], 
                [Project9].[ContentText] AS [ContentText], 
                [Project9].[IsPrivate] AS [IsPrivate], 
                [Project9].[ID2] AS [ID2], 
                [Project9].[LastName] AS [LastName], 
                [Project9].[FirstName] AS [FirstName], 
                [Project9].[PatrName] AS [PatrName], 
                [Project9].[TabNum] AS [TabNum], 
                [Project9].[ID3] AS [ID3], 
                [Project9].[LastName1] AS [LastName1], 
                [Project9].[FirstName1] AS [FirstName1], 
                [Project9].[PatrName1] AS [PatrName1], 
                [Project9].[TabNum1] AS [TabNum1], 
                [Project9].[ID4] AS [ID4], 
                [Project9].[LastName2] AS [LastName2], 
                [Project9].[FirstName2] AS [FirstName2], 
                [Project9].[PatrName2] AS [PatrName2], 
                [Project9].[TabNum2] AS [TabNum2], 
                [Project9].[Caption] AS [Caption], 
                [Project9].[IsActive] AS [IsActive], 
                [Project9].[Caption1] AS [Caption1], 
                [Project9].[RecipientPersID1] AS [RecipientPersID1], 
                [Project9].[CreateDate1] AS [CreateDate1], 
                [Project9].[CreateDate2] AS [CreateDate2], 
                [Project9].[CreateDate3] AS [CreateDate3], 
                (SELECT 
                    MAX([Project10].[CreateDate]) AS [A1]
                    FROM ( SELECT 
                        [Extent29].[ID] AS [ID], 
                        [Join25].[ID4] AS [ID1], 
                        [Join25].[CreateDate] AS [CreateDate], 
                        [Join25].[ID5] AS [ID2], 
                        [Join25].[ID6] AS [ID3]
                        FROM  [dbo].[message_comments] AS [Extent29]
                        LEFT OUTER JOIN  (SELECT [Extent30].[ID] AS [ID4], [Extent30].[CreateDate] AS [CreateDate], [Extent31].[ID] AS [ID5], [Extent32].[ID] AS [ID6]
                            FROM   [dbo].[message] AS [Extent30]
                            LEFT OUTER JOIN [dbo].[message_comments] AS [Extent31] ON [Extent30].[ID] = [Extent31].[ID]
                            LEFT OUTER JOIN [dbo].[message_task] AS [Extent32] ON [Extent30].[ID] = [Extent32].[ID] ) AS [Join25] ON [Extent29].[ID] = [Join25].[ID5]
                        WHERE [Project9].[ID] = [Extent29].[TaskID]
                    )  AS [Project10]) AS [C1]
                FROM ( SELECT 
                    [Project7].[ID] AS [ID], 
                    [Project7].[Subject] AS [Subject], 
                    [Project7].[PlanCompleteDate] AS [PlanCompleteDate], 
                    [Project7].[ID1] AS [ID1], 
                    [Project7].[SenderPersID] AS [SenderPersID], 
                    [Project7].[RecipientPersID] AS [RecipientPersID], 
                    [Project7].[RecipientReadDate] AS [RecipientReadDate], 
                    [Project7].[CreateDate] AS [CreateDate], 
                    [Project7].[LastChangeDate] AS [LastChangeDate], 
                    [Project7].[ContentText] AS [ContentText], 
                    [Project7].[IsPrivate] AS [IsPrivate], 
                    [Project7].[ID2] AS [ID2], 
                    [Project7].[LastName] AS [LastName], 
                    [Project7].[FirstName] AS [FirstName], 
                    [Project7].[PatrName] AS [PatrName], 
                    [Project7].[TabNum] AS [TabNum], 
                    [Project7].[ID3] AS [ID3], 
                    [Project7].[LastName1] AS [LastName1], 
                    [Project7].[FirstName1] AS [FirstName1], 
                    [Project7].[PatrName1] AS [PatrName1], 
                    [Project7].[TabNum1] AS [TabNum1], 
                    [Project7].[ID4] AS [ID4], 
                    [Project7].[LastName2] AS [LastName2], 
                    [Project7].[FirstName2] AS [FirstName2], 
                    [Project7].[PatrName2] AS [PatrName2], 
                    [Project7].[TabNum2] AS [TabNum2], 
                    [Project7].[Caption] AS [Caption], 
                    [Project7].[IsActive] AS [IsActive], 
                    [Project7].[Caption1] AS [Caption1], 
                    [Project7].[RecipientPersID1] AS [RecipientPersID1], 
                    [Project7].[CreateDate1] AS [CreateDate1], 
                    [Project7].[CreateDate2] AS [CreateDate2], 
                    [Limit4].[ID] AS [ID5], 
                    [Join22].[ID7] AS [ID6], 
                    [Join22].[CreateDate] AS [CreateDate3], 
                    [Join22].[ID8] AS [ID7], 
                    [Join22].[ID9] AS [ID8]
                    FROM    (SELECT 
                        [Project5].[ID] AS [ID], 
                        [Project5].[Subject] AS [Subject], 
                        [Project5].[PlanCompleteDate] AS [PlanCompleteDate], 
                        [Project5].[ID1] AS [ID1], 
                        [Project5].[SenderPersID] AS [SenderPersID], 
                        [Project5].[RecipientPersID] AS [RecipientPersID], 
                        [Project5].[RecipientReadDate] AS [RecipientReadDate], 
                        [Project5].[CreateDate] AS [CreateDate], 
                        [Project5].[LastChangeDate] AS [LastChangeDate], 
                        [Project5].[ContentText] AS [ContentText], 
                        [Project5].[IsPrivate] AS [IsPrivate], 
                        [Project5].[ID2] AS [ID2], 
                        [Project5].[LastName] AS [LastName], 
                        [Project5].[FirstName] AS [FirstName], 
                        [Project5].[PatrName] AS [PatrName], 
                        [Project5].[TabNum] AS [TabNum], 
                        [Project5].[ID3] AS [ID3], 
                        [Project5].[LastName1] AS [LastName1], 
                        [Project5].[FirstName1] AS [FirstName1], 
                        [Project5].[PatrName1] AS [PatrName1], 
                        [Project5].[TabNum1] AS [TabNum1], 
                        [Project5].[ID4] AS [ID4], 
                        [Project5].[LastName2] AS [LastName2], 
                        [Project5].[FirstName2] AS [FirstName2], 
                        [Project5].[PatrName2] AS [PatrName2], 
                        [Project5].[TabNum2] AS [TabNum2], 
                        [Project5].[Caption] AS [Caption], 
                        [Project5].[IsActive] AS [IsActive], 
                        [Project5].[Caption1] AS [Caption1], 
                        [Project5].[RecipientPersID1] AS [RecipientPersID1], 
                        [Project5].[CreateDate1] AS [CreateDate1], 
                        [Limit3].[ID] AS [ID5], 
                        [Join17].[ID10] AS [ID6], 
                        [Join17].[CreateDate] AS [CreateDate2], 
                        [Join17].[ID11] AS [ID7], 
                        [Join17].[ID12] AS [ID8]
                        FROM    (SELECT 
                            [Project3].[ID] AS [ID], 
                            [Project3].[ProjectID] AS [ProjectID], 
                            [Project3].[Subject] AS [Subject], 
                            [Project3].[PlanCompleteDate] AS [PlanCompleteDate], 
                            [Project3].[ID1] AS [ID1], 
                            [Project3].[SenderPersID] AS [SenderPersID], 
                            [Project3].[RecipientPersID] AS [RecipientPersID], 
                            [Project3].[RecipientReadDate] AS [RecipientReadDate], 
                            [Project3].[CreateDate] AS [CreateDate], 
                            [Project3].[LastChangeDate] AS [LastChangeDate], 
                            [Project3].[ContentText] AS [ContentText], 
                            [Project3].[IsPrivate] AS [IsPrivate], 
                            [Project3].[ID2] AS [ID2], 
                            [Project3].[LastName] AS [LastName], 
                            [Project3].[FirstName] AS [FirstName], 
                            [Project3].[PatrName] AS [PatrName], 
                            [Project3].[TabNum] AS [TabNum], 
                            [Project3].[ID3] AS [ID3], 
                            [Project3].[LastName1] AS [LastName1], 
                            [Project3].[FirstName1] AS [FirstName1], 
                            [Project3].[PatrName1] AS [PatrName1], 
                            [Project3].[TabNum1] AS [TabNum1], 
                            [Project3].[ID4] AS [ID4], 
                            [Project3].[LastName2] AS [LastName2], 
                            [Project3].[FirstName2] AS [FirstName2], 
                            [Project3].[PatrName2] AS [PatrName2], 
                            [Project3].[TabNum2] AS [TabNum2], 
                            [Extent12].[Caption] AS [Caption], 
                            [Extent12].[IsActive] AS [IsActive], 
                            [Extent13].[ID] AS [ID5], 
                            [Extent13].[Caption] AS [Caption1], 
                            [Join12].[ID13] AS [ID6], 
                            [Join12].[RecipientPersID] AS [RecipientPersID1], 
                            [Join12].[CreateDate] AS [CreateDate1], 
                            [Join12].[ID14] AS [ID7], 
                            [Join12].[ID15] AS [ID8]
                            FROM      (SELECT 
                                [Project1].[ID] AS [ID], 
                                [Project1].[ProjectID] AS [ProjectID], 
                                [Project1].[Subject] AS [Subject], 
                                [Project1].[PlanCompleteDate] AS [PlanCompleteDate], 
                                [Project1].[ID1] AS [ID1], 
                                [Project1].[SenderPersID] AS [SenderPersID], 
                                [Project1].[RecipientPersID] AS [RecipientPersID], 
                                [Project1].[RecipientReadDate] AS [RecipientReadDate], 
                                [Project1].[CreateDate] AS [CreateDate], 
                                [Project1].[LastChangeDate] AS [LastChangeDate], 
                                [Project1].[ContentText] AS [ContentText], 
                                [Project1].[IsPrivate] AS [IsPrivate], 
                                [Project1].[ID2] AS [ID2], 
                                [Project1].[LastName] AS [LastName], 
                                [Project1].[FirstName] AS [FirstName], 
                                [Project1].[PatrName] AS [PatrName], 
                                [Project1].[TabNum] AS [TabNum], 
                                [Project1].[ID3] AS [ID3], 
                                [Project1].[LastName1] AS [LastName1], 
                                [Project1].[FirstName1] AS [FirstName1], 
                                [Project1].[PatrName1] AS [PatrName1], 
                                [Project1].[TabNum1] AS [TabNum1], 
                                [Project1].[ID4] AS [ID4], 
                                [Project1].[LastName2] AS [LastName2], 
                                [Project1].[FirstName2] AS [FirstName2], 
                                [Project1].[PatrName2] AS [PatrName2], 
                                [Project1].[TabNum2] AS [TabNum2], 
                                [Limit1].[StateID] AS [StateID]
                                FROM   (SELECT 
                                    [Extent1].[ID] AS [ID], 
                                    [Extent1].[ProjectID] AS [ProjectID], 
                                    [Extent1].[Subject] AS [Subject], 
                                    [Extent1].[PlanCompleteDate] AS [PlanCompleteDate], 
                                    [Extent2].[ID] AS [ID1], 
                                    [Extent2].[SenderPersID] AS [SenderPersID], 
                                    [Extent2].[RecipientPersID] AS [RecipientPersID], 
                                    [Extent2].[RecipientReadDate] AS [RecipientReadDate], 
                                    [Extent2].[CreateDate] AS [CreateDate], 
                                    [Extent2].[LastChangeDate] AS [LastChangeDate], 
                                    [Extent2].[ContentText] AS [ContentText], 
                                    [Extent2].[IsPrivate] AS [IsPrivate], 
                                    [Extent3].[ID] AS [ID2], 
                                    [Extent3].[LastName] AS [LastName], 
                                    [Extent3].[FirstName] AS [FirstName], 
                                    [Extent3].[PatrName] AS [PatrName], 
                                    [Extent3].[TabNum] AS [TabNum], 
                                    [Extent4].[ID] AS [ID3], 
                                    [Extent4].[LastName] AS [LastName1], 
                                    [Extent4].[FirstName] AS [FirstName1], 
                                    [Extent4].[PatrName] AS [PatrName1], 
                                    [Extent4].[TabNum] AS [TabNum1], 
                                    [Extent5].[ID] AS [ID4], 
                                    [Extent5].[LastName] AS [LastName2], 
                                    [Extent5].[FirstName] AS [FirstName2], 
                                    [Extent5].[PatrName] AS [PatrName2], 
                                    [Extent5].[TabNum] AS [TabNum2]
                                    FROM     [dbo].[message_task] AS [Extent1]
                                    INNER JOIN [dbo].[message] AS [Extent2] ON [Extent1].[ID] = [Extent2].[ID]
                                    INNER JOIN [dbo].[personal] AS [Extent3] ON [Extent2].[SenderPersID] = [Extent3].[ID]
                                    LEFT OUTER JOIN [dbo].[personal] AS [Extent4] ON [Extent2].[RecipientPersID] = [Extent4].[ID]
                                    LEFT OUTER JOIN [dbo].[personal] AS [Extent5] ON [Extent2].[LastChangePersID] = [Extent5].[ID]
                                    WHERE [Extent1].[ID] = @p__linq__0 ) AS [Project1]
                                OUTER APPLY  (SELECT TOP (1) [Project2].[StateID] AS [StateID]
                                    FROM ( SELECT 
                                        [Extent6].[StateID] AS [StateID], 
                                        [Join5].[CreateDate] AS [CreateDate]
                                        FROM  [dbo].[message_comments] AS [Extent6]
                                        LEFT OUTER JOIN  (SELECT [Extent7].[CreateDate] AS [CreateDate], [Extent8].[ID] AS [ID16]
                                            FROM  [dbo].[message] AS [Extent7]
                                            LEFT OUTER JOIN [dbo].[message_comments] AS [Extent8] ON [Extent7].[ID] = [Extent8].[ID] ) AS [Join5] ON [Extent6].[ID] = [Join5].[ID16]
                                        WHERE ([Project1].[ID] = [Extent6].[TaskID]) AND ([Extent6].[StateID] IS NOT NULL)
                                    )  AS [Project2]
                                    ORDER BY [Project2].[CreateDate] DESC ) AS [Limit1] ) AS [Project3]
                            OUTER APPLY  (SELECT TOP (1) [Project4].[StateID] AS [StateID]
                                FROM ( SELECT 
                                    [Extent9].[StateID] AS [StateID], 
                                    [Join7].[CreateDate] AS [CreateDate]
                                    FROM  [dbo].[message_comments] AS [Extent9]
                                    LEFT OUTER JOIN  (SELECT [Extent10].[CreateDate] AS [CreateDate], [Extent11].[ID] AS [ID17]
                                        FROM  [dbo].[message] AS [Extent10]
                                        LEFT OUTER JOIN [dbo].[message_comments] AS [Extent11] ON [Extent10].[ID] = [Extent11].[ID] ) AS [Join7] ON [Extent9].[ID] = [Join7].[ID17]
                                    WHERE ([Project3].[ID] = [Extent9].[TaskID]) AND ([Extent9].[StateID] IS NOT NULL)
                                )  AS [Project4]
                                ORDER BY [Project4].[CreateDate] DESC ) AS [Limit2]
                            INNER JOIN [dbo].[message_taskStates] AS [Extent12] ON (CASE WHEN ([Project3].[StateID] IS NULL) THEN 1 ELSE [Limit2].[StateID] END) = [Extent12].[ID]
                            LEFT OUTER JOIN [dbo].[projects] AS [Extent13] ON [Project3].[ProjectID] = [Extent13].[ID]
                            LEFT OUTER JOIN  (SELECT [Extent14].[ID] AS [ID13], [Extent14].[RecipientPersID] AS [RecipientPersID], [Extent14].[CreateDate] AS [CreateDate], [Extent15].[ID] AS [ID14], [Extent16].[ID] AS [ID15]
                                FROM   [dbo].[message] AS [Extent14]
                                LEFT OUTER JOIN [dbo].[message_comments] AS [Extent15] ON [Extent14].[ID] = [Extent15].[ID]
                                INNER JOIN [dbo].[message_task] AS [Extent16] ON [Extent14].[ID] = [Extent16].[ID] ) AS [Join12] ON [Project3].[ID] = [Join12].[ID15] ) AS [Project5]
                        OUTER APPLY  (SELECT TOP (1) [Project6].[ID] AS [ID]
                            FROM ( SELECT 
                                [Extent17].[ID] AS [ID], 
                                [Join14].[CreateDate] AS [CreateDate]
                                FROM  [dbo].[message_comments] AS [Extent17]
                                LEFT OUTER JOIN  (SELECT [Extent18].[CreateDate] AS [CreateDate], [Extent19].[ID] AS [ID18]
                                    FROM  [dbo].[message] AS [Extent18]
                                    LEFT OUTER JOIN [dbo].[message_comments] AS [Extent19] ON [Extent18].[ID] = [Extent19].[ID] ) AS [Join14] ON [Extent17].[ID] = [Join14].[ID18]
                                WHERE ([Project5].[ID] = [Extent17].[TaskID]) AND ([Extent17].[StateID] IS NOT NULL)
                            )  AS [Project6]
                            ORDER BY [Project6].[CreateDate] DESC ) AS [Limit3]
                        LEFT OUTER JOIN  (SELECT [Extent20].[ID] AS [ID10], [Extent20].[CreateDate] AS [CreateDate], [Extent21].[ID] AS [ID11], [Extent22].[ID] AS [ID12]
                            FROM   [dbo].[message] AS [Extent20]
                            LEFT OUTER JOIN [dbo].[message_comments] AS [Extent21] ON [Extent20].[ID] = [Extent21].[ID]
                            LEFT OUTER JOIN [dbo].[message_task] AS [Extent22] ON [Extent20].[ID] = [Extent22].[ID] ) AS [Join17] ON [Limit3].[ID] = [Join17].[ID11] ) AS [Project7]
                    OUTER APPLY  (SELECT TOP (1) [Project8].[ID] AS [ID]
                        FROM ( SELECT 
                            [Extent23].[ID] AS [ID], 
                            [Join19].[CreateDate] AS [CreateDate]
                            FROM  [dbo].[message_comments] AS [Extent23]
                            LEFT OUTER JOIN  (SELECT [Extent24].[CreateDate] AS [CreateDate], [Extent25].[ID] AS [ID19]
                                FROM  [dbo].[message] AS [Extent24]
                                LEFT OUTER JOIN [dbo].[message_comments] AS [Extent25] ON [Extent24].[ID] = [Extent25].[ID] ) AS [Join19] ON [Extent23].[ID] = [Join19].[ID19]
                            WHERE ([Project7].[ID] = [Extent23].[TaskID]) AND ([Extent23].[StateID] IS NOT NULL)
                        )  AS [Project8]
                        ORDER BY [Project8].[CreateDate] DESC ) AS [Limit4]
                    LEFT OUTER JOIN  (SELECT [Extent26].[ID] AS [ID7], [Extent26].[CreateDate] AS [CreateDate], [Extent27].[ID] AS [ID8], [Extent28].[ID] AS [ID9]
                        FROM   [dbo].[message] AS [Extent26]
                        LEFT OUTER JOIN [dbo].[message_comments] AS [Extent27] ON [Extent26].[ID] = [Extent27].[ID]
                        LEFT OUTER JOIN [dbo].[message_task] AS [Extent28] ON [Extent26].[ID] = [Extent28].[ID] ) AS [Join22] ON [Limit4].[ID] = [Join22].[ID8]
                )  AS [Project9]
            )  AS [Project11]
        )  AS [Project13]
    )  AS [Limit5]',N'@p__linq__0 int,@p__linq__1 int,@p__linq__2 int,@p__linq__3 int,@p__linq__4 int,@p__linq__5 int,@p__linq__6 int,@p__linq__7 int,@p__linq__8 int,@p__linq__9 datetime2(7)',@p__linq__0=78245,@p__linq__1=3,@p__linq__2=3,@p__linq__3=3,@p__linq__4=3,@p__linq__5=3,@p__linq__6=3,@p__linq__7=3,@p__linq__8=3,@p__linq__9='3000-01-01 00:00:00'

SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 0 ms.

 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.

 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 0 ms.
SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 0 ms.

(1 row(s) affected)
Table 'message_attachments'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'message'. Scan count 0, logical reads 8, physical reads 0, read-ahead reads 0, lob logical reads 3, lob physical reads 0, lob read-ahead reads 0.
Table 'message_comments'. Scan count 6, logical reads 16, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'message_task'. Scan count 0, logical reads 4, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'projects'. Scan count 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'message_taskStates'. Scan count 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'personal'. Scan count 0, logical reads 4, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 18 ms.

 SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 18 ms.