Created
July 9, 2016 21:32
-
-
Save junderhill/87caceac728809a8ca837b9d8b5189f3 to your computer and use it in GitHub Desktop.
EF Intercept Generated SQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| [Project2].[AccessFailedCount] AS [AccessFailedCount], | |
| [Project2].[Id] AS [Id], | |
| [Project2].[IsRequestor] AS [IsRequestor], | |
| [Project2].[IsApprover] AS [IsApprover], | |
| [Project2].[IsAdministrator] AS [IsAdministrator], | |
| [Project2].[IsSuperUser] AS [IsSuperUser], | |
| [Project2].[SiteId] AS [SiteId], | |
| [Project2].[FirstName] AS [FirstName], | |
| [Project2].[LastName] AS [LastName], | |
| [Project2].[DoctorId] AS [DoctorId], | |
| [Project2].[Email] AS [Email], | |
| [Project2].[EmailConfirmed] AS [EmailConfirmed], | |
| [Project2].[PasswordHash] AS [PasswordHash], | |
| [Project2].[SecurityStamp] AS [SecurityStamp], | |
| [Project2].[PhoneNumber] AS [PhoneNumber], | |
| [Project2].[PhoneNumberConfirmed] AS [PhoneNumberConfirmed], | |
| [Project2].[TwoFactorEnabled] AS [TwoFactorEnabled], | |
| [Project2].[LockoutEndDateUtc] AS [LockoutEndDateUtc], | |
| [Project2].[LockoutEnabled] AS [LockoutEnabled], | |
| [Project2].[UserName] AS [UserName], | |
| [Project2].[Site_Id] AS [Site_Id], | |
| [Project2].[Site_Id1] AS [Site_Id1], | |
| [Project2].[C2] AS [C1], | |
| [Project2].[SwRole_Id] AS [SwRole_Id], | |
| [Project2].[User_Id] AS [User_Id], | |
| [Project2].[Id1] AS [Id1], | |
| [Project2].[Description] AS [Description], | |
| [Project2].[SiteId1] AS [SiteId1], | |
| [Project2].[IsDeleted] AS [IsDeleted], | |
| [Project2].[DeletedTimeStamp] AS [DeletedTimeStamp], | |
| [Project2].[C1] AS [C2], | |
| [Project2].[Id2] AS [Id2], | |
| [Project2].[RoleId] AS [RoleId], | |
| [Project2].[ActionId] AS [ActionId], | |
| [Project2].[Allowed] AS [Allowed], | |
| [Project2].[IsDeleted1] AS [IsDeleted1], | |
| [Project2].[DeletedTimeStamp1] AS [DeletedTimeStamp1], | |
| [Project2].[Id3] AS [Id3], | |
| [Project2].[Type] AS [Type], | |
| [Project2].[Description1] AS [Description1], | |
| [Project2].[IsDeleted2] AS [IsDeleted2], | |
| [Project2].[DeletedTimeStamp2] AS [DeletedTimeStamp2] | |
| FROM ( SELECT | |
| [Limit1].[Id] AS [Id], | |
| [Limit1].[IsRequestor] AS [IsRequestor], | |
| [Limit1].[IsApprover] AS [IsApprover], | |
| [Limit1].[IsAdministrator] AS [IsAdministrator], | |
| [Limit1].[IsSuperUser] AS [IsSuperUser], | |
| [Limit1].[SiteId] AS [SiteId], | |
| [Limit1].[FirstName] AS [FirstName], | |
| [Limit1].[LastName] AS [LastName], | |
| [Limit1].[DoctorId] AS [DoctorId], | |
| [Limit1].[Email] AS [Email], | |
| [Limit1].[EmailConfirmed] AS [EmailConfirmed], | |
| [Limit1].[PasswordHash] AS [PasswordHash], | |
| [Limit1].[SecurityStamp] AS [SecurityStamp], | |
| [Limit1].[PhoneNumber] AS [PhoneNumber], | |
| [Limit1].[PhoneNumberConfirmed] AS [PhoneNumberConfirmed], | |
| [Limit1].[TwoFactorEnabled] AS [TwoFactorEnabled], | |
| [Limit1].[LockoutEndDateUtc] AS [LockoutEndDateUtc], | |
| [Limit1].[LockoutEnabled] AS [LockoutEnabled], | |
| [Limit1].[AccessFailedCount] AS [AccessFailedCount], | |
| [Limit1].[UserName] AS [UserName], | |
| [Limit1].[Site_Id] AS [Site_Id], | |
| [Limit1].[Site_Id1] AS [Site_Id1], | |
| [Join3].[SwRole_Id] AS [SwRole_Id], | |
| [Join3].[User_Id] AS [User_Id], | |
| [Join3].[Id1] AS [Id1], | |
| [Join3].[Description1] AS [Description], | |
| [Join3].[SiteId] AS [SiteId1], | |
| [Join3].[IsDeleted1] AS [IsDeleted], | |
| [Join3].[DeletedTimeStamp1] AS [DeletedTimeStamp], | |
| [Join3].[Id2] AS [Id2], | |
| [Join3].[RoleId] AS [RoleId], | |
| [Join3].[ActionId] AS [ActionId], | |
| [Join3].[Allowed] AS [Allowed], | |
| [Join3].[IsDeleted2] AS [IsDeleted1], | |
| [Join3].[DeletedTimeStamp2] AS [DeletedTimeStamp1], | |
| [Join3].[Id3] AS [Id3], | |
| [Join3].[Type] AS [Type], | |
| [Join3].[Description2] AS [Description1], | |
| [Join3].[IsDeleted3] AS [IsDeleted2], | |
| [Join3].[DeletedTimeStamp3] AS [DeletedTimeStamp2], | |
| CASE WHEN ([Join3].[SwRole_Id] IS NULL) THEN CAST(NULL AS int) WHEN ([Join3].[Id2] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C1], | |
| CASE WHEN ([Join3].[SwRole_Id] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C2] | |
| FROM (SELECT TOP (1) | |
| [Extent1].[Id] AS [Id], | |
| [Extent1].[IsRequestor] AS [IsRequestor], | |
| [Extent1].[IsApprover] AS [IsApprover], | |
| [Extent1].[IsAdministrator] AS [IsAdministrator], | |
| [Extent1].[IsSuperUser] AS [IsSuperUser], | |
| [Extent1].[SiteId] AS [SiteId], | |
| [Extent1].[FirstName] AS [FirstName], | |
| [Extent1].[LastName] AS [LastName], | |
| [Extent1].[DoctorId] AS [DoctorId], | |
| [Extent1].[Email] AS [Email], | |
| [Extent1].[EmailConfirmed] AS [EmailConfirmed], | |
| [Extent1].[PasswordHash] AS [PasswordHash], | |
| [Extent1].[SecurityStamp] AS [SecurityStamp], | |
| [Extent1].[PhoneNumber] AS [PhoneNumber], | |
| [Extent1].[PhoneNumberConfirmed] AS [PhoneNumberConfirmed], | |
| [Extent1].[TwoFactorEnabled] AS [TwoFactorEnabled], | |
| [Extent1].[LockoutEndDateUtc] AS [LockoutEndDateUtc], | |
| [Extent1].[LockoutEnabled] AS [LockoutEnabled], | |
| [Extent1].[AccessFailedCount] AS [AccessFailedCount], | |
| [Extent1].[UserName] AS [UserName], | |
| [Extent1].[Site_Id] AS [Site_Id], | |
| [Extent1].[Site_Id1] AS [Site_Id1] | |
| FROM [dbo].[AspNetUsers] AS [Extent1] | |
| WHERE [Extent1].[Id] = @p__linq__0 ) AS [Limit1] | |
| LEFT OUTER JOIN (SELECT [Extent2].[SwRole_Id] AS [SwRole_Id], [Extent2].[User_Id] AS [User_Id], [Extent3].[Id] AS [Id1], [Extent3].[Description] AS [Description1], [Extent3].[SiteId] AS [SiteId], [Extent3].[IsDeleted] AS [IsDeleted1], [Extent3].[DeletedTimeStamp] AS [DeletedTimeStamp1], [Join2].[Id2], [Join2].[RoleId], [Join2].[ActionId], [Join2].[Allowed], [Join2].[IsDeleted2], [Join2].[DeletedTimeStamp2], [Join2].[Id3], [Join2].[Type], [Join2].[Description2], [Join2].[IsDeleted3], [Join2].[DeletedTimeStamp3] | |
| FROM [dbo].[SwRoleUsers] AS [Extent2] | |
| INNER JOIN (SELECT [Var_199].[Id] AS [Id], [Var_199].[Description] AS [Description], [Var_199].[SiteId] AS [SiteId], [Var_199].[IsDeleted] AS [IsDeleted], [Var_199].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_202].[Id] AS [Id], [Var_202].[Description] AS [Description], [Var_202].[SiteId] AS [SiteId], [Var_202].[IsDeleted] AS [IsDeleted], [Var_202].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_205].[Id] AS [Id], [Var_205].[Description] AS [Description], [Var_205].[SiteId] AS [SiteId], [Var_205].[IsDeleted] AS [IsDeleted], [Var_205].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_208].[Id] AS [Id], [Var_208].[Description] AS [Description], [Var_208].[SiteId] AS [SiteId], [Var_208].[IsDeleted] AS [IsDeleted], [Var_208].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_211].[Id] AS [Id], [Var_211].[Description] AS [Description], [Var_211].[SiteId] AS [SiteId], [Var_211].[IsDeleted] AS [IsDeleted], [Var_211].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_214].[Id] AS [Id], [Var_214].[Description] AS [Description], [Var_214].[SiteId] AS [SiteId], [Var_214].[IsDeleted] AS [IsDeleted], [Var_214].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_217].[Id] AS [Id], [Var_217].[Description] AS [Description], [Var_217].[SiteId] AS [SiteId], [Var_217].[IsDeleted] AS [IsDeleted], [Var_217].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_220].[Id] AS [Id], [Var_220].[Description] AS [Description], [Var_220].[SiteId] AS [SiteId], [Var_220].[IsDeleted] AS [IsDeleted], [Var_220].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_223].[Id] AS [Id], [Var_223].[Description] AS [Description], [Var_223].[SiteId] AS [SiteId], [Var_223].[IsDeleted] AS [IsDeleted], [Var_223].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_226].[Id] AS [Id], [Var_226].[Description] AS [Description], [Var_226].[SiteId] AS [SiteId], [Var_226].[IsDeleted] AS [IsDeleted], [Var_226].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_229].[Id] AS [Id], [Var_229].[Description] AS [Description], [Var_229].[SiteId] AS [SiteId], [Var_229].[IsDeleted] AS [IsDeleted], [Var_229].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_232].[Id] AS [Id], [Var_232].[Description] AS [Description], [Var_232].[SiteId] AS [SiteId], [Var_232].[IsDeleted] AS [IsDeleted], [Var_232].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_235].[Id] AS [Id], [Var_235].[Description] AS [Description], [Var_235].[SiteId] AS [SiteId], [Var_235].[IsDeleted] AS [IsDeleted], [Var_235].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_238].[Id] AS [Id], [Var_238].[Description] AS [Description], [Var_238].[SiteId] AS [SiteId], [Var_238].[IsDeleted] AS [IsDeleted], [Var_238].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_241].[Id] AS [Id], [Var_241].[Description] AS [Description], [Var_241].[SiteId] AS [SiteId], [Var_241].[IsDeleted] AS [IsDeleted], [Var_241].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_244].[Id] AS [Id], [Var_244].[Description] AS [Description], [Var_244].[SiteId] AS [SiteId], [Var_244].[IsDeleted] AS [IsDeleted], [Var_244].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_247].[Id] AS [Id], [Var_247].[Description] AS [Description], [Var_247].[SiteId] AS [SiteId], [Var_247].[IsDeleted] AS [IsDeleted], [Var_247].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_250].[Id] AS [Id], [Var_250].[Description] AS [Description], [Var_250].[SiteId] AS [SiteId], [Var_250].[IsDeleted] AS [IsDeleted], [Var_250].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_253].[Id] AS [Id], [Var_253].[Description] AS [Description], [Var_253].[SiteId] AS [SiteId], [Var_253].[IsDeleted] AS [IsDeleted], [Var_253].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_256].[Id] AS [Id], [Var_256].[Description] AS [Description], [Var_256].[SiteId] AS [SiteId], [Var_256].[IsDeleted] AS [IsDeleted], [Var_256].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_259].[Id] AS [Id], [Var_259].[Description] AS [Description], [Var_259].[SiteId] AS [SiteId], [Var_259].[IsDeleted] AS [IsDeleted], [Var_259].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_262].[Id] AS [Id], [Var_262].[Description] AS [Description], [Var_262].[SiteId] AS [SiteId], [Var_262].[IsDeleted] AS [IsDeleted], [Var_262].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_265].[Id] AS [Id], [Var_265].[Description] AS [Description], [Var_265].[SiteId] AS [SiteId], [Var_265].[IsDeleted] AS [IsDeleted], [Var_265].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_268].[Id] AS [Id], [Var_268].[Description] AS [Description], [Var_268].[SiteId] AS [SiteId], [Var_268].[IsDeleted] AS [IsDeleted], [Var_268].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_271].[Id] AS [Id], [Var_271].[Description] AS [Description], [Var_271].[SiteId] AS [SiteId], [Var_271].[IsDeleted] AS [IsDeleted], [Var_271].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_274].[Id] AS [Id], [Var_274].[Description] AS [Description], [Var_274].[SiteId] AS [SiteId], [Var_274].[IsDeleted] AS [IsDeleted], [Var_274].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_277].[Id] AS [Id], [Var_277].[Description] AS [Description], [Var_277].[SiteId] AS [SiteId], [Var_277].[IsDeleted] AS [IsDeleted], [Var_277].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_280].[Id] AS [Id], [Var_280].[Description] AS [Description], [Var_280].[SiteId] AS [SiteId], [Var_280].[IsDeleted] AS [IsDeleted], [Var_280].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_283].[Id] AS [Id], [Var_283].[Description] AS [Description], [Var_283].[SiteId] AS [SiteId], [Var_283].[IsDeleted] AS [IsDeleted], [Var_283].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_286].[Id] AS [Id], [Var_286].[Description] AS [Description], [Var_286].[SiteId] AS [SiteId], [Var_286].[IsDeleted] AS [IsDeleted], [Var_286].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_289].[Id] AS [Id], [Var_289].[Description] AS [Description], [Var_289].[SiteId] AS [SiteId], [Var_289].[IsDeleted] AS [IsDeleted], [Var_289].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_292].[Id] AS [Id], [Var_292].[Description] AS [Description], [Var_292].[SiteId] AS [SiteId], [Var_292].[IsDeleted] AS [IsDeleted], [Var_292].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_295].[Id] AS [Id], [Var_295].[Description] AS [Description], [Var_295].[SiteId] AS [SiteId], [Var_295].[IsDeleted] AS [IsDeleted], [Var_295].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_298].[Id] AS [Id], [Var_298].[Description] AS [Description], [Var_298].[SiteId] AS [SiteId], [Var_298].[IsDeleted] AS [IsDeleted], [Var_298].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_301].[Id] AS [Id], [Var_301].[Description] AS [Description], [Var_301].[SiteId] AS [SiteId], [Var_301].[IsDeleted] AS [IsDeleted], [Var_301].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_304].[Id] AS [Id], [Var_304].[Description] AS [Description], [Var_304].[SiteId] AS [SiteId], [Var_304].[IsDeleted] AS [IsDeleted], [Var_304].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_307].[Id] AS [Id], [Var_307].[Description] AS [Description], [Var_307].[SiteId] AS [SiteId], [Var_307].[IsDeleted] AS [IsDeleted], [Var_307].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_310].[Id] AS [Id], [Var_310].[Description] AS [Description], [Var_310].[SiteId] AS [SiteId], [Var_310].[IsDeleted] AS [IsDeleted], [Var_310].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_313].[Id] AS [Id], [Var_313].[Description] AS [Description], [Var_313].[SiteId] AS [SiteId], [Var_313].[IsDeleted] AS [IsDeleted], [Var_313].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_316].[Id] AS [Id], [Var_316].[Description] AS [Description], [Var_316].[SiteId] AS [SiteId], [Var_316].[IsDeleted] AS [IsDeleted], [Var_316].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_319].[Id] AS [Id], [Var_319].[Description] AS [Description], [Var_319].[SiteId] AS [SiteId], [Var_319].[IsDeleted] AS [IsDeleted], [Var_319].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_322].[Id] AS [Id], [Var_322].[Description] AS [Description], [Var_322].[SiteId] AS [SiteId], [Var_322].[IsDeleted] AS [IsDeleted], [Var_322].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_325].[Id] AS [Id], [Var_325].[Description] AS [Description], [Var_325].[SiteId] AS [SiteId], [Var_325].[IsDeleted] AS [IsDeleted], [Var_325].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_328].[Id] AS [Id], [Var_328].[Description] AS [Description], [Var_328].[SiteId] AS [SiteId], [Var_328].[IsDeleted] AS [IsDeleted], [Var_328].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_331].[Id] AS [Id], [Var_331].[Description] AS [Description], [Var_331].[SiteId] AS [SiteId], [Var_331].[IsDeleted] AS [IsDeleted], [Var_331].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_334].[Id] AS [Id], [Var_334].[Description] AS [Description], [Var_334].[SiteId] AS [SiteId], [Var_334].[IsDeleted] AS [IsDeleted], [Var_334].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_337].[Id] AS [Id], [Var_337].[Description] AS [Description], [Var_337].[SiteId] AS [SiteId], [Var_337].[IsDeleted] AS [IsDeleted], [Var_337].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_340].[Id] AS [Id], [Var_340].[Description] AS [Description], [Var_340].[SiteId] AS [SiteId], [Var_340].[IsDeleted] AS [IsDeleted], [Var_340].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_343].[Id] AS [Id], [Var_343].[Description] AS [Description], [Var_343].[SiteId] AS [SiteId], [Var_343].[IsDeleted] AS [IsDeleted], [Var_343].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_346].[Id] AS [Id], [Var_346].[Description] AS [Description], [Var_346].[SiteId] AS [SiteId], [Var_346].[IsDeleted] AS [IsDeleted], [Var_346].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM [dbo].[SwRoles] AS [Var_346] | |
| WHERE [Var_346].[IsDeleted] <> 1 | |
| ) AS [Var_343] | |
| WHERE [Var_343].[IsDeleted] <> 1 | |
| ) AS [Var_340] | |
| WHERE [Var_340].[IsDeleted] <> 1 | |
| ) AS [Var_337] | |
| WHERE [Var_337].[IsDeleted] <> 1 | |
| ) AS [Var_334] | |
| WHERE [Var_334].[IsDeleted] <> 1 | |
| ) AS [Var_331] | |
| WHERE [Var_331].[IsDeleted] <> 1 | |
| ) AS [Var_328] | |
| WHERE [Var_328].[IsDeleted] <> 1 | |
| ) AS [Var_325] | |
| WHERE [Var_325].[IsDeleted] <> 1 | |
| ) AS [Var_322] | |
| WHERE [Var_322].[IsDeleted] <> 1 | |
| ) AS [Var_319] | |
| WHERE [Var_319].[IsDeleted] <> 1 | |
| ) AS [Var_316] | |
| WHERE [Var_316].[IsDeleted] <> 1 | |
| ) AS [Var_313] | |
| WHERE [Var_313].[IsDeleted] <> 1 | |
| ) AS [Var_310] | |
| WHERE [Var_310].[IsDeleted] <> 1 | |
| ) AS [Var_307] | |
| WHERE [Var_307].[IsDeleted] <> 1 | |
| ) AS [Var_304] | |
| WHERE [Var_304].[IsDeleted] <> 1 | |
| ) AS [Var_301] | |
| WHERE [Var_301].[IsDeleted] <> 1 | |
| ) AS [Var_298] | |
| WHERE [Var_298].[IsDeleted] <> 1 | |
| ) AS [Var_295] | |
| WHERE [Var_295].[IsDeleted] <> 1 | |
| ) AS [Var_292] | |
| WHERE [Var_292].[IsDeleted] <> 1 | |
| ) AS [Var_289] | |
| WHERE [Var_289].[IsDeleted] <> 1 | |
| ) AS [Var_286] | |
| WHERE [Var_286].[IsDeleted] <> 1 | |
| ) AS [Var_283] | |
| WHERE [Var_283].[IsDeleted] <> 1 | |
| ) AS [Var_280] | |
| WHERE [Var_280].[IsDeleted] <> 1 | |
| ) AS [Var_277] | |
| WHERE [Var_277].[IsDeleted] <> 1 | |
| ) AS [Var_274] | |
| WHERE [Var_274].[IsDeleted] <> 1 | |
| ) AS [Var_271] | |
| WHERE [Var_271].[IsDeleted] <> 1 | |
| ) AS [Var_268] | |
| WHERE [Var_268].[IsDeleted] <> 1 | |
| ) AS [Var_265] | |
| WHERE [Var_265].[IsDeleted] <> 1 | |
| ) AS [Var_262] | |
| WHERE [Var_262].[IsDeleted] <> 1 | |
| ) AS [Var_259] | |
| WHERE [Var_259].[IsDeleted] <> 1 | |
| ) AS [Var_256] | |
| WHERE [Var_256].[IsDeleted] <> 1 | |
| ) AS [Var_253] | |
| WHERE [Var_253].[IsDeleted] <> 1 | |
| ) AS [Var_250] | |
| WHERE [Var_250].[IsDeleted] <> 1 | |
| ) AS [Var_247] | |
| WHERE [Var_247].[IsDeleted] <> 1 | |
| ) AS [Var_244] | |
| WHERE [Var_244].[IsDeleted] <> 1 | |
| ) AS [Var_241] | |
| WHERE [Var_241].[IsDeleted] <> 1 | |
| ) AS [Var_238] | |
| WHERE [Var_238].[IsDeleted] <> 1 | |
| ) AS [Var_235] | |
| WHERE [Var_235].[IsDeleted] <> 1 | |
| ) AS [Var_232] | |
| WHERE [Var_232].[IsDeleted] <> 1 | |
| ) AS [Var_229] | |
| WHERE [Var_229].[IsDeleted] <> 1 | |
| ) AS [Var_226] | |
| WHERE [Var_226].[IsDeleted] <> 1 | |
| ) AS [Var_223] | |
| WHERE [Var_223].[IsDeleted] <> 1 | |
| ) AS [Var_220] | |
| WHERE [Var_220].[IsDeleted] <> 1 | |
| ) AS [Var_217] | |
| WHERE [Var_217].[IsDeleted] <> 1 | |
| ) AS [Var_214] | |
| WHERE [Var_214].[IsDeleted] <> 1 | |
| ) AS [Var_211] | |
| WHERE [Var_211].[IsDeleted] <> 1 | |
| ) AS [Var_208] | |
| WHERE [Var_208].[IsDeleted] <> 1 | |
| ) AS [Var_205] | |
| WHERE [Var_205].[IsDeleted] <> 1 | |
| ) AS [Var_202] | |
| WHERE [Var_202].[IsDeleted] <> 1 | |
| ) AS [Var_199] | |
| WHERE [Var_199].[IsDeleted] <> 1 ) AS [Extent3] ON [Extent2].[SwRole_Id] = [Extent3].[Id] | |
| LEFT OUTER JOIN (SELECT [Extent4].[Id] AS [Id2], [Extent4].[RoleId] AS [RoleId], [Extent4].[ActionId] AS [ActionId], [Extent4].[Allowed] AS [Allowed], [Extent4].[IsDeleted] AS [IsDeleted2], [Extent4].[DeletedTimeStamp] AS [DeletedTimeStamp2], [Extent5].[Id] AS [Id3], [Extent5].[Type] AS [Type], [Extent5].[Description] AS [Description2], [Extent5].[IsDeleted] AS [IsDeleted3], [Extent5].[DeletedTimeStamp] AS [DeletedTimeStamp3] | |
| FROM (SELECT [Var_200].[Id] AS [Id], [Var_200].[RoleId] AS [RoleId], [Var_200].[ActionId] AS [ActionId], [Var_200].[Allowed] AS [Allowed], [Var_200].[IsDeleted] AS [IsDeleted], [Var_200].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_203].[Id] AS [Id], [Var_203].[RoleId] AS [RoleId], [Var_203].[ActionId] AS [ActionId], [Var_203].[Allowed] AS [Allowed], [Var_203].[IsDeleted] AS [IsDeleted], [Var_203].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_206].[Id] AS [Id], [Var_206].[RoleId] AS [RoleId], [Var_206].[ActionId] AS [ActionId], [Var_206].[Allowed] AS [Allowed], [Var_206].[IsDeleted] AS [IsDeleted], [Var_206].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_209].[Id] AS [Id], [Var_209].[RoleId] AS [RoleId], [Var_209].[ActionId] AS [ActionId], [Var_209].[Allowed] AS [Allowed], [Var_209].[IsDeleted] AS [IsDeleted], [Var_209].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_212].[Id] AS [Id], [Var_212].[RoleId] AS [RoleId], [Var_212].[ActionId] AS [ActionId], [Var_212].[Allowed] AS [Allowed], [Var_212].[IsDeleted] AS [IsDeleted], [Var_212].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_215].[Id] AS [Id], [Var_215].[RoleId] AS [RoleId], [Var_215].[ActionId] AS [ActionId], [Var_215].[Allowed] AS [Allowed], [Var_215].[IsDeleted] AS [IsDeleted], [Var_215].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_218].[Id] AS [Id], [Var_218].[RoleId] AS [RoleId], [Var_218].[ActionId] AS [ActionId], [Var_218].[Allowed] AS [Allowed], [Var_218].[IsDeleted] AS [IsDeleted], [Var_218].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_221].[Id] AS [Id], [Var_221].[RoleId] AS [RoleId], [Var_221].[ActionId] AS [ActionId], [Var_221].[Allowed] AS [Allowed], [Var_221].[IsDeleted] AS [IsDeleted], [Var_221].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_224].[Id] AS [Id], [Var_224].[RoleId] AS [RoleId], [Var_224].[ActionId] AS [ActionId], [Var_224].[Allowed] AS [Allowed], [Var_224].[IsDeleted] AS [IsDeleted], [Var_224].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_227].[Id] AS [Id], [Var_227].[RoleId] AS [RoleId], [Var_227].[ActionId] AS [ActionId], [Var_227].[Allowed] AS [Allowed], [Var_227].[IsDeleted] AS [IsDeleted], [Var_227].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_230].[Id] AS [Id], [Var_230].[RoleId] AS [RoleId], [Var_230].[ActionId] AS [ActionId], [Var_230].[Allowed] AS [Allowed], [Var_230].[IsDeleted] AS [IsDeleted], [Var_230].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_233].[Id] AS [Id], [Var_233].[RoleId] AS [RoleId], [Var_233].[ActionId] AS [ActionId], [Var_233].[Allowed] AS [Allowed], [Var_233].[IsDeleted] AS [IsDeleted], [Var_233].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_236].[Id] AS [Id], [Var_236].[RoleId] AS [RoleId], [Var_236].[ActionId] AS [ActionId], [Var_236].[Allowed] AS [Allowed], [Var_236].[IsDeleted] AS [IsDeleted], [Var_236].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_239].[Id] AS [Id], [Var_239].[RoleId] AS [RoleId], [Var_239].[ActionId] AS [ActionId], [Var_239].[Allowed] AS [Allowed], [Var_239].[IsDeleted] AS [IsDeleted], [Var_239].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_242].[Id] AS [Id], [Var_242].[RoleId] AS [RoleId], [Var_242].[ActionId] AS [ActionId], [Var_242].[Allowed] AS [Allowed], [Var_242].[IsDeleted] AS [IsDeleted], [Var_242].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_245].[Id] AS [Id], [Var_245].[RoleId] AS [RoleId], [Var_245].[ActionId] AS [ActionId], [Var_245].[Allowed] AS [Allowed], [Var_245].[IsDeleted] AS [IsDeleted], [Var_245].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_248].[Id] AS [Id], [Var_248].[RoleId] AS [RoleId], [Var_248].[ActionId] AS [ActionId], [Var_248].[Allowed] AS [Allowed], [Var_248].[IsDeleted] AS [IsDeleted], [Var_248].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_251].[Id] AS [Id], [Var_251].[RoleId] AS [RoleId], [Var_251].[ActionId] AS [ActionId], [Var_251].[Allowed] AS [Allowed], [Var_251].[IsDeleted] AS [IsDeleted], [Var_251].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_254].[Id] AS [Id], [Var_254].[RoleId] AS [RoleId], [Var_254].[ActionId] AS [ActionId], [Var_254].[Allowed] AS [Allowed], [Var_254].[IsDeleted] AS [IsDeleted], [Var_254].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_257].[Id] AS [Id], [Var_257].[RoleId] AS [RoleId], [Var_257].[ActionId] AS [ActionId], [Var_257].[Allowed] AS [Allowed], [Var_257].[IsDeleted] AS [IsDeleted], [Var_257].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_260].[Id] AS [Id], [Var_260].[RoleId] AS [RoleId], [Var_260].[ActionId] AS [ActionId], [Var_260].[Allowed] AS [Allowed], [Var_260].[IsDeleted] AS [IsDeleted], [Var_260].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_263].[Id] AS [Id], [Var_263].[RoleId] AS [RoleId], [Var_263].[ActionId] AS [ActionId], [Var_263].[Allowed] AS [Allowed], [Var_263].[IsDeleted] AS [IsDeleted], [Var_263].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_266].[Id] AS [Id], [Var_266].[RoleId] AS [RoleId], [Var_266].[ActionId] AS [ActionId], [Var_266].[Allowed] AS [Allowed], [Var_266].[IsDeleted] AS [IsDeleted], [Var_266].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_269].[Id] AS [Id], [Var_269].[RoleId] AS [RoleId], [Var_269].[ActionId] AS [ActionId], [Var_269].[Allowed] AS [Allowed], [Var_269].[IsDeleted] AS [IsDeleted], [Var_269].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_272].[Id] AS [Id], [Var_272].[RoleId] AS [RoleId], [Var_272].[ActionId] AS [ActionId], [Var_272].[Allowed] AS [Allowed], [Var_272].[IsDeleted] AS [IsDeleted], [Var_272].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_275].[Id] AS [Id], [Var_275].[RoleId] AS [RoleId], [Var_275].[ActionId] AS [ActionId], [Var_275].[Allowed] AS [Allowed], [Var_275].[IsDeleted] AS [IsDeleted], [Var_275].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_278].[Id] AS [Id], [Var_278].[RoleId] AS [RoleId], [Var_278].[ActionId] AS [ActionId], [Var_278].[Allowed] AS [Allowed], [Var_278].[IsDeleted] AS [IsDeleted], [Var_278].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_281].[Id] AS [Id], [Var_281].[RoleId] AS [RoleId], [Var_281].[ActionId] AS [ActionId], [Var_281].[Allowed] AS [Allowed], [Var_281].[IsDeleted] AS [IsDeleted], [Var_281].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_284].[Id] AS [Id], [Var_284].[RoleId] AS [RoleId], [Var_284].[ActionId] AS [ActionId], [Var_284].[Allowed] AS [Allowed], [Var_284].[IsDeleted] AS [IsDeleted], [Var_284].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_287].[Id] AS [Id], [Var_287].[RoleId] AS [RoleId], [Var_287].[ActionId] AS [ActionId], [Var_287].[Allowed] AS [Allowed], [Var_287].[IsDeleted] AS [IsDeleted], [Var_287].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_290].[Id] AS [Id], [Var_290].[RoleId] AS [RoleId], [Var_290].[ActionId] AS [ActionId], [Var_290].[Allowed] AS [Allowed], [Var_290].[IsDeleted] AS [IsDeleted], [Var_290].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_293].[Id] AS [Id], [Var_293].[RoleId] AS [RoleId], [Var_293].[ActionId] AS [ActionId], [Var_293].[Allowed] AS [Allowed], [Var_293].[IsDeleted] AS [IsDeleted], [Var_293].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_296].[Id] AS [Id], [Var_296].[RoleId] AS [RoleId], [Var_296].[ActionId] AS [ActionId], [Var_296].[Allowed] AS [Allowed], [Var_296].[IsDeleted] AS [IsDeleted], [Var_296].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_299].[Id] AS [Id], [Var_299].[RoleId] AS [RoleId], [Var_299].[ActionId] AS [ActionId], [Var_299].[Allowed] AS [Allowed], [Var_299].[IsDeleted] AS [IsDeleted], [Var_299].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_302].[Id] AS [Id], [Var_302].[RoleId] AS [RoleId], [Var_302].[ActionId] AS [ActionId], [Var_302].[Allowed] AS [Allowed], [Var_302].[IsDeleted] AS [IsDeleted], [Var_302].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_305].[Id] AS [Id], [Var_305].[RoleId] AS [RoleId], [Var_305].[ActionId] AS [ActionId], [Var_305].[Allowed] AS [Allowed], [Var_305].[IsDeleted] AS [IsDeleted], [Var_305].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_308].[Id] AS [Id], [Var_308].[RoleId] AS [RoleId], [Var_308].[ActionId] AS [ActionId], [Var_308].[Allowed] AS [Allowed], [Var_308].[IsDeleted] AS [IsDeleted], [Var_308].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_311].[Id] AS [Id], [Var_311].[RoleId] AS [RoleId], [Var_311].[ActionId] AS [ActionId], [Var_311].[Allowed] AS [Allowed], [Var_311].[IsDeleted] AS [IsDeleted], [Var_311].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_314].[Id] AS [Id], [Var_314].[RoleId] AS [RoleId], [Var_314].[ActionId] AS [ActionId], [Var_314].[Allowed] AS [Allowed], [Var_314].[IsDeleted] AS [IsDeleted], [Var_314].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_317].[Id] AS [Id], [Var_317].[RoleId] AS [RoleId], [Var_317].[ActionId] AS [ActionId], [Var_317].[Allowed] AS [Allowed], [Var_317].[IsDeleted] AS [IsDeleted], [Var_317].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_320].[Id] AS [Id], [Var_320].[RoleId] AS [RoleId], [Var_320].[ActionId] AS [ActionId], [Var_320].[Allowed] AS [Allowed], [Var_320].[IsDeleted] AS [IsDeleted], [Var_320].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_323].[Id] AS [Id], [Var_323].[RoleId] AS [RoleId], [Var_323].[ActionId] AS [ActionId], [Var_323].[Allowed] AS [Allowed], [Var_323].[IsDeleted] AS [IsDeleted], [Var_323].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_326].[Id] AS [Id], [Var_326].[RoleId] AS [RoleId], [Var_326].[ActionId] AS [ActionId], [Var_326].[Allowed] AS [Allowed], [Var_326].[IsDeleted] AS [IsDeleted], [Var_326].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_329].[Id] AS [Id], [Var_329].[RoleId] AS [RoleId], [Var_329].[ActionId] AS [ActionId], [Var_329].[Allowed] AS [Allowed], [Var_329].[IsDeleted] AS [IsDeleted], [Var_329].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_332].[Id] AS [Id], [Var_332].[RoleId] AS [RoleId], [Var_332].[ActionId] AS [ActionId], [Var_332].[Allowed] AS [Allowed], [Var_332].[IsDeleted] AS [IsDeleted], [Var_332].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_335].[Id] AS [Id], [Var_335].[RoleId] AS [RoleId], [Var_335].[ActionId] AS [ActionId], [Var_335].[Allowed] AS [Allowed], [Var_335].[IsDeleted] AS [IsDeleted], [Var_335].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_338].[Id] AS [Id], [Var_338].[RoleId] AS [RoleId], [Var_338].[ActionId] AS [ActionId], [Var_338].[Allowed] AS [Allowed], [Var_338].[IsDeleted] AS [IsDeleted], [Var_338].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_341].[Id] AS [Id], [Var_341].[RoleId] AS [RoleId], [Var_341].[ActionId] AS [ActionId], [Var_341].[Allowed] AS [Allowed], [Var_341].[IsDeleted] AS [IsDeleted], [Var_341].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_344].[Id] AS [Id], [Var_344].[RoleId] AS [RoleId], [Var_344].[ActionId] AS [ActionId], [Var_344].[Allowed] AS [Allowed], [Var_344].[IsDeleted] AS [IsDeleted], [Var_344].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_347].[Id] AS [Id], [Var_347].[RoleId] AS [RoleId], [Var_347].[ActionId] AS [ActionId], [Var_347].[Allowed] AS [Allowed], [Var_347].[IsDeleted] AS [IsDeleted], [Var_347].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM [dbo].[RoleActions] AS [Var_347] | |
| WHERE [Var_347].[IsDeleted] <> 1 | |
| ) AS [Var_344] | |
| WHERE [Var_344].[IsDeleted] <> 1 | |
| ) AS [Var_341] | |
| WHERE [Var_341].[IsDeleted] <> 1 | |
| ) AS [Var_338] | |
| WHERE [Var_338].[IsDeleted] <> 1 | |
| ) AS [Var_335] | |
| WHERE [Var_335].[IsDeleted] <> 1 | |
| ) AS [Var_332] | |
| WHERE [Var_332].[IsDeleted] <> 1 | |
| ) AS [Var_329] | |
| WHERE [Var_329].[IsDeleted] <> 1 | |
| ) AS [Var_326] | |
| WHERE [Var_326].[IsDeleted] <> 1 | |
| ) AS [Var_323] | |
| WHERE [Var_323].[IsDeleted] <> 1 | |
| ) AS [Var_320] | |
| WHERE [Var_320].[IsDeleted] <> 1 | |
| ) AS [Var_317] | |
| WHERE [Var_317].[IsDeleted] <> 1 | |
| ) AS [Var_314] | |
| WHERE [Var_314].[IsDeleted] <> 1 | |
| ) AS [Var_311] | |
| WHERE [Var_311].[IsDeleted] <> 1 | |
| ) AS [Var_308] | |
| WHERE [Var_308].[IsDeleted] <> 1 | |
| ) AS [Var_305] | |
| WHERE [Var_305].[IsDeleted] <> 1 | |
| ) AS [Var_302] | |
| WHERE [Var_302].[IsDeleted] <> 1 | |
| ) AS [Var_299] | |
| WHERE [Var_299].[IsDeleted] <> 1 | |
| ) AS [Var_296] | |
| WHERE [Var_296].[IsDeleted] <> 1 | |
| ) AS [Var_293] | |
| WHERE [Var_293].[IsDeleted] <> 1 | |
| ) AS [Var_290] | |
| WHERE [Var_290].[IsDeleted] <> 1 | |
| ) AS [Var_287] | |
| WHERE [Var_287].[IsDeleted] <> 1 | |
| ) AS [Var_284] | |
| WHERE [Var_284].[IsDeleted] <> 1 | |
| ) AS [Var_281] | |
| WHERE [Var_281].[IsDeleted] <> 1 | |
| ) AS [Var_278] | |
| WHERE [Var_278].[IsDeleted] <> 1 | |
| ) AS [Var_275] | |
| WHERE [Var_275].[IsDeleted] <> 1 | |
| ) AS [Var_272] | |
| WHERE [Var_272].[IsDeleted] <> 1 | |
| ) AS [Var_269] | |
| WHERE [Var_269].[IsDeleted] <> 1 | |
| ) AS [Var_266] | |
| WHERE [Var_266].[IsDeleted] <> 1 | |
| ) AS [Var_263] | |
| WHERE [Var_263].[IsDeleted] <> 1 | |
| ) AS [Var_260] | |
| WHERE [Var_260].[IsDeleted] <> 1 | |
| ) AS [Var_257] | |
| WHERE [Var_257].[IsDeleted] <> 1 | |
| ) AS [Var_254] | |
| WHERE [Var_254].[IsDeleted] <> 1 | |
| ) AS [Var_251] | |
| WHERE [Var_251].[IsDeleted] <> 1 | |
| ) AS [Var_248] | |
| WHERE [Var_248].[IsDeleted] <> 1 | |
| ) AS [Var_245] | |
| WHERE [Var_245].[IsDeleted] <> 1 | |
| ) AS [Var_242] | |
| WHERE [Var_242].[IsDeleted] <> 1 | |
| ) AS [Var_239] | |
| WHERE [Var_239].[IsDeleted] <> 1 | |
| ) AS [Var_236] | |
| WHERE [Var_236].[IsDeleted] <> 1 | |
| ) AS [Var_233] | |
| WHERE [Var_233].[IsDeleted] <> 1 | |
| ) AS [Var_230] | |
| WHERE [Var_230].[IsDeleted] <> 1 | |
| ) AS [Var_227] | |
| WHERE [Var_227].[IsDeleted] <> 1 | |
| ) AS [Var_224] | |
| WHERE [Var_224].[IsDeleted] <> 1 | |
| ) AS [Var_221] | |
| WHERE [Var_221].[IsDeleted] <> 1 | |
| ) AS [Var_218] | |
| WHERE [Var_218].[IsDeleted] <> 1 | |
| ) AS [Var_215] | |
| WHERE [Var_215].[IsDeleted] <> 1 | |
| ) AS [Var_212] | |
| WHERE [Var_212].[IsDeleted] <> 1 | |
| ) AS [Var_209] | |
| WHERE [Var_209].[IsDeleted] <> 1 | |
| ) AS [Var_206] | |
| WHERE [Var_206].[IsDeleted] <> 1 | |
| ) AS [Var_203] | |
| WHERE [Var_203].[IsDeleted] <> 1 | |
| ) AS [Var_200] | |
| WHERE [Var_200].[IsDeleted] <> 1 ) AS [Extent4] | |
| INNER JOIN (SELECT [Var_201].[Id] AS [Id], [Var_201].[Type] AS [Type], [Var_201].[Description] AS [Description], [Var_201].[IsDeleted] AS [IsDeleted], [Var_201].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_204].[Id] AS [Id], [Var_204].[Type] AS [Type], [Var_204].[Description] AS [Description], [Var_204].[IsDeleted] AS [IsDeleted], [Var_204].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_207].[Id] AS [Id], [Var_207].[Type] AS [Type], [Var_207].[Description] AS [Description], [Var_207].[IsDeleted] AS [IsDeleted], [Var_207].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_210].[Id] AS [Id], [Var_210].[Type] AS [Type], [Var_210].[Description] AS [Description], [Var_210].[IsDeleted] AS [IsDeleted], [Var_210].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_213].[Id] AS [Id], [Var_213].[Type] AS [Type], [Var_213].[Description] AS [Description], [Var_213].[IsDeleted] AS [IsDeleted], [Var_213].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_216].[Id] AS [Id], [Var_216].[Type] AS [Type], [Var_216].[Description] AS [Description], [Var_216].[IsDeleted] AS [IsDeleted], [Var_216].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_219].[Id] AS [Id], [Var_219].[Type] AS [Type], [Var_219].[Description] AS [Description], [Var_219].[IsDeleted] AS [IsDeleted], [Var_219].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_222].[Id] AS [Id], [Var_222].[Type] AS [Type], [Var_222].[Description] AS [Description], [Var_222].[IsDeleted] AS [IsDeleted], [Var_222].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_225].[Id] AS [Id], [Var_225].[Type] AS [Type], [Var_225].[Description] AS [Description], [Var_225].[IsDeleted] AS [IsDeleted], [Var_225].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_228].[Id] AS [Id], [Var_228].[Type] AS [Type], [Var_228].[Description] AS [Description], [Var_228].[IsDeleted] AS [IsDeleted], [Var_228].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_231].[Id] AS [Id], [Var_231].[Type] AS [Type], [Var_231].[Description] AS [Description], [Var_231].[IsDeleted] AS [IsDeleted], [Var_231].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_234].[Id] AS [Id], [Var_234].[Type] AS [Type], [Var_234].[Description] AS [Description], [Var_234].[IsDeleted] AS [IsDeleted], [Var_234].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_237].[Id] AS [Id], [Var_237].[Type] AS [Type], [Var_237].[Description] AS [Description], [Var_237].[IsDeleted] AS [IsDeleted], [Var_237].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_240].[Id] AS [Id], [Var_240].[Type] AS [Type], [Var_240].[Description] AS [Description], [Var_240].[IsDeleted] AS [IsDeleted], [Var_240].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_243].[Id] AS [Id], [Var_243].[Type] AS [Type], [Var_243].[Description] AS [Description], [Var_243].[IsDeleted] AS [IsDeleted], [Var_243].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_246].[Id] AS [Id], [Var_246].[Type] AS [Type], [Var_246].[Description] AS [Description], [Var_246].[IsDeleted] AS [IsDeleted], [Var_246].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_249].[Id] AS [Id], [Var_249].[Type] AS [Type], [Var_249].[Description] AS [Description], [Var_249].[IsDeleted] AS [IsDeleted], [Var_249].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_252].[Id] AS [Id], [Var_252].[Type] AS [Type], [Var_252].[Description] AS [Description], [Var_252].[IsDeleted] AS [IsDeleted], [Var_252].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_255].[Id] AS [Id], [Var_255].[Type] AS [Type], [Var_255].[Description] AS [Description], [Var_255].[IsDeleted] AS [IsDeleted], [Var_255].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_258].[Id] AS [Id], [Var_258].[Type] AS [Type], [Var_258].[Description] AS [Description], [Var_258].[IsDeleted] AS [IsDeleted], [Var_258].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_261].[Id] AS [Id], [Var_261].[Type] AS [Type], [Var_261].[Description] AS [Description], [Var_261].[IsDeleted] AS [IsDeleted], [Var_261].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_264].[Id] AS [Id], [Var_264].[Type] AS [Type], [Var_264].[Description] AS [Description], [Var_264].[IsDeleted] AS [IsDeleted], [Var_264].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_267].[Id] AS [Id], [Var_267].[Type] AS [Type], [Var_267].[Description] AS [Description], [Var_267].[IsDeleted] AS [IsDeleted], [Var_267].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_270].[Id] AS [Id], [Var_270].[Type] AS [Type], [Var_270].[Description] AS [Description], [Var_270].[IsDeleted] AS [IsDeleted], [Var_270].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_273].[Id] AS [Id], [Var_273].[Type] AS [Type], [Var_273].[Description] AS [Description], [Var_273].[IsDeleted] AS [IsDeleted], [Var_273].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_276].[Id] AS [Id], [Var_276].[Type] AS [Type], [Var_276].[Description] AS [Description], [Var_276].[IsDeleted] AS [IsDeleted], [Var_276].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_279].[Id] AS [Id], [Var_279].[Type] AS [Type], [Var_279].[Description] AS [Description], [Var_279].[IsDeleted] AS [IsDeleted], [Var_279].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_282].[Id] AS [Id], [Var_282].[Type] AS [Type], [Var_282].[Description] AS [Description], [Var_282].[IsDeleted] AS [IsDeleted], [Var_282].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_285].[Id] AS [Id], [Var_285].[Type] AS [Type], [Var_285].[Description] AS [Description], [Var_285].[IsDeleted] AS [IsDeleted], [Var_285].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_288].[Id] AS [Id], [Var_288].[Type] AS [Type], [Var_288].[Description] AS [Description], [Var_288].[IsDeleted] AS [IsDeleted], [Var_288].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_291].[Id] AS [Id], [Var_291].[Type] AS [Type], [Var_291].[Description] AS [Description], [Var_291].[IsDeleted] AS [IsDeleted], [Var_291].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_294].[Id] AS [Id], [Var_294].[Type] AS [Type], [Var_294].[Description] AS [Description], [Var_294].[IsDeleted] AS [IsDeleted], [Var_294].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_297].[Id] AS [Id], [Var_297].[Type] AS [Type], [Var_297].[Description] AS [Description], [Var_297].[IsDeleted] AS [IsDeleted], [Var_297].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_300].[Id] AS [Id], [Var_300].[Type] AS [Type], [Var_300].[Description] AS [Description], [Var_300].[IsDeleted] AS [IsDeleted], [Var_300].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_303].[Id] AS [Id], [Var_303].[Type] AS [Type], [Var_303].[Description] AS [Description], [Var_303].[IsDeleted] AS [IsDeleted], [Var_303].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_306].[Id] AS [Id], [Var_306].[Type] AS [Type], [Var_306].[Description] AS [Description], [Var_306].[IsDeleted] AS [IsDeleted], [Var_306].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_309].[Id] AS [Id], [Var_309].[Type] AS [Type], [Var_309].[Description] AS [Description], [Var_309].[IsDeleted] AS [IsDeleted], [Var_309].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_312].[Id] AS [Id], [Var_312].[Type] AS [Type], [Var_312].[Description] AS [Description], [Var_312].[IsDeleted] AS [IsDeleted], [Var_312].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_315].[Id] AS [Id], [Var_315].[Type] AS [Type], [Var_315].[Description] AS [Description], [Var_315].[IsDeleted] AS [IsDeleted], [Var_315].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_318].[Id] AS [Id], [Var_318].[Type] AS [Type], [Var_318].[Description] AS [Description], [Var_318].[IsDeleted] AS [IsDeleted], [Var_318].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_321].[Id] AS [Id], [Var_321].[Type] AS [Type], [Var_321].[Description] AS [Description], [Var_321].[IsDeleted] AS [IsDeleted], [Var_321].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_324].[Id] AS [Id], [Var_324].[Type] AS [Type], [Var_324].[Description] AS [Description], [Var_324].[IsDeleted] AS [IsDeleted], [Var_324].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_327].[Id] AS [Id], [Var_327].[Type] AS [Type], [Var_327].[Description] AS [Description], [Var_327].[IsDeleted] AS [IsDeleted], [Var_327].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_330].[Id] AS [Id], [Var_330].[Type] AS [Type], [Var_330].[Description] AS [Description], [Var_330].[IsDeleted] AS [IsDeleted], [Var_330].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_333].[Id] AS [Id], [Var_333].[Type] AS [Type], [Var_333].[Description] AS [Description], [Var_333].[IsDeleted] AS [IsDeleted], [Var_333].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_336].[Id] AS [Id], [Var_336].[Type] AS [Type], [Var_336].[Description] AS [Description], [Var_336].[IsDeleted] AS [IsDeleted], [Var_336].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_339].[Id] AS [Id], [Var_339].[Type] AS [Type], [Var_339].[Description] AS [Description], [Var_339].[IsDeleted] AS [IsDeleted], [Var_339].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_342].[Id] AS [Id], [Var_342].[Type] AS [Type], [Var_342].[Description] AS [Description], [Var_342].[IsDeleted] AS [IsDeleted], [Var_342].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_345].[Id] AS [Id], [Var_345].[Type] AS [Type], [Var_345].[Description] AS [Description], [Var_345].[IsDeleted] AS [IsDeleted], [Var_345].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM ( SELECT [Var_348].[Id] AS [Id], [Var_348].[Type] AS [Type], [Var_348].[Description] AS [Description], [Var_348].[IsDeleted] AS [IsDeleted], [Var_348].[DeletedTimeStamp] AS [DeletedTimeStamp] | |
| FROM [dbo].[SwActions] AS [Var_348] | |
| WHERE [Var_348].[IsDeleted] <> 1 | |
| ) AS [Var_345] | |
| WHERE [Var_345].[IsDeleted] <> 1 | |
| ) AS [Var_342] | |
| WHERE [Var_342].[IsDeleted] <> 1 | |
| ) AS [Var_339] | |
| WHERE [Var_339].[IsDeleted] <> 1 | |
| ) AS [Var_336] | |
| WHERE [Var_336].[IsDeleted] <> 1 | |
| ) AS [Var_333] | |
| WHERE [Var_333].[IsDeleted] <> 1 | |
| ) AS [Var_330] | |
| WHERE [Var_330].[IsDeleted] <> 1 | |
| ) AS [Var_327] | |
| WHERE [Var_327].[IsDeleted] <> 1 | |
| ) AS [Var_324] | |
| WHERE [Var_324].[IsDeleted] <> 1 | |
| ) AS [Var_321] | |
| WHERE [Var_321].[IsDeleted] <> 1 | |
| ) AS [Var_318] | |
| WHERE [Var_318].[IsDeleted] <> 1 | |
| ) AS [Var_315] | |
| WHERE [Var_315].[IsDeleted] <> 1 | |
| ) AS [Var_312] | |
| WHERE [Var_312].[IsDeleted] <> 1 | |
| ) AS [Var_309] | |
| WHERE [Var_309].[IsDeleted] <> 1 | |
| ) AS [Var_306] | |
| WHERE [Var_306].[IsDeleted] <> 1 | |
| ) AS [Var_303] | |
| WHERE [Var_303].[IsDeleted] <> 1 | |
| ) AS [Var_300] | |
| WHERE [Var_300].[IsDeleted] <> 1 | |
| ) AS [Var_297] | |
| WHERE [Var_297].[IsDeleted] <> 1 | |
| ) AS [Var_294] | |
| WHERE [Var_294].[IsDeleted] <> 1 | |
| ) AS [Var_291] | |
| WHERE [Var_291].[IsDeleted] <> 1 | |
| ) AS [Var_288] | |
| WHERE [Var_288].[IsDeleted] <> 1 | |
| ) AS [Var_285] | |
| WHERE [Var_285].[IsDeleted] <> 1 | |
| ) AS [Var_282] | |
| WHERE [Var_282].[IsDeleted] <> 1 | |
| ) AS [Var_279] | |
| WHERE [Var_279].[IsDeleted] <> 1 | |
| ) AS [Var_276] | |
| WHERE [Var_276].[IsDeleted] <> 1 | |
| ) AS [Var_273] | |
| WHERE [Var_273].[IsDeleted] <> 1 | |
| ) AS [Var_270] | |
| WHERE [Var_270].[IsDeleted] <> 1 | |
| ) AS [Var_267] | |
| WHERE [Var_267].[IsDeleted] <> 1 | |
| ) AS [Var_264] | |
| WHERE [Var_264].[IsDeleted] <> 1 | |
| ) AS [Var_261] | |
| WHERE [Var_261].[IsDeleted] <> 1 | |
| ) AS [Var_258] | |
| WHERE [Var_258].[IsDeleted] <> 1 | |
| ) AS [Var_255] | |
| WHERE [Var_255].[IsDeleted] <> 1 | |
| ) AS [Var_252] | |
| WHERE [Var_252].[IsDeleted] <> 1 | |
| ) AS [Var_249] | |
| WHERE [Var_249].[IsDeleted] <> 1 | |
| ) AS [Var_246] | |
| WHERE [Var_246].[IsDeleted] <> 1 | |
| ) AS [Var_243] | |
| WHERE [Var_243].[IsDeleted] <> 1 | |
| ) AS [Var_240] | |
| WHERE [Var_240].[IsDeleted] <> 1 | |
| ) AS [Var_237] | |
| WHERE [Var_237].[IsDeleted] <> 1 | |
| ) AS [Var_234] | |
| WHERE [Var_234].[IsDeleted] <> 1 | |
| ) AS [Var_231] | |
| WHERE [Var_231].[IsDeleted] <> 1 | |
| ) AS [Var_228] | |
| WHERE [Var_228].[IsDeleted] <> 1 | |
| ) AS [Var_225] | |
| WHERE [Var_225].[IsDeleted] <> 1 | |
| ) AS [Var_222] | |
| WHERE [Var_222].[IsDeleted] <> 1 | |
| ) AS [Var_219] | |
| WHERE [Var_219].[IsDeleted] <> 1 | |
| ) AS [Var_216] | |
| WHERE [Var_216].[IsDeleted] <> 1 | |
| ) AS [Var_213] | |
| WHERE [Var_213].[IsDeleted] <> 1 | |
| ) AS [Var_210] | |
| WHERE [Var_210].[IsDeleted] <> 1 | |
| ) AS [Var_207] | |
| WHERE [Var_207].[IsDeleted] <> 1 | |
| ) AS [Var_204] | |
| WHERE [Var_204].[IsDeleted] <> 1 | |
| ) AS [Var_201] | |
| WHERE [Var_201].[IsDeleted] <> 1 ) AS [Extent5] ON [Extent4].[ActionId] = [Extent5].[Id] ) AS [Join2] ON [Extent3].[Id] = [Join2].[RoleId] ) AS [Join3] ON [Limit1].[Id] = [Join3].[User_Id] | |
| ) AS [Project2] | |
| ORDER BY [Project2].[Id] ASC, [Project2].[C2] ASC, [Project2].[SwRole_Id] ASC, [Project2].[User_Id] ASC, [Project2].[Id1] ASC, [Project2].[C1] ASC | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment