Skip to content

Instantly share code, notes, and snippets.

/linq-to-sql.sql

Created October 10, 2012 14:01
Show Gist options
  • Save anonymous/3865826 to your computer and use it in GitHub Desktop.
Save anonymous/3865826 to your computer and use it in GitHub Desktop.
Download ZIP
LINQ to SQL conversion
Raw
linq-to-sql.sql
-- Region Parameters
DECLARE @p0 Float = 1000
DECLARE @p1 Float = 0
DECLARE @p2 Int = 7
DECLARE @p3 Int = 23
-- EndRegion
SELECT [t19].[value2] AS [CampaignID], (
SELECT [t45].[value2]
FROM (
SELECT TOP (1) [t44].[value2]
FROM (
SELECT (
SELECT [t35].[ID]
FROM (
SELECT TOP (1) [t34].[ID]
FROM [AdCreative] AS [t28]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t29].[AdGroupID], [t29].[LocationID]
FROM [AdGroup_Location] AS [t29]
) AS [t30] ON [t28].[AdGroupID] = [t30].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t31] ON [t28].[ID] = [t31].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t32] ON [t32].[ID] = [t31].[AdDimensionID]
INNER JOIN [AdGroup] AS [t33] ON [t33].[ID] = [t28].[AdGroupID]
INNER JOIN [Campaign] AS [t34] ON [t34].[ID] = [t33].[CampaignID]
WHERE ([t27].[ID] = [t28].[ID]) AND ([t28].[AdDimensionID] = @p2) AND (([t30].[test] IS NULL) OR ([t30].[LocationID] = @p3))
) AS [t35]
) AS [value], (
SELECT [t43].[DailyBudget]
FROM (
SELECT TOP (1) [t42].[DailyBudget]
FROM [AdCreative] AS [t36]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t37].[AdGroupID], [t37].[LocationID]
FROM [AdGroup_Location] AS [t37]
) AS [t38] ON [t36].[AdGroupID] = [t38].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t39] ON [t36].[ID] = [t39].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t40] ON [t40].[ID] = [t39].[AdDimensionID]
INNER JOIN [AdGroup] AS [t41] ON [t41].[ID] = [t36].[AdGroupID]
INNER JOIN [Campaign] AS [t42] ON [t42].[ID] = [t41].[CampaignID]
WHERE ([t27].[ID] = [t36].[ID]) AND ([t36].[AdDimensionID] = @p2) AND (([t38].[test] IS NULL) OR ([t38].[LocationID] = @p3))
) AS [t43]
) AS [value2]
FROM (
SELECT [t20].[ID]
FROM [AdCreative] AS [t20]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t21].[AdGroupID], [t21].[LocationID]
FROM [AdGroup_Location] AS [t21]
) AS [t22] ON [t20].[AdGroupID] = [t22].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t23] ON [t20].[ID] = [t23].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t24] ON [t24].[ID] = [t23].[AdDimensionID]
INNER JOIN [AdGroup] AS [t25] ON [t25].[ID] = [t20].[AdGroupID]
INNER JOIN [Campaign] AS [t26] ON [t26].[ID] = [t25].[CampaignID]
WHERE ([t20].[AdDimensionID] = @p2) AND (([t22].[test] IS NULL) OR ([t22].[LocationID] = @p3))
GROUP BY [t20].[ID]
) AS [t27]
) AS [t44]
WHERE (([t19].[value2] IS NULL) AND ([t44].[value] IS NULL)) OR (([t19].[value2] IS NOT NULL) AND ([t44].[value] IS NOT NULL) AND ([t19].[value2] = [t44].[value]))
) AS [t45]
) AS [DailyBudget], [t19].[value] AS [Spent]
FROM (
SELECT SUM([t18].[value]) AS [value], [t18].[value2]
FROM (
SELECT [t9].[value], (
SELECT [t17].[ID]
FROM (
SELECT TOP (1) [t16].[ID]
FROM [AdCreative] AS [t10]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t11].[AdGroupID], [t11].[LocationID]
FROM [AdGroup_Location] AS [t11]
) AS [t12] ON [t10].[AdGroupID] = [t12].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t13] ON [t10].[ID] = [t13].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t14] ON [t14].[ID] = [t13].[AdDimensionID]
INNER JOIN [AdGroup] AS [t15] ON [t15].[ID] = [t10].[AdGroupID]
INNER JOIN [Campaign] AS [t16] ON [t16].[ID] = [t15].[CampaignID]
WHERE ([t9].[ID] = [t10].[ID]) AND ([t10].[AdDimensionID] = @p2) AND (([t12].[test] IS NULL) OR ([t12].[LocationID] = @p3))
) AS [t17]
) AS [value2]
FROM (
SELECT SUM([t8].[value]) AS [value], [t8].[ID]
FROM (
SELECT [t0].[ID],
(CASE
WHEN [t5].[test] IS NOT NULL THEN (CONVERT(Float,[t5].[Credit])) / @p0
ELSE @p1
END) AS [value], [t0].[AdDimensionID], [t2].[test], [t2].[LocationID]
FROM [AdCreative] AS [t0]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t1].[AdGroupID], [t1].[LocationID]
FROM [AdGroup_Location] AS [t1]
) AS [t2] ON [t0].[AdGroupID] = [t2].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t3] ON [t0].[ID] = [t3].[AdID]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t4].[ID], [t4].[Credit]
FROM [AdDimension] AS [t4]
) AS [t5] ON [t5].[ID] = [t3].[AdDimensionID]
INNER JOIN [AdGroup] AS [t6] ON [t6].[ID] = [t0].[AdGroupID]
INNER JOIN [Campaign] AS [t7] ON [t7].[ID] = [t6].[CampaignID]
) AS [t8]
WHERE ([t8].[AdDimensionID] = @p2) AND (([t8].[test] IS NULL) OR ([t8].[LocationID] = @p3))
GROUP BY [t8].[ID]
) AS [t9]
) AS [t18]
GROUP BY [t18].[value2]
) AS [t19]
GO
-- Region Parameters
DECLARE @p0 Int = 7
DECLARE @p1 Int = 23
DECLARE @p2 Float = 1000
DECLARE @p3 Float = 0
DECLARE @x1 Int = 10
-- EndRegion
SELECT [t17].[ID], (
SELECT [t43].[value]
FROM (
SELECT TOP (1) [t42].[value]
FROM (
SELECT [t25].[ID], (
SELECT [t33].[Name]
FROM (
SELECT TOP (1) [t26].[Name]
FROM [AdCreative] AS [t26]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t27].[AdGroupID], [t27].[LocationID]
FROM [AdGroup_Location] AS [t27]
) AS [t28] ON [t26].[AdGroupID] = [t28].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t29] ON [t26].[ID] = [t29].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t30] ON [t30].[ID] = [t29].[AdDimensionID]
INNER JOIN [AdGroup] AS [t31] ON [t31].[ID] = [t26].[AdGroupID]
INNER JOIN [Campaign] AS [t32] ON [t32].[ID] = [t31].[CampaignID]
WHERE ([t25].[ID] = [t26].[ID]) AND ([t26].[AdDimensionID] = @p0) AND (([t28].[test] IS NULL) OR ([t28].[LocationID] = @p1))
) AS [t33]
) AS [value], (
SELECT [t41].[ID]
FROM (
SELECT TOP (1) [t40].[ID]
FROM [AdCreative] AS [t34]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t35].[AdGroupID], [t35].[LocationID]
FROM [AdGroup_Location] AS [t35]
) AS [t36] ON [t34].[AdGroupID] = [t36].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t37] ON [t34].[ID] = [t37].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t38] ON [t38].[ID] = [t37].[AdDimensionID]
INNER JOIN [AdGroup] AS [t39] ON [t39].[ID] = [t34].[AdGroupID]
INNER JOIN [Campaign] AS [t40] ON [t40].[ID] = [t39].[CampaignID]
WHERE ([t25].[ID] = [t34].[ID]) AND ([t34].[AdDimensionID] = @p0) AND (([t36].[test] IS NULL) OR ([t36].[LocationID] = @p1))
) AS [t41]
) AS [value2]
FROM (
SELECT [t18].[ID]
FROM [AdCreative] AS [t18]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t19].[AdGroupID], [t19].[LocationID]
FROM [AdGroup_Location] AS [t19]
) AS [t20] ON [t18].[AdGroupID] = [t20].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t21] ON [t18].[ID] = [t21].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t22] ON [t22].[ID] = [t21].[AdDimensionID]
INNER JOIN [AdGroup] AS [t23] ON [t23].[ID] = [t18].[AdGroupID]
INNER JOIN [Campaign] AS [t24] ON [t24].[ID] = [t23].[CampaignID]
WHERE ([t18].[AdDimensionID] = @p0) AND (([t20].[test] IS NULL) OR ([t20].[LocationID] = @p1))
GROUP BY [t18].[ID]
) AS [t25]
) AS [t42]
WHERE ([t17].[ID] = [t42].[ID]) AND (((@x1 IS NULL) AND ([t42].[value2] IS NULL)) OR ((@x1 IS NOT NULL) AND ([t42].[value2] IS NOT NULL) AND (@x1 = [t42].[value2])))
) AS [t43]
) AS [Name], (
SELECT [t63].[value]
FROM (
SELECT TOP (1) [t62].[value]
FROM (
SELECT [t53].[ID], [t53].[value], (
SELECT [t61].[ID]
FROM (
SELECT TOP (1) [t60].[ID]
FROM [AdCreative] AS [t54]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t55].[AdGroupID], [t55].[LocationID]
FROM [AdGroup_Location] AS [t55]
) AS [t56] ON [t54].[AdGroupID] = [t56].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t57] ON [t54].[ID] = [t57].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t58] ON [t58].[ID] = [t57].[AdDimensionID]
INNER JOIN [AdGroup] AS [t59] ON [t59].[ID] = [t54].[AdGroupID]
INNER JOIN [Campaign] AS [t60] ON [t60].[ID] = [t59].[CampaignID]
WHERE ([t53].[ID] = [t54].[ID]) AND ([t54].[AdDimensionID] = @p0) AND (([t56].[test] IS NULL) OR ([t56].[LocationID] = @p1))
) AS [t61]
) AS [value2]
FROM (
SELECT SUM([t52].[value]) AS [value], [t52].[ID]
FROM (
SELECT [t44].[ID],
(CASE
WHEN [t49].[test] IS NOT NULL THEN (CONVERT(Float,[t49].[Credit])) / @p2
ELSE @p3
END) AS [value], [t44].[AdDimensionID], [t46].[test], [t46].[LocationID]
FROM [AdCreative] AS [t44]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t45].[AdGroupID], [t45].[LocationID]
FROM [AdGroup_Location] AS [t45]
) AS [t46] ON [t44].[AdGroupID] = [t46].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t47] ON [t44].[ID] = [t47].[AdID]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t48].[ID], [t48].[Credit]
FROM [AdDimension] AS [t48]
) AS [t49] ON [t49].[ID] = [t47].[AdDimensionID]
INNER JOIN [AdGroup] AS [t50] ON [t50].[ID] = [t44].[AdGroupID]
INNER JOIN [Campaign] AS [t51] ON [t51].[ID] = [t50].[CampaignID]
) AS [t52]
WHERE ([t52].[AdDimensionID] = @p0) AND (([t52].[test] IS NULL) OR ([t52].[LocationID] = @p1))
GROUP BY [t52].[ID]
) AS [t53]
) AS [t62]
WHERE ([t17].[ID] = [t62].[ID]) AND (((@x1 IS NULL) AND ([t62].[value2] IS NULL)) OR ((@x1 IS NOT NULL) AND ([t62].[value2] IS NOT NULL) AND (@x1 = [t62].[value2])))
) AS [t63]
) AS [Spent]
FROM (
SELECT [t16].[ID]
FROM (
SELECT [t7].[ID], (
SELECT [t15].[ID]
FROM (
SELECT TOP (1) [t14].[ID]
FROM [AdCreative] AS [t8]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t9].[AdGroupID], [t9].[LocationID]
FROM [AdGroup_Location] AS [t9]
) AS [t10] ON [t8].[AdGroupID] = [t10].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t11] ON [t8].[ID] = [t11].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t12] ON [t12].[ID] = [t11].[AdDimensionID]
INNER JOIN [AdGroup] AS [t13] ON [t13].[ID] = [t8].[AdGroupID]
INNER JOIN [Campaign] AS [t14] ON [t14].[ID] = [t13].[CampaignID]
WHERE ([t7].[ID] = [t8].[ID]) AND ([t8].[AdDimensionID] = @p0) AND (([t10].[test] IS NULL) OR ([t10].[LocationID] = @p1))
) AS [t15]
) AS [value]
FROM (
SELECT [t0].[ID]
FROM [AdCreative] AS [t0]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t1].[AdGroupID], [t1].[LocationID]
FROM [AdGroup_Location] AS [t1]
) AS [t2] ON [t0].[AdGroupID] = [t2].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t3] ON [t0].[ID] = [t3].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t4] ON [t4].[ID] = [t3].[AdDimensionID]
INNER JOIN [AdGroup] AS [t5] ON [t5].[ID] = [t0].[AdGroupID]
INNER JOIN [Campaign] AS [t6] ON [t6].[ID] = [t5].[CampaignID]
WHERE ([t0].[AdDimensionID] = @p0) AND (([t2].[test] IS NULL) OR ([t2].[LocationID] = @p1))
GROUP BY [t0].[ID]
) AS [t7]
) AS [t16]
WHERE ((@x1 IS NULL) AND ([t16].[value] IS NULL)) OR ((@x1 IS NOT NULL) AND ([t16].[value] IS NOT NULL) AND (@x1 = [t16].[value]))
GROUP BY [t16].[ID]
) AS [t17]
GO
-- Region Parameters
DECLARE @p0 Int = 7
DECLARE @p1 Int = 23
DECLARE @p2 Float = 1000
DECLARE @p3 Float = 0
DECLARE @x1 Int = 13
-- EndRegion
SELECT [t17].[ID], (
SELECT [t43].[value]
FROM (
SELECT TOP (1) [t42].[value]
FROM (
SELECT [t25].[ID], (
SELECT [t33].[Name]
FROM (
SELECT TOP (1) [t26].[Name]
FROM [AdCreative] AS [t26]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t27].[AdGroupID], [t27].[LocationID]
FROM [AdGroup_Location] AS [t27]
) AS [t28] ON [t26].[AdGroupID] = [t28].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t29] ON [t26].[ID] = [t29].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t30] ON [t30].[ID] = [t29].[AdDimensionID]
INNER JOIN [AdGroup] AS [t31] ON [t31].[ID] = [t26].[AdGroupID]
INNER JOIN [Campaign] AS [t32] ON [t32].[ID] = [t31].[CampaignID]
WHERE ([t25].[ID] = [t26].[ID]) AND ([t26].[AdDimensionID] = @p0) AND (([t28].[test] IS NULL) OR ([t28].[LocationID] = @p1))
) AS [t33]
) AS [value], (
SELECT [t41].[ID]
FROM (
SELECT TOP (1) [t40].[ID]
FROM [AdCreative] AS [t34]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t35].[AdGroupID], [t35].[LocationID]
FROM [AdGroup_Location] AS [t35]
) AS [t36] ON [t34].[AdGroupID] = [t36].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t37] ON [t34].[ID] = [t37].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t38] ON [t38].[ID] = [t37].[AdDimensionID]
INNER JOIN [AdGroup] AS [t39] ON [t39].[ID] = [t34].[AdGroupID]
INNER JOIN [Campaign] AS [t40] ON [t40].[ID] = [t39].[CampaignID]
WHERE ([t25].[ID] = [t34].[ID]) AND ([t34].[AdDimensionID] = @p0) AND (([t36].[test] IS NULL) OR ([t36].[LocationID] = @p1))
) AS [t41]
) AS [value2]
FROM (
SELECT [t18].[ID]
FROM [AdCreative] AS [t18]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t19].[AdGroupID], [t19].[LocationID]
FROM [AdGroup_Location] AS [t19]
) AS [t20] ON [t18].[AdGroupID] = [t20].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t21] ON [t18].[ID] = [t21].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t22] ON [t22].[ID] = [t21].[AdDimensionID]
INNER JOIN [AdGroup] AS [t23] ON [t23].[ID] = [t18].[AdGroupID]
INNER JOIN [Campaign] AS [t24] ON [t24].[ID] = [t23].[CampaignID]
WHERE ([t18].[AdDimensionID] = @p0) AND (([t20].[test] IS NULL) OR ([t20].[LocationID] = @p1))
GROUP BY [t18].[ID]
) AS [t25]
) AS [t42]
WHERE ([t17].[ID] = [t42].[ID]) AND (((@x1 IS NULL) AND ([t42].[value2] IS NULL)) OR ((@x1 IS NOT NULL) AND ([t42].[value2] IS NOT NULL) AND (@x1 = [t42].[value2])))
) AS [t43]
) AS [Name], (
SELECT [t63].[value]
FROM (
SELECT TOP (1) [t62].[value]
FROM (
SELECT [t53].[ID], [t53].[value], (
SELECT [t61].[ID]
FROM (
SELECT TOP (1) [t60].[ID]
FROM [AdCreative] AS [t54]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t55].[AdGroupID], [t55].[LocationID]
FROM [AdGroup_Location] AS [t55]
) AS [t56] ON [t54].[AdGroupID] = [t56].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t57] ON [t54].[ID] = [t57].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t58] ON [t58].[ID] = [t57].[AdDimensionID]
INNER JOIN [AdGroup] AS [t59] ON [t59].[ID] = [t54].[AdGroupID]
INNER JOIN [Campaign] AS [t60] ON [t60].[ID] = [t59].[CampaignID]
WHERE ([t53].[ID] = [t54].[ID]) AND ([t54].[AdDimensionID] = @p0) AND (([t56].[test] IS NULL) OR ([t56].[LocationID] = @p1))
) AS [t61]
) AS [value2]
FROM (
SELECT SUM([t52].[value]) AS [value], [t52].[ID]
FROM (
SELECT [t44].[ID],
(CASE
WHEN [t49].[test] IS NOT NULL THEN (CONVERT(Float,[t49].[Credit])) / @p2
ELSE @p3
END) AS [value], [t44].[AdDimensionID], [t46].[test], [t46].[LocationID]
FROM [AdCreative] AS [t44]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t45].[AdGroupID], [t45].[LocationID]
FROM [AdGroup_Location] AS [t45]
) AS [t46] ON [t44].[AdGroupID] = [t46].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t47] ON [t44].[ID] = [t47].[AdID]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t48].[ID], [t48].[Credit]
FROM [AdDimension] AS [t48]
) AS [t49] ON [t49].[ID] = [t47].[AdDimensionID]
INNER JOIN [AdGroup] AS [t50] ON [t50].[ID] = [t44].[AdGroupID]
INNER JOIN [Campaign] AS [t51] ON [t51].[ID] = [t50].[CampaignID]
) AS [t52]
WHERE ([t52].[AdDimensionID] = @p0) AND (([t52].[test] IS NULL) OR ([t52].[LocationID] = @p1))
GROUP BY [t52].[ID]
) AS [t53]
) AS [t62]
WHERE ([t17].[ID] = [t62].[ID]) AND (((@x1 IS NULL) AND ([t62].[value2] IS NULL)) OR ((@x1 IS NOT NULL) AND ([t62].[value2] IS NOT NULL) AND (@x1 = [t62].[value2])))
) AS [t63]
) AS [Spent]
FROM (
SELECT [t16].[ID]
FROM (
SELECT [t7].[ID], (
SELECT [t15].[ID]
FROM (
SELECT TOP (1) [t14].[ID]
FROM [AdCreative] AS [t8]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t9].[AdGroupID], [t9].[LocationID]
FROM [AdGroup_Location] AS [t9]
) AS [t10] ON [t8].[AdGroupID] = [t10].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t11] ON [t8].[ID] = [t11].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t12] ON [t12].[ID] = [t11].[AdDimensionID]
INNER JOIN [AdGroup] AS [t13] ON [t13].[ID] = [t8].[AdGroupID]
INNER JOIN [Campaign] AS [t14] ON [t14].[ID] = [t13].[CampaignID]
WHERE ([t7].[ID] = [t8].[ID]) AND ([t8].[AdDimensionID] = @p0) AND (([t10].[test] IS NULL) OR ([t10].[LocationID] = @p1))
) AS [t15]
) AS [value]
FROM (
SELECT [t0].[ID]
FROM [AdCreative] AS [t0]
LEFT OUTER JOIN (
SELECT 1 AS [test], [t1].[AdGroupID], [t1].[LocationID]
FROM [AdGroup_Location] AS [t1]
) AS [t2] ON [t0].[AdGroupID] = [t2].[AdGroupID]
LEFT OUTER JOIN [AdHit] AS [t3] ON [t0].[ID] = [t3].[AdID]
LEFT OUTER JOIN [AdDimension] AS [t4] ON [t4].[ID] = [t3].[AdDimensionID]
INNER JOIN [AdGroup] AS [t5] ON [t5].[ID] = [t0].[AdGroupID]
INNER JOIN [Campaign] AS [t6] ON [t6].[ID] = [t5].[CampaignID]
WHERE ([t0].[AdDimensionID] = @p0) AND (([t2].[test] IS NULL) OR ([t2].[LocationID] = @p1))
GROUP BY [t0].[ID]
) AS [t7]
) AS [t16]
WHERE ((@x1 IS NULL) AND ([t16].[value] IS NULL)) OR ((@x1 IS NOT NULL) AND ([t16].[value] IS NOT NULL) AND (@x1 = [t16].[value]))
GROUP BY [t16].[ID]
) AS [t17]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment