Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- 1 AS [C1],
- [Project14].[C1] AS [C2],
- [Project14].[C2] AS [C3],
- [Project14].[C3] AS [C4],
- [Project14].[C4] AS [C5]
- FROM ( SELECT
- [Project12].[C1] AS [C1],
- [Project12].[C2] AS [C2],
- [Project12].[C3] AS [C3],
- (SELECT
- AVG( CAST( [Limit7].[artifact_dir_size] AS FLOAT)) AS [A1]
- FROM ( SELECT TOP (100) [Project13].[configuration_id] AS [configuration_id], [Project13].[configuration_path] AS [configuration_path], [Project13].[artifact_dir_size] AS [artifact_dir_size]
- FROM ( SELECT
- [Extent5].[configuration_id] AS [configuration_id],
- [Extent5].[configuration_path] AS [configuration_path],
- [Extent5].[build_date] AS [build_date],
- [Extent5].[artifact_dir_size] AS [artifact_dir_size]
- FROM [dbo].[Build] AS [Extent5]
- WHERE ([Extent5].[configuration_id] = 34204) AND ([Extent5].[build_date] > '30.05.2015 6:10:07')
- ) AS [Project13]
- ORDER BY [Project13].[build_date] DESC
- ) AS [Limit7]
- WHERE ([Project12].[configuration_id] = [Limit7].[configuration_id]) AND (([Project12].[configuration_path] = [Limit7].[configuration_path]) OR (([Project12].[configuration_path] IS NULL) AND ([Limit7].[configuration_path] IS NULL)))) AS [C4]
- FROM ( SELECT
- [Project10].[configuration_id] AS [configuration_id],
- [Project10].[configuration_path] AS [configuration_path],
- [Project10].[C1] AS [C1],
- [Project10].[C2] AS [C2],
- (SELECT
- SUM([Limit6].[artifact_dir_size]) AS [A1]
- FROM ( SELECT TOP (100) [Project11].[configuration_id] AS [configuration_id], [Project11].[configuration_path] AS [configuration_path], [Project11].[artifact_dir_size] AS [artifact_dir_size]
- FROM ( SELECT
- [Extent4].[configuration_id] AS [configuration_id],
- [Extent4].[configuration_path] AS [configuration_path],
- [Extent4].[build_date] AS [build_date],
- [Extent4].[artifact_dir_size] AS [artifact_dir_size]
- FROM [dbo].[Build] AS [Extent4]
- WHERE ([Extent4].[configuration_id] = 34204) AND ([Extent4].[build_date] > '30.05.2015 6:10:07')
- ) AS [Project11]
- ORDER BY [Project11].[build_date] DESC
- ) AS [Limit6]
- WHERE ([Project10].[configuration_id] = [Limit6].[configuration_id]) AND (([Project10].[configuration_path] = [Limit6].[configuration_path]) OR (([Project10].[configuration_path] IS NULL) AND ([Limit6].[configuration_path] IS NULL)))) AS [C3]
- FROM ( SELECT
- [Project9].[configuration_id] AS [configuration_id],
- [Project9].[configuration_path] AS [configuration_path],
- [Project9].[C1] AS [C1],
- [Project9].[C2] AS [C2]
- FROM ( SELECT
- [Project6].[configuration_id] AS [configuration_id],
- [Project6].[configuration_path] AS [configuration_path],
- [Project6].[C1] AS [C1],
- (SELECT TOP (1)
- [Limit4].[configuration_path] AS [configuration_path]
- FROM ( SELECT TOP (100) [Project7].[configuration_id] AS [configuration_id], [Project7].[configuration_path] AS [configuration_path]
- FROM ( SELECT
- [Extent3].[configuration_id] AS [configuration_id],
- [Extent3].[configuration_path] AS [configuration_path],
- [Extent3].[build_date] AS [build_date]
- FROM [dbo].[Build] AS [Extent3]
- WHERE ([Extent3].[configuration_id] = 34204) AND ([Extent3].[build_date] > '30.05.2015 6:10:07')
- ) AS [Project7]
- ORDER BY [Project7].[build_date] DESC
- ) AS [Limit4]
- WHERE ([Project6].[configuration_id] = [Limit4].[configuration_id]) AND (([Project6].[configuration_path] = [Limit4].[configuration_path]) OR (([Project6].[configuration_path] IS NULL) AND ([Limit4].[configuration_path] IS NULL)))) AS [C2]
- FROM ( SELECT
- [Project5].[configuration_id] AS [configuration_id],
- [Project5].[configuration_path] AS [configuration_path],
- [Project5].[C1] AS [C1]
- FROM ( SELECT
- [Project2].[configuration_id] AS [configuration_id],
- [Project2].[configuration_path] AS [configuration_path],
- (SELECT TOP (1)
- [Limit2].[configuration_id] AS [configuration_id]
- FROM ( SELECT TOP (100) [Project3].[configuration_id] AS [configuration_id], [Project3].[configuration_path] AS [configuration_path]
- FROM ( SELECT
- [Extent2].[configuration_id] AS [configuration_id],
- [Extent2].[configuration_path] AS [configuration_path],
- [Extent2].[build_date] AS [build_date]
- FROM [dbo].[Build] AS [Extent2]
- WHERE ([Extent2].[configuration_id] = 34204) AND ([Extent2].[build_date] > '30.05.2015 6:10:07')
- ) AS [Project3]
- ORDER BY [Project3].[build_date] DESC
- ) AS [Limit2]
- WHERE ([Project2].[configuration_id] = [Limit2].[configuration_id]) AND (([Project2].[configuration_path] = [Limit2].[configuration_path]) OR (([Project2].[configuration_path] IS NULL) AND ([Limit2].[configuration_path] IS NULL)))) AS [C1]
- FROM ( SELECT
- 34204 AS [p__linq__0],
- '30.05.2015 6:10:07' AS [p__linq__1],
- [GroupBy1].[K1] AS [configuration_id],
- [GroupBy1].[K2] AS [configuration_path]
- FROM ( SELECT
- [Limit1].[configuration_id] AS [K1],
- [Limit1].[configuration_path] AS [K2],
- SUM([Limit1].[artifact_dir_size]) AS [A1]
- FROM ( SELECT TOP (100) [Project1].[configuration_id] AS [configuration_id], [Project1].[configuration_path] AS [configuration_path], [Project1].[artifact_dir_size] AS [artifact_dir_size]
- FROM ( SELECT
- [Extent1].[configuration_id] AS [configuration_id],
- [Extent1].[configuration_path] AS [configuration_path],
- [Extent1].[build_date] AS [build_date],
- [Extent1].[artifact_dir_size] AS [artifact_dir_size]
- FROM [dbo].[Build] AS [Extent1]
- WHERE ([Extent1].[configuration_id] = 34204) AND ([Extent1].[build_date] > '30.05.2015 6:10:07')
- ) AS [Project1]
- ORDER BY [Project1].[build_date] DESC
- ) AS [Limit1]
- GROUP BY [Limit1].[configuration_id], [Limit1].[configuration_path]
- ) AS [GroupBy1]
- WHERE [GroupBy1].[A1] > 1000000000
- ) AS [Project2]
- ) AS [Project5]
- ) AS [Project6]
- ) AS [Project9]
- ) AS [Project10]
- ) AS [Project12]
- ) AS [Project14]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement