SELECT
    [Project3].[CampaignId] AS [CampaignId],
    [Project3].[TargetGroupId] AS [TargetGroupId],
    [Project3].[TemplateId] AS [TemplateId],
    [Project3].[C1] AS [C1],
    [Project3].[OptimoveId] AS [OptimoveId],
    [Project3].[Date] AS [Date],
    [Project3].[EndTime] AS [EndTime],
    [Project3].[LeadTime] AS [LeadTime],
    [Project3].[Name] AS [Name],
    [Project3].[PlatformId] AS [PlatformId],
    [Project3].[Status] AS [Status],
    [Project3].[Name1] AS [Name1],
    [Project3].[C2] AS [C2],
    [Project3].[C3] AS [C3]
    --[Project3].[C4] AS [C4]
  --  [Project3].[Name2] AS [Name2]
    FROM ( SELECT
        [Limit1].[CampaignId] AS [CampaignId],
        [Limit1].[OptimoveId] AS [OptimoveId],
        [Limit1].[Date] AS [Date],
        [Limit1].[EndTime] AS [EndTime],
        [Limit1].[LeadTime] AS [LeadTime],
        [Limit1].[PlatformId] AS [PlatformId],
        [Limit1].[Status] AS [Status],
        [Limit1].[TargetGroupId] AS [TargetGroupId],
        [Limit1].[Name] AS [Name],
        [Limit1].[TemplateId] AS [TemplateId],
        [Limit1].[Name1] AS [Name1],
        [Limit1].[C1] AS [C1],
        --[Distinct1].[Name] AS [Name2],
        [Limit1].[C2] AS [C2],
        [Limit1].[C3] AS [C3]
    --    CASE WHEN ([Distinct1].[Name] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C4]
        FROM   (SELECT [Project1].[CampaignId] AS [CampaignId], [Project1].[OptimoveId] AS [OptimoveId], [Project1].[Date] AS [Date], [Project1].[EndTime] AS [EndTime], [Project1].[LeadTime] AS [LeadTime], [Project1].[PlatformId] AS [PlatformId], [Project1].[Status] AS [Status], [Project1].[TargetGroupId] AS [TargetGroupId], [Project1].[Name] AS [Name], [Project1].[TemplateId] AS [TemplateId], [Project1].[Name1] AS [Name1], [Project1].[C1] AS [C1], [Project1].[C2] AS [C2], [Project1].[C3] AS [C3]
            FROM ( SELECT
                [Extent1].[CampaignId] AS [CampaignId],
                [Extent1].[OptimoveId] AS [OptimoveId],
                [Extent1].[Date] AS [Date],
                [Extent1].[EndTime] AS [EndTime],
                [Extent1].[LeadTime] AS [LeadTime],
                [Extent1].[PlatformId] AS [PlatformId],
                [Extent1].[Status] AS [Status],
                [Extent2].[TargetGroupId] AS [TargetGroupId],
                [Extent2].[Name] AS [Name],
                [Extent3].[TemplateId] AS [TemplateId],
                [Extent3].[Name] AS [Name1],
                1 AS [C1],
                CASE WHEN ([Extent2].[Discriminator] IN (N'CriteriaTargetGroup',N'CustomerSetTargetGroup')) THEN cast(1 as bit) WHEN ( NOT ([Extent2].[Discriminator] IN (N'CriteriaTargetGroup',N'CustomerSetTargetGroup'))) THEN cast(0 as bit) END AS [C2],
                CASE WHEN ([Extent2].[Discriminator] = N'CriteriaTargetGroup') THEN cast(1 as bit) WHEN ([Extent2].[Discriminator] <> N'CriteriaTargetGroup') THEN cast(0 as bit) END AS [C3]
                FROM   [dbo].[Campaigns] AS [Extent1]
                LEFT OUTER JOIN [dbo].[TargetGroups] AS [Extent2] ON ([Extent2].[Discriminator] IN (N'CriteriaTargetGroup',N'CustomerSetTargetGroup',N'OptimoveTargetGroup',N'TargetGroup')) AND ([Extent1].[TargetGroupId] = [Extent2].[TargetGroupId])
                LEFT OUTER JOIN [dbo].[Templates] AS [Extent3] ON (CASE WHEN ([Extent2].[Discriminator] = N'CriteriaTargetGroup') THEN [Extent2].[TemplateId] END) = [Extent3].[TemplateId]
                WHERE ([Extent1].[PlatformId] = 'gaminator') OR (([Extent1].[PlatformId] IS NULL) AND ('gaminator' IS NULL))
            )  AS [Project1]
            ORDER BY [Project1].[CampaignId] DESC
            OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY  ) AS [Limit1]
    --    OUTER APPLY  (SELECT DISTINCT
    --        [Extent5].[Name] AS [Name]
    --        FROM  [dbo].[CustomerMessages] AS [Extent4]
    --        INNER JOIN [dbo].[Templates] AS [Extent5] ON [Extent4].[TemplateId] = [Extent5].[TemplateId]
    --        --WHERE [Extent4].[CampaignId] = [Limit1].[CampaignId]
			 --) AS [Distinct1]
    )  AS [Project3]
    ORDER BY [Project3].[CampaignId] DESC, [Project3].[TargetGroupId] ASC, [Project3].[TemplateId] ASC