Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- exec sp_executesql N'SELECT
- [Project2].[ArticleId] AS [ArticleId],
- [Project2].[ArticleGuid] AS [ArticleGuid],
- [Project2].[Name] AS [Name],
- [Project2].[Header] AS [Header],
- [Project2].[Subheader] AS [Subheader],
- [Project2].[Teaser] AS [Teaser],
- [Project2].[Content] AS [Content],
- [Project2].[Alias] AS [Alias],
- [Project2].[Title] AS [Title],
- [Project2].[Description] AS [Description],
- [Project2].[Keywords] AS [Keywords],
- [Project2].[ViewsCount] AS [ViewsCount],
- [Project2].[Region] AS [Region],
- [Project2].[Country] AS [Country],
- [Project2].[Language] AS [Language],
- [Project2].[IsShared] AS [IsShared],
- [Project2].[Version] AS [Version],
- [Project2].[State] AS [State],
- [Project2].[Type] AS [Type],
- [Project2].[CreationDate] AS [CreationDate],
- [Project2].[LastModified] AS [LastModified],
- [Project2].[UserId] AS [UserId],
- [Project2].[UserId1] AS [UserId1],
- [Project2].[Name1] AS [Name1],
- [Project2].[Position] AS [Position],
- [Project2].[C1] AS [C1],
- [Project2].[TagId] AS [TagId],
- [Project2].[Name2] AS [Name2],
- [Project2].[Alias1] AS [Alias1],
- [Project2].[JobKind] AS [JobKind],
- [Project2].[Country1] AS [Country1]
- FROM ( SELECT
- [Filter1].[ArticleId] AS [ArticleId],
- [Filter1].[ArticleGuid] AS [ArticleGuid],
- [Filter1].[Name1] AS [Name],
- [Filter1].[Header] AS [Header],
- [Filter1].[Subheader] AS [Subheader],
- [Filter1].[Teaser] AS [Teaser],
- [Filter1].[Content] AS [Content],
- [Filter1].[Alias] AS [Alias],
- [Filter1].[Title] AS [Title],
- [Filter1].[Description] AS [Description],
- [Filter1].[Keywords] AS [Keywords],
- [Filter1].[ViewsCount] AS [ViewsCount],
- [Filter1].[Region] AS [Region],
- [Filter1].[Country] AS [Country],
- [Filter1].[Language] AS [Language],
- [Filter1].[IsShared] AS [IsShared],
- [Filter1].[Version] AS [Version],
- [Filter1].[State] AS [State],
- [Filter1].[Type] AS [Type],
- [Filter1].[CreationDate] AS [CreationDate],
- [Filter1].[LastModified] AS [LastModified],
- [Filter1].[UserId1] AS [UserId],
- [Filter1].[UserId2] AS [UserId1],
- [Filter1].[Name2] AS [Name1],
- [Filter1].[Position] AS [Position],
- [Join2].[TagId1] AS [TagId],
- [Join2].[Name] AS [Name2],
- [Join2].[Alias] AS [Alias1],
- [Join2].[JobKind] AS [JobKind],
- [Join2].[Country] AS [Country1],
- CASE WHEN ([Join2].[ArticleId] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C1]
- 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]
- FROM [content].[Articles] AS [Extent1]
- LEFT OUTER JOIN [content].[Authors] AS [Extent2] ON [Extent1].[UserId] = [Extent2].[UserId]
- WHERE 2 = [Extent1].[State] ) AS [Filter1]
- 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]
- FROM [content].[ArticleTags] AS [Extent3]
- INNER JOIN [content].[Tags] AS [Extent4] ON [Extent4].[TagId] = [Extent3].[TagId] ) AS [Join2] ON [Filter1].[ArticleId] = [Join2].[ArticleId]
- 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
- 1 AS [C1]
- FROM [content].[ArticleTags] AS [Extent5]
- WHERE ([Filter1].[ArticleId] = [Extent5].[ArticleId]) AND ([Extent5].[TagId] = @p__linq__4)
- ))
- ) AS [Project2]
- 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