ruMoonGuard

Untitled

Dec 11th, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 4.90 KB | None | 0 0
  1. exec sp_executesql N'SELECT
  2.    [Project2].[ArticleId] AS [ArticleId],
  3.    [Project2].[ArticleGuid] AS [ArticleGuid],
  4.    [Project2].[Name] AS [Name],
  5.    [Project2].[Header] AS [Header],
  6.    [Project2].[Subheader] AS [Subheader],
  7.    [Project2].[Teaser] AS [Teaser],
  8.    [Project2].[Content] AS [Content],
  9.    [Project2].[Alias] AS [Alias],
  10.    [Project2].[Title] AS [Title],
  11.    [Project2].[Description] AS [Description],
  12.    [Project2].[Keywords] AS [Keywords],
  13.    [Project2].[ViewsCount] AS [ViewsCount],
  14.    [Project2].[Region] AS [Region],
  15.    [Project2].[Country] AS [Country],
  16.    [Project2].[Language] AS [Language],
  17.    [Project2].[IsShared] AS [IsShared],
  18.    [Project2].[Version] AS [Version],
  19.    [Project2].[State] AS [State],
  20.    [Project2].[Type] AS [Type],
  21.    [Project2].[CreationDate] AS [CreationDate],
  22.    [Project2].[LastModified] AS [LastModified],
  23.    [Project2].[UserId] AS [UserId],
  24.    [Project2].[UserId1] AS [UserId1],
  25.    [Project2].[Name1] AS [Name1],
  26.    [Project2].[Position] AS [Position],
  27.    [Project2].[C1] AS [C1],
  28.    [Project2].[TagId] AS [TagId],
  29.    [Project2].[Name2] AS [Name2],
  30.    [Project2].[Alias1] AS [Alias1],
  31.    [Project2].[JobKind] AS [JobKind],
  32.    [Project2].[Country1] AS [Country1]
  33.    FROM ( SELECT
  34.        [Filter1].[ArticleId] AS [ArticleId],
  35.        [Filter1].[ArticleGuid] AS [ArticleGuid],
  36.        [Filter1].[Name1] AS [Name],
  37.        [Filter1].[Header] AS [Header],
  38.        [Filter1].[Subheader] AS [Subheader],
  39.        [Filter1].[Teaser] AS [Teaser],
  40.        [Filter1].[Content] AS [Content],
  41.        [Filter1].[Alias] AS [Alias],
  42.        [Filter1].[Title] AS [Title],
  43.        [Filter1].[Description] AS [Description],
  44.        [Filter1].[Keywords] AS [Keywords],
  45.        [Filter1].[ViewsCount] AS [ViewsCount],
  46.        [Filter1].[Region] AS [Region],
  47.        [Filter1].[Country] AS [Country],
  48.        [Filter1].[Language] AS [Language],
  49.        [Filter1].[IsShared] AS [IsShared],
  50.        [Filter1].[Version] AS [Version],
  51.        [Filter1].[State] AS [State],
  52.        [Filter1].[Type] AS [Type],
  53.        [Filter1].[CreationDate] AS [CreationDate],
  54.        [Filter1].[LastModified] AS [LastModified],
  55.        [Filter1].[UserId1] AS [UserId],
  56.        [Filter1].[UserId2] AS [UserId1],
  57.        [Filter1].[Name2] AS [Name1],
  58.        [Filter1].[Position] AS [Position],
  59.        [Join2].[TagId1] AS [TagId],
  60.        [Join2].[Name] AS [Name2],
  61.        [Join2].[Alias] AS [Alias1],
  62.        [Join2].[JobKind] AS [JobKind],
  63.        [Join2].[Country] AS [Country1],
  64.        CASE WHEN ([Join2].[ArticleId] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C1]
  65.        FROM   (SELECT [Extent1].[ArticleId] AS [ArticleId], [Extent1].[ArticleGuid] AS [ArticleGuid], [Extent1].[Name] AS [Name1], [Extent1].[Header] AS [Header], [Extent1].[Subheader] AS [Subheader], [Extent1].[Teaser] AS [Teaser], [Extent1].[Content] AS [Content], [Extent1].[Alias] AS [Alias], [Extent1].[Title] AS [Title], [Extent1].[Description] AS [Description], [Extent1].[Keywords] AS [Keywords], [Extent1].[ViewsCount] AS [ViewsCount], [Extent1].[Region] AS [Region], [Extent1].[Country] AS [Country], [Extent1].[Language] AS [Language], [Extent1].[IsShared] AS [IsShared], [Extent1].[Version] AS [Version], [Extent1].[State] AS [State], [Extent1].[Type] AS [Type], [Extent1].[CreationDate] AS [CreationDate], [Extent1].[LastModified] AS [LastModified], [Extent1].[UserId] AS [UserId1], [Extent2].[UserId] AS [UserId2], [Extent2].[Name] AS [Name2], [Extent2].[Position] AS [Position]
  66.            FROM  [content].[Articles] AS [Extent1]
  67.            LEFT OUTER JOIN [content].[Authors] AS [Extent2] ON [Extent1].[UserId] = [Extent2].[UserId]
  68.            WHERE 2 = [Extent1].[State] ) AS [Filter1]
  69.        LEFT OUTER JOIN  (SELECT [Extent3].[ArticleId] AS [ArticleId], [Extent4].[TagId] AS [TagId1], [Extent4].[Name] AS [Name], [Extent4].[Alias] AS [Alias], [Extent4].[JobKind] AS [JobKind], [Extent4].[Country] AS [Country]
  70.            FROM  [content].[ArticleTags] AS [Extent3]
  71.            INNER JOIN [content].[Tags] AS [Extent4] ON [Extent4].[TagId] = [Extent3].[TagId] ) AS [Join2] ON [Filter1].[ArticleId] = [Join2].[ArticleId]
  72.        WHERE ([Filter1].[Region] IS NULL OR @p__linq__0 =  CAST( [Filter1].[Region] AS int)) AND ([Filter1].[IsShared] = 1 OR @p__linq__1 =  CAST( [Filter1].[Country] AS int)) AND ([Filter1].[Language] = @p__linq__2) AND ([Filter1].[Type] = @p__linq__3) AND ( EXISTS (SELECT
  73.            1 AS [C1]
  74.            FROM [content].[ArticleTags] AS [Extent5]
  75.            WHERE ([Filter1].[ArticleId] = [Extent5].[ArticleId]) AND ([Extent5].[TagId] = @p__linq__4)
  76.        ))
  77.    )  AS [Project2]
  78.    ORDER BY [Project2].[ArticleId] ASC, [Project2].[UserId1] ASC, [Project2].[C1] ASC',N'@p__linq__0 int,@p__linq__1 int,@p__linq__2 int,@p__linq__3 int,@p__linq__4 int',@p__linq__0=1,@p__linq__1=1,@p__linq__2=1,@p__linq__3=1,@p__linq__4=2
Advertisement
Add Comment
Please, Sign In to add comment