Advertisement
Guest User

Untitled

a guest
Jul 29th, 2015
363
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 8.23 KB | None | 0 0
  1. SELECT
  2.     1 AS [C1],
  3.     [Project14].[C1] AS [C2],
  4.     [Project14].[C2] AS [C3],
  5.     [Project14].[C3] AS [C4],
  6.     [Project14].[C4] AS [C5]
  7.     FROM ( SELECT
  8.         [Project12].[C1] AS [C1],
  9.         [Project12].[C2] AS [C2],
  10.         [Project12].[C3] AS [C3],
  11.         (SELECT
  12.             AVG( CAST( [Limit7].[artifact_dir_size] AS FLOAT)) AS [A1]
  13.             FROM ( SELECT TOP (100) [Project13].[configuration_id] AS [configuration_id], [Project13].[configuration_path] AS [configuration_path], [Project13].[artifact_dir_size] AS [artifact_dir_size]
  14.                 FROM ( SELECT
  15.                     [Extent5].[configuration_id] AS [configuration_id],
  16.                     [Extent5].[configuration_path] AS [configuration_path],
  17.                     [Extent5].[build_date] AS [build_date],
  18.                     [Extent5].[artifact_dir_size] AS [artifact_dir_size]
  19.                     FROM [dbo].[Build] AS [Extent5]
  20.                     WHERE ([Extent5].[configuration_id] = 34204) AND ([Extent5].[build_date] > '30.05.2015 6:10:07')
  21.                 )  AS [Project13]
  22.                 ORDER BY [Project13].[build_date] DESC
  23.             )  AS [Limit7]
  24.             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]
  25.         FROM ( SELECT
  26.             [Project10].[configuration_id] AS [configuration_id],
  27.             [Project10].[configuration_path] AS [configuration_path],
  28.             [Project10].[C1] AS [C1],
  29.             [Project10].[C2] AS [C2],
  30.             (SELECT
  31.                 SUM([Limit6].[artifact_dir_size]) AS [A1]
  32.                 FROM ( SELECT TOP (100) [Project11].[configuration_id] AS [configuration_id], [Project11].[configuration_path] AS [configuration_path], [Project11].[artifact_dir_size] AS [artifact_dir_size]
  33.                     FROM ( SELECT
  34.                         [Extent4].[configuration_id] AS [configuration_id],
  35.                         [Extent4].[configuration_path] AS [configuration_path],
  36.                         [Extent4].[build_date] AS [build_date],
  37.                         [Extent4].[artifact_dir_size] AS [artifact_dir_size]
  38.                         FROM [dbo].[Build] AS [Extent4]
  39.                         WHERE ([Extent4].[configuration_id] = 34204) AND ([Extent4].[build_date] > '30.05.2015 6:10:07')
  40.                     )  AS [Project11]
  41.                     ORDER BY [Project11].[build_date] DESC
  42.                 )  AS [Limit6]
  43.                 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]
  44.             FROM ( SELECT
  45.                 [Project9].[configuration_id] AS [configuration_id],
  46.                 [Project9].[configuration_path] AS [configuration_path],
  47.                 [Project9].[C1] AS [C1],
  48.                 [Project9].[C2] AS [C2]
  49.                 FROM ( SELECT
  50.                     [Project6].[configuration_id] AS [configuration_id],
  51.                     [Project6].[configuration_path] AS [configuration_path],
  52.                     [Project6].[C1] AS [C1],
  53.                     (SELECT TOP (1)
  54.                         [Limit4].[configuration_path] AS [configuration_path]
  55.                         FROM ( SELECT TOP (100) [Project7].[configuration_id] AS [configuration_id], [Project7].[configuration_path] AS [configuration_path]
  56.                             FROM ( SELECT
  57.                                 [Extent3].[configuration_id] AS [configuration_id],
  58.                                 [Extent3].[configuration_path] AS [configuration_path],
  59.                                 [Extent3].[build_date] AS [build_date]
  60.                                 FROM [dbo].[Build] AS [Extent3]
  61.                                 WHERE ([Extent3].[configuration_id] = 34204) AND ([Extent3].[build_date] > '30.05.2015 6:10:07')
  62.                             )  AS [Project7]
  63.                             ORDER BY [Project7].[build_date] DESC
  64.                         )  AS [Limit4]
  65.                         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]
  66.                     FROM ( SELECT
  67.                         [Project5].[configuration_id] AS [configuration_id],
  68.                         [Project5].[configuration_path] AS [configuration_path],
  69.                         [Project5].[C1] AS [C1]
  70.                         FROM ( SELECT
  71.                             [Project2].[configuration_id] AS [configuration_id],
  72.                             [Project2].[configuration_path] AS [configuration_path],
  73.                             (SELECT TOP (1)
  74.                                 [Limit2].[configuration_id] AS [configuration_id]
  75.                                 FROM ( SELECT TOP (100) [Project3].[configuration_id] AS [configuration_id], [Project3].[configuration_path] AS [configuration_path]
  76.                                     FROM ( SELECT
  77.                                         [Extent2].[configuration_id] AS [configuration_id],
  78.                                         [Extent2].[configuration_path] AS [configuration_path],
  79.                                         [Extent2].[build_date] AS [build_date]
  80.                                         FROM [dbo].[Build] AS [Extent2]
  81.                                         WHERE ([Extent2].[configuration_id] = 34204) AND ([Extent2].[build_date] > '30.05.2015 6:10:07')
  82.                                     )  AS [Project3]
  83.                                     ORDER BY [Project3].[build_date] DESC
  84.                                 )  AS [Limit2]
  85.                                 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]
  86.                             FROM ( SELECT
  87.                                 34204 AS [p__linq__0],
  88.                                 '30.05.2015 6:10:07' AS [p__linq__1],
  89.                                 [GroupBy1].[K1] AS [configuration_id],
  90.                                 [GroupBy1].[K2] AS [configuration_path]
  91.                                 FROM ( SELECT
  92.                                     [Limit1].[configuration_id] AS [K1],
  93.                                     [Limit1].[configuration_path] AS [K2],
  94.                                     SUM([Limit1].[artifact_dir_size]) AS [A1]
  95.                                     FROM ( SELECT TOP (100) [Project1].[configuration_id] AS [configuration_id], [Project1].[configuration_path] AS [configuration_path], [Project1].[artifact_dir_size] AS [artifact_dir_size]
  96.                                         FROM ( SELECT
  97.                                             [Extent1].[configuration_id] AS [configuration_id],
  98.                                             [Extent1].[configuration_path] AS [configuration_path],
  99.                                             [Extent1].[build_date] AS [build_date],
  100.                                             [Extent1].[artifact_dir_size] AS [artifact_dir_size]
  101.                                             FROM [dbo].[Build] AS [Extent1]
  102.                                             WHERE ([Extent1].[configuration_id] = 34204) AND ([Extent1].[build_date] > '30.05.2015 6:10:07')
  103.                                         )  AS [Project1]
  104.                                         ORDER BY [Project1].[build_date] DESC
  105.                                     )  AS [Limit1]
  106.                                     GROUP BY [Limit1].[configuration_id], [Limit1].[configuration_path]
  107.                                 )  AS [GroupBy1]
  108.                                 WHERE [GroupBy1].[A1] > 1000000000
  109.                             )  AS [Project2]
  110.                         )  AS [Project5]
  111.                     )  AS [Project6]
  112.                 )  AS [Project9]
  113.             )  AS [Project10]
  114.         )  AS [Project12]
  115.     )  AS [Project14]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement