Duration |
SQL |
31ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__Code_1='?' (Size = 40...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__Code_1='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[AdvantageID], [t].[BackgroundImageIconPath], [t].[BackgroundURL], [t].[BorderStyle], [t].[ButtonBackgroundColor], [t].[ButtonBackgroundPath], [t].[ButtonStyle], [t].[ButtonText], [t].[Code], [t].[ContentCount], [t].[ContentDisplayTypeID], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[ImagePath], [t].[MobileImagePath], [t].[PageID], [t].[PageUrlID], [t].[ParticlesJson], [t].[PublishDate], [t].[SecondaryCode], [t].[SeoTitle], [t].[ShowWhenLogin], [t].[ShowWhenNotLogin], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[SubtitleStyle], [t].[Title], [t].[TitleStyle], [t].[URL], [t].[UnPublishDate], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewTypeID], [t].[ID0], [t].[ID1], [t].[ID2], [w0].[ID], [w0].[ButtonText], [w0].[DateCreated], [w0].[DateModified], [w0].[Description], [w0].[LanguageID], [w0].[StatusID], [w0].[SubTitle], [w0].[Title], [w0].[URL], [w0].[UserCreatedID], [w0].[UserModifiedID], [w0].[WidgetID], [t0].[ID], [t0].[AdvantageID], [t0].[BackgroundColor], [t0].[BackgroundImageIconPath], [t0].[BackgroundPath], [t0].[BorderColor], [t0].[Code], [t0].[ContentID], [t0].[DateCreated], [t0].[DateModified], [t0].[FontColor], [t0].[HeadlineID], [t0].[HeadlineItemID], [t0].[HoverColor], [t0].[HoverDescription], [t0].[IconName], [t0].[SortOrder], [t0].[StatusID], [t0].[Text], [t0].[Title], [t0].[URL], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WidgetContentID], [t0].[WidgetID], [t0].[ID0], [t0].[ButtonID], [t0].[DateCreated0], [t0].[DateModified0], [t0].[HoverDescription0], [t0].[LanguageID], [t0].[StatusID0], [t0].[Title0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t1].[ID], [t1].[BackgroundColor], [t1].[Code], [t1].[DateCreated], [t1].[DateModified], [t1].[Description], [t1].[FaqQuestionID], [t1].[HoverImagePath], [t1].[IconName], [t1].[IconPath], [t1].[ImagePath], [t1].[PublishDate], [t1].[SeoTitle], [t1].[SortOrder], [t1].[StatusID], [t1].[SubTitle], [t1].[Title], [t1].[TitleStyle], [t1].[URL], [t1].[UnPublishDate], [t1].[UserCreatedID], [t1].[UserModifiedID], [t1].[VideoPath], [t1].[VoicePath], [t1].[WidgetID], [t1].[ID0], [t1].[DateCreated0], [t1].[DateModified0], [t1].[Description0], [t1].[LanguageID], [t1].[StatusID0], [t1].[SubTitle0], [t1].[Title0], [t1].[URL0], [t1].[UserCreatedID0], [t1].[UserModifiedID0], [t1].[WidgetContentID], [t2].[ID], [t2].[DateCreated], [t2].[DateModified], [t2].[ProductCategoryID], [t2].[StatusID], [t2].[UserCreatedID], [t2].[UserModifiedID], [t2].[WidgetID], [t2].[ID0], [t2].[ButtonText], [t2].[Code], [t2].[DateCreated0], [t2].[DateModified0], [t2].[Description], [t2].[ExternalID], [t2].[IconPath], [t2].[ImagePath], [t2].[ParentProductCategoryID], [t2].[SearchTerm], [t2].[ShortDescription], [t2].[ShowOnMainPage], [t2].[SlugURL], [t2].[SortOrder], [t2].[SortOrderAsText], [t2].[StatusID0], [t2].[Title], [t2].[URL], [t2].[UserCreatedID0], [t2].[UserModifiedID0], [t3].[ID], [t3].[DateCreated], [t3].[DateModified], [t3].[PackageID], [t3].[StatusID], [t3].[UserCreatedID], [t3].[UserModifiedID], [t3].[WidgetID], [t3].[ID0], [t3].[BillFrequency], [t3].[BillFrequencyType], [t3].[Bundle], [t3].[BundleCode], [t3].[BundleDescription], [t3].[BundleOffer], [t3].[BundleTotalPrice], [t3].[Code], [t3].[DateCreated0], [t3].[DateModified0], [t3].[Description], [t3].[DigiturkPackageID], [t3].[GiftIconPath], [t3].[HasPrecondition], [t3].[HasPromotion], [t3].[HeadlineImagePath], [t3].[ImagePath], [t3].[InstallmentNumber], [t3].[InternetConnectionSpeedTypeID], [t3].[IsPopularPackage], [t3].[IsTeamOffer], [t3].[Name], [t3].[OfferFromCode], [t3].[OfferFromId], [t3].[OfferToCode], [t3].[OfferToId], [t3].[PackageContentImagePath], [t3].[PackageContentMobileImagePath], [t3].[PackageDetailTypeID], [t3].[PackageTypeID], [t3].[Precondition], [t3].[PriceAmount], [t3].[PriceDescription], [t3].[PriceTopDescription], [t3].[ProductCatalogCode], [t3].[Promotion], [t3].[ShortDescription], [t3].[SortOrder], [t3].[SpecialText], [t3].[StatusID0], [t3].[Text], [t3].[Title], [t3].[TopSeller], [t3].[UserCreatedID0], [t3].[UserModifiedID0], [t].[Action], [t].[Code0], [t].[Controller], [t].[DateCreated0], [t].[DateModified0], [t].[Description0], [t].[ImagePath0], [t].[IsTransparan], [t].[Keywords], [t].[Name], [t].[PageTitle], [t].[ParentPageID], [t].[SeoTitle0], [t].[SlugURL], [t].[SortOrder0], [t].[StatusID0], [t].[URL0], [t].[UserCreatedID0], [t].[UserModifiedID0], [p3].[ID], [p3].[DateCreated], [p3].[DateModified], [p3].[Description], [p3].[ImagePath], [p3].[LanguageID], [p3].[Name], [p3].[PageID], [p3].[PageTitle], [p3].[SeoTitle], [p3].[SlugURL], [p3].[StatusID], [p3].[URL], [p3].[UserCreatedID], [p3].[UserModifiedID], [t4].[ID], [t4].[ChannelID], [t4].[DateCreated], [t4].[DateModified], [t4].[StatusID], [t4].[UserCreatedID], [t4].[UserModifiedID], [t4].[WidgetID], [t4].[ID0], [t4].[ChannelCategoryID], [t4].[ChannelNumber], [t4].[DateCreated0], [t4].[DateModified0], [t4].[ExternalID], [t4].[IsGetLiveSports], [t4].[LogoPath], [t4].[Name], [t4].[ShortDescription], [t4].[StatusID0], [t4].[UserCreatedID0], [t4].[UserModifiedID0], [t].[Action0], [t].[Code1], [t].[Controller0], [t].[DateCreated1], [t].[DateModified1], [t].[Description1], [t].[ImagePath1], [t].[IsTransparan0], [t].[Keywords0], [t].[Name0], [t].[PageTitle0], [t].[ParentPageID0], [t].[SeoTitle1], [t].[SlugURL0], [t].[SortOrder1], [t].[StatusID1], [t].[URL1], [t].[UserCreatedID1], [t].[UserModifiedID1], [p4].[ID], [p4].[DateCreated], [p4].[DateModified], [p4].[Description], [p4].[ImagePath], [p4].[LanguageID], [p4].[Name], [p4].[PageID], [p4].[PageTitle], [p4].[SeoTitle], [p4].[SlugURL], [p4].[StatusID], [p4].[URL], [p4].[UserCreatedID], [p4].[UserModifiedID], [t].[DateCreated2], [t].[DateModified2], [t].[Description2], [t].[DisplayStatusID], [t].[HasPromotion], [t].[ImagePath2], [t].[Price], [t].[PricePeriod], [t].[PriceUnit], [t].[PriceValidity], [t].[PromotionGiftIconPath], [t].[PromotionTitle], [t].[ShortDescription], [t].[StatusID2], [t].[SubTitle0], [t].[Title0], [t].[UserCreatedID2], [t].[UserModifiedID2]
FROM (
SELECT TOP(1) [w].[ID], [w].[AdvantageID], [w].[BackgroundImageIconPath], [w].[BackgroundURL], [w].[BorderStyle], [w].[ButtonBackgroundColor], [w].[ButtonBackgroundPath], [w].[ButtonStyle], [w].[ButtonText], [w].[Code], [w].[ContentCount], [w].[ContentDisplayTypeID], [w].[DateCreated], [w].[DateModified], [w].[Description], [w].[ImagePath], [w].[MobileImagePath], [w].[PageID], [w].[PageUrlID], [w].[ParticlesJson], [w].[PublishDate], [w].[SecondaryCode], [w].[SeoTitle], [w].[ShowWhenLogin], [w].[ShowWhenNotLogin], [w].[SortOrder], [w].[StatusID], [w].[SubTitle], [w].[SubtitleStyle], [w].[Title], [w].[TitleStyle], [w].[URL], [w].[UnPublishDate], [w].[UserCreatedID], [w].[UserModifiedID], [w].[ViewTypeID], [p].[ID] AS [ID0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated0], [p].[DateModified] AS [DateModified0], [p].[Description] AS [Description0], [p].[ImagePath] AS [ImagePath0], [p].[IsTransparan], [p].[Keywords], [p].[Name], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle] AS [SeoTitle0], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID0], [p].[URL] AS [URL0], [p].[UserCreatedID] AS [UserCreatedID0], [p].[UserModifiedID] AS [UserModifiedID0], [p0].[ID] AS [ID1], [p0].[Action] AS [Action0], [p0].[Code] AS [Code1], [p0].[Controller] AS [Controller0], [p0].[DateCreated] AS [DateCreated1], [p0].[DateModified] AS [DateModified1], [p0].[Description] AS [Description1], [p0].[ImagePath] AS [ImagePath1], [p0].[IsTransparan] AS [IsTransparan0], [p0].[Keywords] AS [Keywords0], [p0].[Name] AS [Name0], [p0].[PageTitle] AS [PageTitle0], [p0].[ParentPageID] AS [ParentPageID0], [p0].[SeoTitle] AS [SeoTitle1], [p0].[SlugURL] AS [SlugURL0], [p0].[SortOrder] AS [SortOrder1], [p0].[StatusID] AS [StatusID1], [p0].[URL] AS [URL1], [p0].[UserCreatedID] AS [UserCreatedID1], [p0].[UserModifiedID] AS [UserModifiedID1], [a].[ID] AS [ID2], [a].[DateCreated] AS [DateCreated2], [a].[DateModified] AS [DateModified2], [a].[Description] AS [Description2], [a].[DisplayStatusID], [a].[HasPromotion], [a].[ImagePath] AS [ImagePath2], [a].[Price], [a].[PricePeriod], [a].[PriceUnit], [a].[PriceValidity], [a].[PromotionGiftIconPath], [a].[PromotionTitle], [a].[ShortDescription], [a].[StatusID] AS [StatusID2], [a].[SubTitle] AS [SubTitle0], [a].[Title] AS [Title0], [a].[UserCreatedID] AS [UserCreatedID2], [a].[UserModifiedID] AS [UserModifiedID2]
FROM [Content].[Widget] AS [w]
LEFT JOIN [Content].[Page] AS [p] ON [w].[PageID] = [p].[ID]
LEFT JOIN [Content].[Page] AS [p0] ON [w].[PageUrlID] = [p0].[ID]
LEFT JOIN [Content].[Advantage] AS [a] ON [w].[AdvantageID] = [a].[ID]
WHERE [w].[StatusID] <> @__DeletedStatusID_0 AND [w].[Code] = @__Code_1
ORDER BY [w].[ID] DESC
) AS [t]
LEFT JOIN [Content].[Widget_i18n] AS [w0] ON [t].[ID] = [w0].[WidgetID]
LEFT JOIN (
SELECT [b].[ID], [b].[AdvantageID], [b].[BackgroundColor], [b].[BackgroundImageIconPath], [b].[BackgroundPath], [b].[BorderColor], [b].[Code], [b].[ContentID], [b].[DateCreated], [b].[DateModified], [b].[FontColor], [b].[HeadlineID], [b].[HeadlineItemID], [b].[HoverColor], [b].[HoverDescription], [b].[IconName], [b].[SortOrder], [b].[StatusID], [b].[Text], [b].[Title], [b].[URL], [b].[UserCreatedID], [b].[UserModifiedID], [b].[WidgetContentID], [b].[WidgetID], [b0].[ID] AS [ID0], [b0].[ButtonID], [b0].[DateCreated] AS [DateCreated0], [b0].[DateModified] AS [DateModified0], [b0].[HoverDescription] AS [HoverDescription0], [b0].[LanguageID], [b0].[StatusID] AS [StatusID0], [b0].[Title] AS [Title0], [b0].[URL] AS [URL0], [b0].[UserCreatedID] AS [UserCreatedID0], [b0].[UserModifiedID] AS [UserModifiedID0]
FROM [Content].[Button] AS [b]
LEFT JOIN [Content].[Button_i18n] AS [b0] ON [b].[ID] = [b0].[ButtonID]
) AS [t0] ON [t].[ID] = [t0].[WidgetID]
LEFT JOIN (
SELECT [w1].[ID], [w1].[BackgroundColor], [w1].[Code], [w1].[DateCreated], [w1].[DateModified], [w1].[Description], [w1].[FaqQuestionID], [w1].[HoverImagePath], [w1].[IconName], [w1].[IconPath], [w1].[ImagePath], [w1].[PublishDate], [w1].[SeoTitle], [w1].[SortOrder], [w1].[StatusID], [w1].[SubTitle], [w1].[Title], [w1].[TitleStyle], [w1].[URL], [w1].[UnPublishDate], [w1].[UserCreatedID], [w1].[UserModifiedID], [w1].[VideoPath], [w1].[VoicePath], [w1].[WidgetID], [w2].[ID] AS [ID0], [w2].[DateCreated] AS [DateCreated0], [w2].[DateModified] AS [DateModified0], [w2].[Description] AS [Description0], [w2].[LanguageID], [w2].[StatusID] AS [StatusID0], [w2].[SubTitle] AS [SubTitle0], [w2].[Title] AS [Title0], [w2].[URL] AS [URL0], [w2].[UserCreatedID] AS [UserCreatedID0], [w2].[UserModifiedID] AS [UserModifiedID0], [w2].[WidgetContentID]
FROM [Content].[WidgetContent] AS [w1]
LEFT JOIN [Content].[WidgetContent_i18n] AS [w2] ON [w1].[ID] = [w2].[WidgetContentID]
) AS [t1] ON [t].[ID] = [t1].[WidgetID]
LEFT JOIN (
SELECT [w3].[ID], [w3].[DateCreated], [w3].[DateModified], [w3].[ProductCategoryID], [w3].[StatusID], [w3].[UserCreatedID], [w3].[UserModifiedID], [w3].[WidgetID], [p1].[ID] AS [ID0], [p1].[ButtonText], [p1].[Code], [p1].[DateCreated] AS [DateCreated0], [p1].[DateModified] AS [DateModified0], [p1].[Description], [p1].[ExternalID], [p1].[IconPath], [p1].[ImagePath], [p1].[ParentProductCategoryID], [p1].[SearchTerm], [p1].[ShortDescription], [p1].[ShowOnMainPage], [p1].[SlugURL], [p1].[SortOrder], [p1].[SortOrderAsText], [p1].[StatusID] AS [StatusID0], [p1].[Title], [p1].[URL], [p1].[UserCreatedID] AS [UserCreatedID0], [p1].[UserModifiedID] AS [UserModifiedID0]
FROM [Content].[WidgetProductCategory] AS [w3]
INNER JOIN [Catalog].[ProductCategory] AS [p1] ON [w3].[ProductCategoryID] = [p1].[ID]
) AS [t2] ON [t].[ID] = [t2].[WidgetID]
LEFT JOIN (
SELECT [w4].[ID], [w4].[DateCreated], [w4].[DateModified], [w4].[PackageID], [w4].[StatusID], [w4].[UserCreatedID], [w4].[UserModifiedID], [w4].[WidgetID], [p2].[ID] AS [ID0], [p2].[BillFrequency], [p2].[BillFrequencyType], [p2].[Bundle], [p2].[BundleCode], [p2].[BundleDescription], [p2].[BundleOffer], [p2].[BundleTotalPrice], [p2].[Code], [p2].[DateCreated] AS [DateCreated0], [p2].[DateModified] AS [DateModified0], [p2].[Description], [p2].[DigiturkPackageID], [p2].[GiftIconPath], [p2].[HasPrecondition], [p2].[HasPromotion], [p2].[HeadlineImagePath], [p2].[ImagePath], [p2].[InstallmentNumber], [p2].[InternetConnectionSpeedTypeID], [p2].[IsPopularPackage], [p2].[IsTeamOffer], [p2].[Name], [p2].[OfferFromCode], [p2].[OfferFromId], [p2].[OfferToCode], [p2].[OfferToId], [p2].[PackageContentImagePath], [p2].[PackageContentMobileImagePath], [p2].[PackageDetailTypeID], [p2].[PackageTypeID], [p2].[Precondition], [p2].[PriceAmount], [p2].[PriceDescription], [p2].[PriceTopDescription], [p2].[ProductCatalogCode], [p2].[Promotion], [p2].[ShortDescription], [p2].[SortOrder], [p2].[SpecialText], [p2].[StatusID] AS [StatusID0], [p2].[Text], [p2].[Title], [p2].[TopSeller], [p2].[UserCreatedID] AS [UserCreatedID0], [p2].[UserModifiedID] AS [UserModifiedID0]
FROM [Content].[WidgetPackage] AS [w4]
INNER JOIN [Content].[Package] AS [p2] ON [w4].[PackageID] = [p2].[ID]
) AS [t3] ON [t].[ID] = [t3].[WidgetID]
LEFT JOIN [Content].[Page_i18n] AS [p3] ON [t].[ID0] = [p3].[PageID]
LEFT JOIN (
SELECT [w5].[ID], [w5].[ChannelID], [w5].[DateCreated], [w5].[DateModified], [w5].[StatusID], [w5].[UserCreatedID], [w5].[UserModifiedID], [w5].[WidgetID], [c].[ID] AS [ID0], [c].[ChannelCategoryID], [c].[ChannelNumber], [c].[DateCreated] AS [DateCreated0], [c].[DateModified] AS [DateModified0], [c].[ExternalID], [c].[IsGetLiveSports], [c].[LogoPath], [c].[Name], [c].[ShortDescription], [c].[StatusID] AS [StatusID0], [c].[UserCreatedID] AS [UserCreatedID0], [c].[UserModifiedID] AS [UserModifiedID0]
FROM [Content].[WidgetChannel] AS [w5]
INNER JOIN [Catalog].[Channel] AS [c] ON [w5].[ChannelID] = [c].[ID]
) AS [t4] ON [t].[ID] = [t4].[WidgetID]
LEFT JOIN [Content].[Page_i18n] AS [p4] ON [t].[ID1] = [p4].[PageID]
ORDER BY [t].[ID] DESC, [t].[ID0], [t].[ID1], [t].[ID2], [w0].[ID], [t0].[ID], [t0].[ID0], [t1].[ID], [t1].[ID0], [t2].[ID], [t2].[ID0], [t3].[ID], [t3].[ID0], [p3].[ID], [t4].[ID], [t4].[ID0]
|
17ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
14ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
12ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
12ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
10ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
9ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
9ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[ActionURL], [t].[Attributes], [t].[Code], [t].[ColorCode], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[IconImage], [t].[Name], [t].[SecondaryCode], [t].[SecondaryColor], [t].[SortOrder], [t].[StatusID], [t].[SubTitle], [t].[UserCreatedID], [t].[UserModifiedID], [t].[ViewComponentID], [m0].[ID], [m0].[DateCreated], [m0].[DateModified], [m0].[Description], [m0].[LanguageID], [m0].[MenuID], [m0].[Name], [m0].[StatusID], [m0].[SubTitle], [m0].[UserCreatedID], [m0].[UserModifiedID], [t0].[ID], [t0].[Attributes], [t0].[Code], [t0].[DateCreated], [t0].[DateModified], [t0].[Description], [t0].[LabelColor], [t0].[LabelText], [t0].[MenuID], [t0].[MobileAppIcon], [t0].[MobileAppURL], [t0].[MobileImagePath], [t0].[Name], [t0].[PageID], [t0].[ParentMenuItemID], [t0].[RGBColor], [t0].[SortOrder], [t0].[StatusID], [t0].[URL], [t0].[UrlTypeID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[WebIcon], [t0].[WebImagePath], [t0].[ID0], [t0].[ID1], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description0], [t0].[LabelText0], [t0].[LanguageID], [t0].[MenuItemID], [t0].[MobileAppURL0], [t0].[MobileImagePath0], [t0].[Name0], [t0].[PageID0], [t0].[StatusID0], [t0].[URL0], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t0].[WebImagePath0], [t0].[Action], [t0].[Code0], [t0].[Controller], [t0].[DateCreated1], [t0].[DateModified1], [t0].[Description1], [t0].[ImagePath], [t0].[IsTransparan], [t0].[Keywords], [t0].[Name1], [t0].[PageTitle], [t0].[ParentPageID], [t0].[SeoTitle], [t0].[SlugURL], [t0].[SortOrder0], [t0].[StatusID1], [t0].[URL1], [t0].[UserCreatedID1], [t0].[UserModifiedID1]
FROM (
SELECT [m].[ID], [m].[ActionURL], [m].[Attributes], [m].[Code], [m].[ColorCode], [m].[DateCreated], [m].[DateModified], [m].[Description], [m].[IconImage], [m].[Name], [m].[SecondaryCode], [m].[SecondaryColor], [m].[SortOrder], [m].[StatusID], [m].[SubTitle], [m].[UserCreatedID], [m].[UserModifiedID], [m].[ViewComponentID]
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
ORDER BY [m].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[Menu_i18n] AS [m0] ON [t].[ID] = [m0].[MenuID]
LEFT JOIN (
SELECT [m1].[ID], [m1].[Attributes], [m1].[Code], [m1].[DateCreated], [m1].[DateModified], [m1].[Description], [m1].[LabelColor], [m1].[LabelText], [m1].[MenuID], [m1].[MobileAppIcon], [m1].[MobileAppURL], [m1].[MobileImagePath], [m1].[Name], [m1].[PageID], [m1].[ParentMenuItemID], [m1].[RGBColor], [m1].[SortOrder], [m1].[StatusID], [m1].[URL], [m1].[UrlTypeID], [m1].[UserCreatedID], [m1].[UserModifiedID], [m1].[WebIcon], [m1].[WebImagePath], [p].[ID] AS [ID0], [m2].[ID] AS [ID1], [m2].[DateCreated] AS [DateCreated0], [m2].[DateModified] AS [DateModified0], [m2].[Description] AS [Description0], [m2].[LabelText] AS [LabelText0], [m2].[LanguageID], [m2].[MenuItemID], [m2].[MobileAppURL] AS [MobileAppURL0], [m2].[MobileImagePath] AS [MobileImagePath0], [m2].[Name] AS [Name0], [m2].[PageID] AS [PageID0], [m2].[StatusID] AS [StatusID0], [m2].[URL] AS [URL0], [m2].[UserCreatedID] AS [UserCreatedID0], [m2].[UserModifiedID] AS [UserModifiedID0], [m2].[WebImagePath] AS [WebImagePath0], [p].[Action], [p].[Code] AS [Code0], [p].[Controller], [p].[DateCreated] AS [DateCreated1], [p].[DateModified] AS [DateModified1], [p].[Description] AS [Description1], [p].[ImagePath], [p].[IsTransparan], [p].[Keywords], [p].[Name] AS [Name1], [p].[PageTitle], [p].[ParentPageID], [p].[SeoTitle], [p].[SlugURL], [p].[SortOrder] AS [SortOrder0], [p].[StatusID] AS [StatusID1], [p].[URL] AS [URL1], [p].[UserCreatedID] AS [UserCreatedID1], [p].[UserModifiedID] AS [UserModifiedID1]
FROM [Content].[MenuItem] AS [m1]
LEFT JOIN [Content].[Page] AS [p] ON [m1].[PageID] = [p].[ID]
LEFT JOIN [Content].[MenuItem_i18n] AS [m2] ON [m1].[ID] = [m2].[MenuItemID]
) AS [t0] ON [t].[ID] = [t0].[MenuID]
ORDER BY [t].[ID] DESC, [m0].[ID], [t0].[ID], [t0].[ID0]
|
3ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[Code], [t].[DateCreated], [t].[DateModified], [t].[IsSelect], [t].[Name], [t].[PropertyDetailID], [t].[SortOrder], [t].[StatusID], [t].[UserCreatedID], [t].[UserModifiedID], [p0].[ID], [p0].[Code], [p0].[DateCreated], [p0].[DateModified], [p0].[IsMultiple], [p0].[Name], [p0].[SortOrder], [p0].[StatusID], [p0].[UserCreatedID], [p0].[UserModifiedID], [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[LanguageID], [p1].[Name], [p1].[PropertyDetailItemID], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID]
FROM (
SELECT [p].[ID], [p].[Code], [p].[DateCreated], [p].[DateModified], [p].[IsSelect], [p].[Name], [p].[PropertyDetailID], [p].[SortOrder], [p].[StatusID], [p].[UserCreatedID], [p].[UserModifiedID]
FROM [Content].[PropertyDetailItem] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
INNER JOIN [Content].[PropertyDetail] AS [p0] ON [t].[PropertyDetailID] = [p0].[ID]
LEFT JOIN [Content].[PropertyDetailItem_i18n] AS [p1] ON [t].[ID] = [p1].[PropertyDetailItemID]
ORDER BY [t].[ID] DESC, [p0].[ID]
|
3ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__entity_ID_1='?' (DbTy...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__entity_ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [w].[ID], [w].[BackgroundColor], [w].[Code], [w].[DateCreated], [w].[DateModified], [w].[Description], [w].[FaqQuestionID], [w].[HoverImagePath], [w].[IconName], [w].[IconPath], [w].[ImagePath], [w].[PublishDate], [w].[SeoTitle], [w].[SortOrder], [w].[StatusID], [w].[SubTitle], [w].[Title], [w].[TitleStyle], [w].[URL], [w].[UnPublishDate], [w].[UserCreatedID], [w].[UserModifiedID], [w].[VideoPath], [w].[VoicePath], [w].[WidgetID], [w0].[ID], [f].[ID], [f0].[ID], [f1].[ID], [w1].[ID], [w1].[DateCreated], [w1].[DateModified], [w1].[Description], [w1].[LanguageID], [w1].[StatusID], [w1].[SubTitle], [w1].[Title], [w1].[URL], [w1].[UserCreatedID], [w1].[UserModifiedID], [w1].[WidgetContentID], [t].[ID], [t].[AdvantageID], [t].[BackgroundColor], [t].[BackgroundImageIconPath], [t].[BackgroundPath], [t].[BorderColor], [t].[Code], [t].[ContentID], [t].[DateCreated], [t].[DateModified], [t].[FontColor], [t].[HeadlineID], [t].[HeadlineItemID], [t].[HoverColor], [t].[HoverDescription], [t].[IconName], [t].[SortOrder], [t].[StatusID], [t].[Text], [t].[Title], [t].[URL], [t].[UserCreatedID], [t].[UserModifiedID], [t].[WidgetContentID], [t].[WidgetID], [t].[ID0], [t].[ButtonID], [t].[DateCreated0], [t].[DateModified0], [t].[HoverDescription0], [t].[LanguageID], [t].[StatusID0], [t].[Title0], [t].[URL0], [t].[UserCreatedID0], [t].[UserModifiedID0], [w0].[AdvantageID], [w0].[BackgroundImageIconPath], [w0].[BackgroundURL], [w0].[BorderStyle], [w0].[ButtonBackgroundColor], [w0].[ButtonBackgroundPath], [w0].[ButtonStyle], [w0].[ButtonText], [w0].[Code], [w0].[ContentCount], [w0].[ContentDisplayTypeID], [w0].[DateCreated], [w0].[DateModified], [w0].[Description], [w0].[ImagePath], [w0].[MobileImagePath], [w0].[PageID], [w0].[PageUrlID], [w0].[ParticlesJson], [w0].[PublishDate], [w0].[SecondaryCode], [w0].[SeoTitle], [w0].[ShowWhenLogin], [w0].[ShowWhenNotLogin], [w0].[SortOrder], [w0].[StatusID], [w0].[SubTitle], [w0].[SubtitleStyle], [w0].[Title], [w0].[TitleStyle], [w0].[URL], [w0].[UnPublishDate], [w0].[UserCreatedID], [w0].[UserModifiedID], [w0].[ViewTypeID], [f].[DateCreated], [f].[DateModified], [f].[ExternalID], [f].[FaqCategoryID], [f].[IsFeatured], [f].[StatusID], [f].[Title], [f].[UserCreatedID], [f].[UserModifiedID], [f0].[DateCreated], [f0].[DateModified], [f0].[ExternalID], [f0].[FaqParentCategoryID], [f0].[StatusID], [f0].[Title], [f0].[UserCreatedID], [f0].[UserModifiedID], [f1].[DateCreated], [f1].[DateModified], [f1].[ExternalID], [f1].[SortOrder], [f1].[StatusID], [f1].[Title], [f1].[UserCreatedID], [f1].[UserModifiedID]
FROM [Content].[WidgetContent] AS [w]
INNER JOIN [Content].[Widget] AS [w0] ON [w].[WidgetID] = [w0].[ID]
LEFT JOIN [Content].[FaqQuestion] AS [f] ON [w].[FaqQuestionID] = [f].[ID]
LEFT JOIN [Content].[FaqCategory] AS [f0] ON [f].[FaqCategoryID] = [f0].[ID]
LEFT JOIN [Content].[FaqParentCategory] AS [f1] ON [f0].[FaqParentCategoryID] = [f1].[ID]
LEFT JOIN [Content].[WidgetContent_i18n] AS [w1] ON [w].[ID] = [w1].[WidgetContentID]
LEFT JOIN (
SELECT [b].[ID], [b].[AdvantageID], [b].[BackgroundColor], [b].[BackgroundImageIconPath], [b].[BackgroundPath], [b].[BorderColor], [b].[Code], [b].[ContentID], [b].[DateCreated], [b].[DateModified], [b].[FontColor], [b].[HeadlineID], [b].[HeadlineItemID], [b].[HoverColor], [b].[HoverDescription], [b].[IconName], [b].[SortOrder], [b].[StatusID], [b].[Text], [b].[Title], [b].[URL], [b].[UserCreatedID], [b].[UserModifiedID], [b].[WidgetContentID], [b].[WidgetID], [b0].[ID] AS [ID0], [b0].[ButtonID], [b0].[DateCreated] AS [DateCreated0], [b0].[DateModified] AS [DateModified0], [b0].[HoverDescription] AS [HoverDescription0], [b0].[LanguageID], [b0].[StatusID] AS [StatusID0], [b0].[Title] AS [Title0], [b0].[URL] AS [URL0], [b0].[UserCreatedID] AS [UserCreatedID0], [b0].[UserModifiedID] AS [UserModifiedID0]
FROM [Content].[Button] AS [b]
LEFT JOIN [Content].[Button_i18n] AS [b0] ON [b].[ID] = [b0].[ButtonID]
) AS [t] ON [w].[ID] = [t].[WidgetContentID]
WHERE [w].[StatusID] <> @__DeletedStatusID_0 AND [w].[WidgetID] = @__entity_ID_1
ORDER BY [w].[ID] DESC, [w0].[ID], [f].[ID], [f0].[ID], [f1].[ID], [w1].[ID], [t].[ID]
|
2ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[Code], [t].[DateCreated], [t].[DateModified], [t].[IsSelect], [t].[Name], [t].[PropertyDetailID], [t].[SortOrder], [t].[StatusID], [t].[UserCreatedID], [t].[UserModifiedID], [p0].[ID], [p0].[Code], [p0].[DateCreated], [p0].[DateModified], [p0].[IsMultiple], [p0].[Name], [p0].[SortOrder], [p0].[StatusID], [p0].[UserCreatedID], [p0].[UserModifiedID], [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[LanguageID], [p1].[Name], [p1].[PropertyDetailItemID], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID]
FROM (
SELECT [p].[ID], [p].[Code], [p].[DateCreated], [p].[DateModified], [p].[IsSelect], [p].[Name], [p].[PropertyDetailID], [p].[SortOrder], [p].[StatusID], [p].[UserCreatedID], [p].[UserModifiedID]
FROM [Content].[PropertyDetailItem] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
INNER JOIN [Content].[PropertyDetail] AS [p0] ON [t].[PropertyDetailID] = [p0].[ID]
LEFT JOIN [Content].[PropertyDetailItem_i18n] AS [p1] ON [t].[ID] = [p1].[PropertyDetailItemID]
ORDER BY [t].[ID] DESC, [p0].[ID]
|
2ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__code_1='?' (Size = 25...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__code_1='?' (Size = 255)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[ID]
FROM [Content].[Page] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[Code] = @__code_1
ORDER BY [p].[Name], [p].[SortOrder]
|
2ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[BillFrequency], [t].[BillFrequencyType], [t].[Bundle], [t].[BundleCode], [t].[BundleDescription], [t].[BundleOffer], [t].[BundleTotalPrice], [t].[Code], [t].[DateCreated], [t].[DateModified], [t].[Description], [t].[DigiturkPackageID], [t].[GiftIconPath], [t].[HasPrecondition], [t].[HasPromotion], [t].[HeadlineImagePath], [t].[ImagePath], [t].[InstallmentNumber], [t].[InternetConnectionSpeedTypeID], [t].[IsPopularPackage], [t].[IsTeamOffer], [t].[Name], [t].[OfferFromCode], [t].[OfferFromId], [t].[OfferToCode], [t].[OfferToId], [t].[PackageContentImagePath], [t].[PackageContentMobileImagePath], [t].[PackageDetailTypeID], [t].[PackageTypeID], [t].[Precondition], [t].[PriceAmount], [t].[PriceDescription], [t].[PriceTopDescription], [t].[ProductCatalogCode], [t].[Promotion], [t].[ShortDescription], [t].[SortOrder], [t].[SpecialText], [t].[StatusID], [t].[Text], [t].[Title], [t].[TopSeller], [t].[UserCreatedID], [t].[UserModifiedID], [i].[ID], [i].[DateCreated], [i].[DateModified], [i].[Name], [i].[SortOrder], [i].[StatusID], [i].[UserCreatedID], [i].[UserModifiedID], [p0].[ID], [p0].[Code], [p0].[DateCreated], [p0].[DateModified], [p0].[Description], [p0].[DigiturkPackageID], [p0].[GiftIconPath], [p0].[HasPrecondition], [p0].[HasPromotion], [p0].[HeadlineImagePath], [p0].[ImagePath], [p0].[LanguageID], [p0].[Name], [p0].[PackageContentImagePath], [p0].[PackageContentMobileImagePath], [p0].[PackageID], [p0].[Precondition], [p0].[Promotion], [p0].[ShortDescription], [p0].[StatusID], [p0].[Text], [p0].[UserCreatedID], [p0].[UserModifiedID], [t0].[ID], [t0].[DateCreated], [t0].[DateModified], [t0].[PackageID], [t0].[ProductCategoryID], [t0].[StatusID], [t0].[UserCreatedID], [t0].[UserModifiedID], [t0].[ID0], [t0].[ButtonText], [t0].[Code], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Description], [t0].[ExternalID], [t0].[IconPath], [t0].[ImagePath], [t0].[ParentProductCategoryID], [t0].[SearchTerm], [t0].[ShortDescription], [t0].[ShowOnMainPage], [t0].[SlugURL], [t0].[SortOrder], [t0].[SortOrderAsText], [t0].[StatusID0], [t0].[Title], [t0].[URL], [t0].[UserCreatedID0], [t0].[UserModifiedID0], [t1].[ID], [t1].[ChannelID], [t1].[DateCreated], [t1].[DateModified], [t1].[PackageID], [t1].[StatusID], [t1].[UserCreatedID], [t1].[UserModifiedID], [t1].[ID0], [t1].[ChannelCategoryID], [t1].[ChannelNumber], [t1].[DateCreated0], [t1].[DateModified0], [t1].[ExternalID], [t1].[IsGetLiveSports], [t1].[LogoPath], [t1].[Name], [t1].[ShortDescription], [t1].[StatusID0], [t1].[UserCreatedID0], [t1].[UserModifiedID0]
FROM (
SELECT [p].[ID], [p].[BillFrequency], [p].[BillFrequencyType], [p].[Bundle], [p].[BundleCode], [p].[BundleDescription], [p].[BundleOffer], [p].[BundleTotalPrice], [p].[Code], [p].[DateCreated], [p].[DateModified], [p].[Description], [p].[DigiturkPackageID], [p].[GiftIconPath], [p].[HasPrecondition], [p].[HasPromotion], [p].[HeadlineImagePath], [p].[ImagePath], [p].[InstallmentNumber], [p].[InternetConnectionSpeedTypeID], [p].[IsPopularPackage], [p].[IsTeamOffer], [p].[Name], [p].[OfferFromCode], [p].[OfferFromId], [p].[OfferToCode], [p].[OfferToId], [p].[PackageContentImagePath], [p].[PackageContentMobileImagePath], [p].[PackageDetailTypeID], [p].[PackageTypeID], [p].[Precondition], [p].[PriceAmount], [p].[PriceDescription], [p].[PriceTopDescription], [p].[ProductCatalogCode], [p].[Promotion], [p].[ShortDescription], [p].[SortOrder], [p].[SpecialText], [p].[StatusID], [p].[Text], [p].[Title], [p].[TopSeller], [p].[UserCreatedID], [p].[UserModifiedID]
FROM [Content].[Package] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1 AND [p].[IsPopularPackage] = CAST(1 AS bit)
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[InternetConnectionSpeedType] AS [i] ON [t].[InternetConnectionSpeedTypeID] = [i].[ID]
LEFT JOIN [Content].[Package_i18n] AS [p0] ON [t].[ID] = [p0].[PackageID]
LEFT JOIN (
SELECT [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[PackageID], [p1].[ProductCategoryID], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID], [p2].[ID] AS [ID0], [p2].[ButtonText], [p2].[Code], [p2].[DateCreated] AS [DateCreated0], [p2].[DateModified] AS [DateModified0], [p2].[Description], [p2].[ExternalID], [p2].[IconPath], [p2].[ImagePath], [p2].[ParentProductCategoryID], [p2].[SearchTerm], [p2].[ShortDescription], [p2].[ShowOnMainPage], [p2].[SlugURL], [p2].[SortOrder], [p2].[SortOrderAsText], [p2].[StatusID] AS [StatusID0], [p2].[Title], [p2].[URL], [p2].[UserCreatedID] AS [UserCreatedID0], [p2].[UserModifiedID] AS [UserModifiedID0]
FROM [Catalog].[PackageProductCategory] AS [p1]
INNER JOIN [Catalog].[ProductCategory] AS [p2] ON [p1].[ProductCategoryID] = [p2].[ID]
) AS [t0] ON [t].[ID] = [t0].[PackageID]
LEFT JOIN (
SELECT [p3].[ID], [p3].[ChannelID], [p3].[DateCreated], [p3].[DateModified], [p3].[PackageID], [p3].[StatusID], [p3].[UserCreatedID], [p3].[UserModifiedID], [c].[ID] AS [ID0], [c].[ChannelCategoryID], [c].[ChannelNumber], [c].[DateCreated] AS [DateCreated0], [c].[DateModified] AS [DateModified0], [c].[ExternalID], [c].[IsGetLiveSports], [c].[LogoPath], [c].[Name], [c].[ShortDescription], [c].[StatusID] AS [StatusID0], [c].[UserCreatedID] AS [UserCreatedID0], [c].[UserModifiedID] AS [UserModifiedID0]
FROM [Content].[PackageChannel] AS [p3]
INNER JOIN [Catalog].[Channel] AS [c] ON [p3].[ChannelID] = [c].[ID]
) AS [t1] ON [t].[ID] = [t1].[PackageID]
ORDER BY [t].[ID] DESC, [i].[ID], [p0].[ID], [t0].[ID], [t0].[ID0], [t1].[ID]
|
2ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
2ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[PropertyDetailItem] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[PropertyDetailItem] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbT...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[URL]
FROM [Content].[Page] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[ID] = @__request_ID_1
ORDER BY [p].[Name], [p].[SortOrder]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[Code], [t].[DateCreated], [t].[DateModified], [t].[IsSelect], [t].[Name], [t].[PropertyDetailID], [t].[SortOrder], [t].[StatusID], [t].[UserCreatedID], [t].[UserModifiedID], [p0].[ID], [p0].[Code], [p0].[DateCreated], [p0].[DateModified], [p0].[IsMultiple], [p0].[Name], [p0].[SortOrder], [p0].[StatusID], [p0].[UserCreatedID], [p0].[UserModifiedID], [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[LanguageID], [p1].[Name], [p1].[PropertyDetailItemID], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID]
FROM (
SELECT [p].[ID], [p].[Code], [p].[DateCreated], [p].[DateModified], [p].[IsSelect], [p].[Name], [p].[PropertyDetailID], [p].[SortOrder], [p].[StatusID], [p].[UserCreatedID], [p].[UserModifiedID]
FROM [Content].[PropertyDetailItem] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
INNER JOIN [Content].[PropertyDetail] AS [p0] ON [t].[PropertyDetailID] = [p0].[ID]
LEFT JOIN [Content].[PropertyDetailItem_i18n] AS [p1] ON [t].[ID] = [p1].[PropertyDetailItemID]
ORDER BY [t].[ID] DESC, [p0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbT...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[URL]
FROM [Content].[Page] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[ID] = @__request_ID_1
ORDER BY [p].[Name], [p].[SortOrder]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbT...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__request_ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [p].[URL]
FROM [Content].[Page] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[ID] = @__request_ID_1
ORDER BY [p].[Name], [p].[SortOrder]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[DataValue], [t].[DateCreated], [t].[DateModified], [t].[EmailBody], [t].[EmailSubject], [t].[EntityID], [t].[EntityType], [t].[LanguageID], [t].[MobilePushNotificationText], [t].[MobilePushNotificationTitle], [t].[MobilePushNotificationType], [t].[PushNotificationTemplateID], [t].[SMSText], [t].[SendDesktopPushNotification], [t].[SendEmail], [t].[SendMobilePushNotification], [t].[SendSMS], [t].[StatusID], [t].[SubEntityID], [t].[SubEntityType], [t].[UserCreatedID], [t].[UserModifiedID], [t].[WebPushNotificationURL], [l].[ID], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated], [l].[DateModified], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID], [l].[UserCreatedID], [l].[UserModifiedID], [t].[ID0], [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[EmailBody], [p1].[EmailSubject], [p1].[LanguageID], [p1].[MobilePushNotificationText], [p1].[MobilePushNotificationTitle], [p1].[PushNotificationID], [p1].[SMSText], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID], [t].[Code], [t].[DateCreated0], [t].[DateModified0], [t].[EmailBody0], [t].[EmailSubject0], [t].[MobilePushNotificationText0], [t].[MobilePushNotificationTitle0], [t].[MobilePushNotificationType0], [t].[SMSText0], [t].[SendEmail0], [t].[SendSMS0], [t].[SendToDesktopPushNotification], [t].[SendToMobilePushNotification], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t].[WebPushNotificationURL0], [p2].[ID], [p2].[DateCreated], [p2].[DateModified], [p2].[EmailBody], [p2].[EmailSubject], [p2].[LanguageID], [p2].[MobilePushNotificationText], [p2].[MobilePushNotificationTitle], [p2].[MobilePushNotificationType], [p2].[PushNotificationTemplateID], [p2].[SMSText], [p2].[StatusID], [p2].[UserCreatedID], [p2].[UserModifiedID]
FROM (
SELECT [p].[ID], [p].[DataValue], [p].[DateCreated], [p].[DateModified], [p].[EmailBody], [p].[EmailSubject], [p].[EntityID], [p].[EntityType], [p].[LanguageID], [p].[MobilePushNotificationText], [p].[MobilePushNotificationTitle], [p].[MobilePushNotificationType], [p].[PushNotificationTemplateID], [p].[SMSText], [p].[SendDesktopPushNotification], [p].[SendEmail], [p].[SendMobilePushNotification], [p].[SendSMS], [p].[StatusID], [p].[SubEntityID], [p].[SubEntityType], [p].[UserCreatedID], [p].[UserModifiedID], [p].[WebPushNotificationURL], [p0].[ID] AS [ID0], [p0].[Code], [p0].[DateCreated] AS [DateCreated0], [p0].[DateModified] AS [DateModified0], [p0].[EmailBody] AS [EmailBody0], [p0].[EmailSubject] AS [EmailSubject0], [p0].[MobilePushNotificationText] AS [MobilePushNotificationText0], [p0].[MobilePushNotificationTitle] AS [MobilePushNotificationTitle0], [p0].[MobilePushNotificationType] AS [MobilePushNotificationType0], [p0].[SMSText] AS [SMSText0], [p0].[SendEmail] AS [SendEmail0], [p0].[SendSMS] AS [SendSMS0], [p0].[SendToDesktopPushNotification], [p0].[SendToMobilePushNotification], [p0].[StatusID] AS [StatusID0], [p0].[UserCreatedID] AS [UserCreatedID0], [p0].[UserModifiedID] AS [UserModifiedID0], [p0].[WebPushNotificationURL] AS [WebPushNotificationURL0]
FROM [Communication].[PushNotification] AS [p]
LEFT JOIN [Communication].[PushNotificationTemplate] AS [p0] ON [p].[PushNotificationTemplateID] = [p0].[ID]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1 AND [p0].[Code] = N'NotLoggedIn' AND [p].[SendDesktopPushNotification] = CAST(1 AS bit)
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
INNER JOIN [Definition].[Language] AS [l] ON [t].[LanguageID] = [l].[ID]
LEFT JOIN [Communication].[PushNotification_i18n] AS [p1] ON [t].[ID] = [p1].[PushNotificationID]
LEFT JOIN [Communication].[PushNotificationTemplate_i18n] AS [p2] ON [t].[ID0] = [p2].[PushNotificationTemplateID]
ORDER BY [t].[ID] DESC, [t].[ID0], [l].[ID], [p1].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[Code], [t].[DateCreated], [t].[DateModified], [t].[IsSelect], [t].[Name], [t].[PropertyDetailID], [t].[SortOrder], [t].[StatusID], [t].[UserCreatedID], [t].[UserModifiedID], [p0].[ID], [p0].[Code], [p0].[DateCreated], [p0].[DateModified], [p0].[IsMultiple], [p0].[Name], [p0].[SortOrder], [p0].[StatusID], [p0].[UserCreatedID], [p0].[UserModifiedID], [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[LanguageID], [p1].[Name], [p1].[PropertyDetailItemID], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID]
FROM (
SELECT [p].[ID], [p].[Code], [p].[DateCreated], [p].[DateModified], [p].[IsSelect], [p].[Name], [p].[PropertyDetailID], [p].[SortOrder], [p].[StatusID], [p].[UserCreatedID], [p].[UserModifiedID]
FROM [Content].[PropertyDetailItem] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
INNER JOIN [Content].[PropertyDetail] AS [p0] ON [t].[PropertyDetailID] = [p0].[ID]
LEFT JOIN [Content].[PropertyDetailItem_i18n] AS [p1] ON [t].[ID] = [p1].[PropertyDetailItemID]
ORDER BY [t].[ID] DESC, [p0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[PropertyDetailItem] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[Code], [t].[DateCreated], [t].[DateModified], [t].[IsSelect], [t].[Name], [t].[PropertyDetailID], [t].[SortOrder], [t].[StatusID], [t].[UserCreatedID], [t].[UserModifiedID], [p0].[ID], [p0].[Code], [p0].[DateCreated], [p0].[DateModified], [p0].[IsMultiple], [p0].[Name], [p0].[SortOrder], [p0].[StatusID], [p0].[UserCreatedID], [p0].[UserModifiedID], [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[LanguageID], [p1].[Name], [p1].[PropertyDetailItemID], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID]
FROM (
SELECT [p].[ID], [p].[Code], [p].[DateCreated], [p].[DateModified], [p].[IsSelect], [p].[Name], [p].[PropertyDetailID], [p].[SortOrder], [p].[StatusID], [p].[UserCreatedID], [p].[UserModifiedID]
FROM [Content].[PropertyDetailItem] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
INNER JOIN [Content].[PropertyDetail] AS [p0] ON [t].[PropertyDetailID] = [p0].[ID]
LEFT JOIN [Content].[PropertyDetailItem_i18n] AS [p1] ON [t].[ID] = [p1].[PropertyDetailItemID]
ORDER BY [t].[ID] DESC, [p0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Menu] AS [m]
WHERE [m].[StatusID] <> @__DeletedStatusID_0 AND [m].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Communication].[PushNotification] AS [p]
LEFT JOIN [Communication].[PushNotificationTemplate] AS [p0] ON [p].[PushNotificationTemplateID] = [p0].[ID]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1 AND [p0].[Code] = N'NotLoggedIn' AND [p].[SendDesktopPushNotification] = CAST(1 AS bit)
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[PropertyDetail] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[Code], [t].[DateCreated], [t].[DateModified], [t].[IsMultiple], [t].[Name], [t].[SortOrder], [t].[StatusID], [t].[UserCreatedID], [t].[UserModifiedID], [p0].[ID], [p0].[Code], [p0].[DateCreated], [p0].[DateModified], [p0].[IsSelect], [p0].[Name], [p0].[PropertyDetailID], [p0].[SortOrder], [p0].[StatusID], [p0].[UserCreatedID], [p0].[UserModifiedID], [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[LanguageID], [p1].[Name], [p1].[PropertyDetailID], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID]
FROM (
SELECT [p].[ID], [p].[Code], [p].[DateCreated], [p].[DateModified], [p].[IsMultiple], [p].[Name], [p].[SortOrder], [p].[StatusID], [p].[UserCreatedID], [p].[UserModifiedID]
FROM [Content].[PropertyDetail] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
LEFT JOIN [Content].[PropertyDetailItem] AS [p0] ON [t].[ID] = [p0].[PropertyDetailID]
LEFT JOIN [Content].[PropertyDetail_i18n] AS [p1] ON [t].[ID] = [p1].[PropertyDetailID]
ORDER BY [t].[ID] DESC, [p0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[PropertyDetailItem] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Communication].[PushNotification] AS [p]
LEFT JOIN [Communication].[PushNotificationTemplate] AS [p0] ON [p].[PushNotificationTemplateID] = [p0].[ID]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1 AND [p0].[Code] = N'NotLoggedIn' AND [p].[SendDesktopPushNotification] = CAST(1 AS bit)
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = In...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[AddressID], [t].[AllowedToCommunicate], [t].[DateCreated], [t].[DateModified], [t].[EmailAddress], [t].[FirstName], [t].[FullName], [t].[IdentityNumber], [t].[IntegrationCode], [t].[IsGlobalAdmin], [t].[LanguageID], [t].[LastMobileAppID], [t].[LastMobileLoginDate], [t].[LastName], [t].[LastPasswordModifiedDate], [t].[LastWebLoginDate], [t].[LoggedInBefore], [t].[Password], [t].[PasswordSalt], [t].[PersonnelCode], [t].[PhoneNumber], [t].[ProfileImagePath], [t].[StatusID], [t].[UserAgreementAccepted], [t].[UserCreatedID], [t].[UserModifiedID], [t].[UserName], [t].[ID0], [t].[BundlePath], [t].[CultureCode], [t].[DateCreated0], [t].[DateModified0], [t].[Description], [t].[IconName], [t].[ImagePath], [t].[IsoCode], [t].[MobileBundlePath], [t].[MobileTeamBundlePath], [t].[Name], [t].[PanelBundlePath], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t0].[ID], [t0].[DateCreated], [t0].[DateModified], [t0].[RoleID], [t0].[StatusID], [t0].[UserCreatedID], [t0].[UserID], [t0].[UserModifiedID], [t0].[ID0], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Name], [t0].[StatusID0], [t0].[SystemUserTypeID], [t0].[UserCreatedID0], [t0].[UserModifiedID0]
FROM (
SELECT TOP(1) [u].[ID], [u].[AddressID], [u].[AllowedToCommunicate], [u].[DateCreated], [u].[DateModified], [u].[EmailAddress], [u].[FirstName], [u].[FullName], [u].[IdentityNumber], [u].[IntegrationCode], [u].[IsGlobalAdmin], [u].[LanguageID], [u].[LastMobileAppID], [u].[LastMobileLoginDate], [u].[LastName], [u].[LastPasswordModifiedDate], [u].[LastWebLoginDate], [u].[LoggedInBefore], [u].[Password], [u].[PasswordSalt], [u].[PersonnelCode], [u].[PhoneNumber], [u].[ProfileImagePath], [u].[StatusID], [u].[UserAgreementAccepted], [u].[UserCreatedID], [u].[UserModifiedID], [u].[UserName], [l].[ID] AS [ID0], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated] AS [DateCreated0], [l].[DateModified] AS [DateModified0], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID] AS [StatusID0], [l].[UserCreatedID] AS [UserCreatedID0], [l].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[User] AS [u]
INNER JOIN [Definition].[Language] AS [l] ON [u].[LanguageID] = [l].[ID]
WHERE [u].[StatusID] <> @__DeletedStatusID_0 AND [u].[ID] = @__ID_1
ORDER BY [u].[ID] DESC
) AS [t]
LEFT JOIN (
SELECT [u0].[ID], [u0].[DateCreated], [u0].[DateModified], [u0].[RoleID], [u0].[StatusID], [u0].[UserCreatedID], [u0].[UserID], [u0].[UserModifiedID], [r].[ID] AS [ID0], [r].[DateCreated] AS [DateCreated0], [r].[DateModified] AS [DateModified0], [r].[Name], [r].[StatusID] AS [StatusID0], [r].[SystemUserTypeID], [r].[UserCreatedID] AS [UserCreatedID0], [r].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[UserRole] AS [u0]
INNER JOIN [Membership].[Role] AS [r] ON [u0].[RoleID] = [r].[ID]
) AS [t0] ON [t].[ID] = [t0].[UserID]
ORDER BY [t].[ID] DESC, [t].[ID0], [t0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64), @__p_2='?' (DbType = Int32), @__p_3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[DataValue], [t].[DateCreated], [t].[DateModified], [t].[EmailBody], [t].[EmailSubject], [t].[EntityID], [t].[EntityType], [t].[LanguageID], [t].[MobilePushNotificationText], [t].[MobilePushNotificationTitle], [t].[MobilePushNotificationType], [t].[PushNotificationTemplateID], [t].[SMSText], [t].[SendDesktopPushNotification], [t].[SendEmail], [t].[SendMobilePushNotification], [t].[SendSMS], [t].[StatusID], [t].[SubEntityID], [t].[SubEntityType], [t].[UserCreatedID], [t].[UserModifiedID], [t].[WebPushNotificationURL], [l].[ID], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated], [l].[DateModified], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID], [l].[UserCreatedID], [l].[UserModifiedID], [t].[ID0], [p1].[ID], [p1].[DateCreated], [p1].[DateModified], [p1].[EmailBody], [p1].[EmailSubject], [p1].[LanguageID], [p1].[MobilePushNotificationText], [p1].[MobilePushNotificationTitle], [p1].[PushNotificationID], [p1].[SMSText], [p1].[StatusID], [p1].[UserCreatedID], [p1].[UserModifiedID], [t].[Code], [t].[DateCreated0], [t].[DateModified0], [t].[EmailBody0], [t].[EmailSubject0], [t].[MobilePushNotificationText0], [t].[MobilePushNotificationTitle0], [t].[MobilePushNotificationType0], [t].[SMSText0], [t].[SendEmail0], [t].[SendSMS0], [t].[SendToDesktopPushNotification], [t].[SendToMobilePushNotification], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t].[WebPushNotificationURL0], [p2].[ID], [p2].[DateCreated], [p2].[DateModified], [p2].[EmailBody], [p2].[EmailSubject], [p2].[LanguageID], [p2].[MobilePushNotificationText], [p2].[MobilePushNotificationTitle], [p2].[MobilePushNotificationType], [p2].[PushNotificationTemplateID], [p2].[SMSText], [p2].[StatusID], [p2].[UserCreatedID], [p2].[UserModifiedID]
FROM (
SELECT [p].[ID], [p].[DataValue], [p].[DateCreated], [p].[DateModified], [p].[EmailBody], [p].[EmailSubject], [p].[EntityID], [p].[EntityType], [p].[LanguageID], [p].[MobilePushNotificationText], [p].[MobilePushNotificationTitle], [p].[MobilePushNotificationType], [p].[PushNotificationTemplateID], [p].[SMSText], [p].[SendDesktopPushNotification], [p].[SendEmail], [p].[SendMobilePushNotification], [p].[SendSMS], [p].[StatusID], [p].[SubEntityID], [p].[SubEntityType], [p].[UserCreatedID], [p].[UserModifiedID], [p].[WebPushNotificationURL], [p0].[ID] AS [ID0], [p0].[Code], [p0].[DateCreated] AS [DateCreated0], [p0].[DateModified] AS [DateModified0], [p0].[EmailBody] AS [EmailBody0], [p0].[EmailSubject] AS [EmailSubject0], [p0].[MobilePushNotificationText] AS [MobilePushNotificationText0], [p0].[MobilePushNotificationTitle] AS [MobilePushNotificationTitle0], [p0].[MobilePushNotificationType] AS [MobilePushNotificationType0], [p0].[SMSText] AS [SMSText0], [p0].[SendEmail] AS [SendEmail0], [p0].[SendSMS] AS [SendSMS0], [p0].[SendToDesktopPushNotification], [p0].[SendToMobilePushNotification], [p0].[StatusID] AS [StatusID0], [p0].[UserCreatedID] AS [UserCreatedID0], [p0].[UserModifiedID] AS [UserModifiedID0], [p0].[WebPushNotificationURL] AS [WebPushNotificationURL0]
FROM [Communication].[PushNotification] AS [p]
LEFT JOIN [Communication].[PushNotificationTemplate] AS [p0] ON [p].[PushNotificationTemplateID] = [p0].[ID]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1 AND [p0].[Code] = N'NotLoggedIn' AND [p].[SendDesktopPushNotification] = CAST(1 AS bit)
ORDER BY [p].[ID] DESC
OFFSET @__p_2 ROWS FETCH NEXT @__p_3 ROWS ONLY
) AS [t]
INNER JOIN [Definition].[Language] AS [l] ON [t].[LanguageID] = [l].[ID]
LEFT JOIN [Communication].[PushNotification_i18n] AS [p1] ON [t].[ID] = [p1].[PushNotificationID]
LEFT JOIN [Communication].[PushNotificationTemplate_i18n] AS [p2] ON [t].[ID0] = [p2].[PushNotificationTemplateID]
ORDER BY [t].[ID] DESC, [t].[ID0], [l].[ID], [p1].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[PropertyDetailItem] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' ...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ActiveStatusID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [Content].[Package] AS [p]
WHERE [p].[StatusID] <> @__DeletedStatusID_0 AND [p].[StatusID] = @__ActiveStatusID_1 AND [p].[IsPopularPackage] = CAST(1 AS bit)
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = In...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[AddressID], [t].[AllowedToCommunicate], [t].[DateCreated], [t].[DateModified], [t].[EmailAddress], [t].[FirstName], [t].[FullName], [t].[IdentityNumber], [t].[IntegrationCode], [t].[IsGlobalAdmin], [t].[LanguageID], [t].[LastMobileAppID], [t].[LastMobileLoginDate], [t].[LastName], [t].[LastPasswordModifiedDate], [t].[LastWebLoginDate], [t].[LoggedInBefore], [t].[Password], [t].[PasswordSalt], [t].[PersonnelCode], [t].[PhoneNumber], [t].[ProfileImagePath], [t].[StatusID], [t].[UserAgreementAccepted], [t].[UserCreatedID], [t].[UserModifiedID], [t].[UserName], [t].[ID0], [t].[BundlePath], [t].[CultureCode], [t].[DateCreated0], [t].[DateModified0], [t].[Description], [t].[IconName], [t].[ImagePath], [t].[IsoCode], [t].[MobileBundlePath], [t].[MobileTeamBundlePath], [t].[Name], [t].[PanelBundlePath], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t0].[ID], [t0].[DateCreated], [t0].[DateModified], [t0].[RoleID], [t0].[StatusID], [t0].[UserCreatedID], [t0].[UserID], [t0].[UserModifiedID], [t0].[ID0], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Name], [t0].[StatusID0], [t0].[SystemUserTypeID], [t0].[UserCreatedID0], [t0].[UserModifiedID0]
FROM (
SELECT TOP(1) [u].[ID], [u].[AddressID], [u].[AllowedToCommunicate], [u].[DateCreated], [u].[DateModified], [u].[EmailAddress], [u].[FirstName], [u].[FullName], [u].[IdentityNumber], [u].[IntegrationCode], [u].[IsGlobalAdmin], [u].[LanguageID], [u].[LastMobileAppID], [u].[LastMobileLoginDate], [u].[LastName], [u].[LastPasswordModifiedDate], [u].[LastWebLoginDate], [u].[LoggedInBefore], [u].[Password], [u].[PasswordSalt], [u].[PersonnelCode], [u].[PhoneNumber], [u].[ProfileImagePath], [u].[StatusID], [u].[UserAgreementAccepted], [u].[UserCreatedID], [u].[UserModifiedID], [u].[UserName], [l].[ID] AS [ID0], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated] AS [DateCreated0], [l].[DateModified] AS [DateModified0], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID] AS [StatusID0], [l].[UserCreatedID] AS [UserCreatedID0], [l].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[User] AS [u]
INNER JOIN [Definition].[Language] AS [l] ON [u].[LanguageID] = [l].[ID]
WHERE [u].[StatusID] <> @__DeletedStatusID_0 AND [u].[ID] = @__ID_1
ORDER BY [u].[ID] DESC
) AS [t]
LEFT JOIN (
SELECT [u0].[ID], [u0].[DateCreated], [u0].[DateModified], [u0].[RoleID], [u0].[StatusID], [u0].[UserCreatedID], [u0].[UserID], [u0].[UserModifiedID], [r].[ID] AS [ID0], [r].[DateCreated] AS [DateCreated0], [r].[DateModified] AS [DateModified0], [r].[Name], [r].[StatusID] AS [StatusID0], [r].[SystemUserTypeID], [r].[UserCreatedID] AS [UserCreatedID0], [r].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[UserRole] AS [u0]
INNER JOIN [Membership].[Role] AS [r] ON [u0].[RoleID] = [r].[ID]
) AS [t0] ON [t].[ID] = [t0].[UserID]
ORDER BY [t].[ID] DESC, [t].[ID0], [t0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = In...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[AddressID], [t].[AllowedToCommunicate], [t].[DateCreated], [t].[DateModified], [t].[EmailAddress], [t].[FirstName], [t].[FullName], [t].[IdentityNumber], [t].[IntegrationCode], [t].[IsGlobalAdmin], [t].[LanguageID], [t].[LastMobileAppID], [t].[LastMobileLoginDate], [t].[LastName], [t].[LastPasswordModifiedDate], [t].[LastWebLoginDate], [t].[LoggedInBefore], [t].[Password], [t].[PasswordSalt], [t].[PersonnelCode], [t].[PhoneNumber], [t].[ProfileImagePath], [t].[StatusID], [t].[UserAgreementAccepted], [t].[UserCreatedID], [t].[UserModifiedID], [t].[UserName], [t].[ID0], [t].[BundlePath], [t].[CultureCode], [t].[DateCreated0], [t].[DateModified0], [t].[Description], [t].[IconName], [t].[ImagePath], [t].[IsoCode], [t].[MobileBundlePath], [t].[MobileTeamBundlePath], [t].[Name], [t].[PanelBundlePath], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t0].[ID], [t0].[DateCreated], [t0].[DateModified], [t0].[RoleID], [t0].[StatusID], [t0].[UserCreatedID], [t0].[UserID], [t0].[UserModifiedID], [t0].[ID0], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Name], [t0].[StatusID0], [t0].[SystemUserTypeID], [t0].[UserCreatedID0], [t0].[UserModifiedID0]
FROM (
SELECT TOP(1) [u].[ID], [u].[AddressID], [u].[AllowedToCommunicate], [u].[DateCreated], [u].[DateModified], [u].[EmailAddress], [u].[FirstName], [u].[FullName], [u].[IdentityNumber], [u].[IntegrationCode], [u].[IsGlobalAdmin], [u].[LanguageID], [u].[LastMobileAppID], [u].[LastMobileLoginDate], [u].[LastName], [u].[LastPasswordModifiedDate], [u].[LastWebLoginDate], [u].[LoggedInBefore], [u].[Password], [u].[PasswordSalt], [u].[PersonnelCode], [u].[PhoneNumber], [u].[ProfileImagePath], [u].[StatusID], [u].[UserAgreementAccepted], [u].[UserCreatedID], [u].[UserModifiedID], [u].[UserName], [l].[ID] AS [ID0], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated] AS [DateCreated0], [l].[DateModified] AS [DateModified0], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID] AS [StatusID0], [l].[UserCreatedID] AS [UserCreatedID0], [l].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[User] AS [u]
INNER JOIN [Definition].[Language] AS [l] ON [u].[LanguageID] = [l].[ID]
WHERE [u].[StatusID] <> @__DeletedStatusID_0 AND [u].[ID] = @__ID_1
ORDER BY [u].[ID] DESC
) AS [t]
LEFT JOIN (
SELECT [u0].[ID], [u0].[DateCreated], [u0].[DateModified], [u0].[RoleID], [u0].[StatusID], [u0].[UserCreatedID], [u0].[UserID], [u0].[UserModifiedID], [r].[ID] AS [ID0], [r].[DateCreated] AS [DateCreated0], [r].[DateModified] AS [DateModified0], [r].[Name], [r].[StatusID] AS [StatusID0], [r].[SystemUserTypeID], [r].[UserCreatedID] AS [UserCreatedID0], [r].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[UserRole] AS [u0]
INNER JOIN [Membership].[Role] AS [r] ON [u0].[RoleID] = [r].[ID]
) AS [t0] ON [t].[ID] = [t0].[UserID]
ORDER BY [t].[ID] DESC, [t].[ID0], [t0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = In...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[AddressID], [t].[AllowedToCommunicate], [t].[DateCreated], [t].[DateModified], [t].[EmailAddress], [t].[FirstName], [t].[FullName], [t].[IdentityNumber], [t].[IntegrationCode], [t].[IsGlobalAdmin], [t].[LanguageID], [t].[LastMobileAppID], [t].[LastMobileLoginDate], [t].[LastName], [t].[LastPasswordModifiedDate], [t].[LastWebLoginDate], [t].[LoggedInBefore], [t].[Password], [t].[PasswordSalt], [t].[PersonnelCode], [t].[PhoneNumber], [t].[ProfileImagePath], [t].[StatusID], [t].[UserAgreementAccepted], [t].[UserCreatedID], [t].[UserModifiedID], [t].[UserName], [t].[ID0], [t].[BundlePath], [t].[CultureCode], [t].[DateCreated0], [t].[DateModified0], [t].[Description], [t].[IconName], [t].[ImagePath], [t].[IsoCode], [t].[MobileBundlePath], [t].[MobileTeamBundlePath], [t].[Name], [t].[PanelBundlePath], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t0].[ID], [t0].[DateCreated], [t0].[DateModified], [t0].[RoleID], [t0].[StatusID], [t0].[UserCreatedID], [t0].[UserID], [t0].[UserModifiedID], [t0].[ID0], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Name], [t0].[StatusID0], [t0].[SystemUserTypeID], [t0].[UserCreatedID0], [t0].[UserModifiedID0]
FROM (
SELECT TOP(1) [u].[ID], [u].[AddressID], [u].[AllowedToCommunicate], [u].[DateCreated], [u].[DateModified], [u].[EmailAddress], [u].[FirstName], [u].[FullName], [u].[IdentityNumber], [u].[IntegrationCode], [u].[IsGlobalAdmin], [u].[LanguageID], [u].[LastMobileAppID], [u].[LastMobileLoginDate], [u].[LastName], [u].[LastPasswordModifiedDate], [u].[LastWebLoginDate], [u].[LoggedInBefore], [u].[Password], [u].[PasswordSalt], [u].[PersonnelCode], [u].[PhoneNumber], [u].[ProfileImagePath], [u].[StatusID], [u].[UserAgreementAccepted], [u].[UserCreatedID], [u].[UserModifiedID], [u].[UserName], [l].[ID] AS [ID0], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated] AS [DateCreated0], [l].[DateModified] AS [DateModified0], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID] AS [StatusID0], [l].[UserCreatedID] AS [UserCreatedID0], [l].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[User] AS [u]
INNER JOIN [Definition].[Language] AS [l] ON [u].[LanguageID] = [l].[ID]
WHERE [u].[StatusID] <> @__DeletedStatusID_0 AND [u].[ID] = @__ID_1
ORDER BY [u].[ID] DESC
) AS [t]
LEFT JOIN (
SELECT [u0].[ID], [u0].[DateCreated], [u0].[DateModified], [u0].[RoleID], [u0].[StatusID], [u0].[UserCreatedID], [u0].[UserID], [u0].[UserModifiedID], [r].[ID] AS [ID0], [r].[DateCreated] AS [DateCreated0], [r].[DateModified] AS [DateModified0], [r].[Name], [r].[StatusID] AS [StatusID0], [r].[SystemUserTypeID], [r].[UserCreatedID] AS [UserCreatedID0], [r].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[UserRole] AS [u0]
INNER JOIN [Membership].[Role] AS [r] ON [u0].[RoleID] = [r].[ID]
) AS [t0] ON [t].[ID] = [t0].[UserID]
ORDER BY [t].[ID] DESC, [t].[ID0], [t0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = In...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[AddressID], [t].[AllowedToCommunicate], [t].[DateCreated], [t].[DateModified], [t].[EmailAddress], [t].[FirstName], [t].[FullName], [t].[IdentityNumber], [t].[IntegrationCode], [t].[IsGlobalAdmin], [t].[LanguageID], [t].[LastMobileAppID], [t].[LastMobileLoginDate], [t].[LastName], [t].[LastPasswordModifiedDate], [t].[LastWebLoginDate], [t].[LoggedInBefore], [t].[Password], [t].[PasswordSalt], [t].[PersonnelCode], [t].[PhoneNumber], [t].[ProfileImagePath], [t].[StatusID], [t].[UserAgreementAccepted], [t].[UserCreatedID], [t].[UserModifiedID], [t].[UserName], [t].[ID0], [t].[BundlePath], [t].[CultureCode], [t].[DateCreated0], [t].[DateModified0], [t].[Description], [t].[IconName], [t].[ImagePath], [t].[IsoCode], [t].[MobileBundlePath], [t].[MobileTeamBundlePath], [t].[Name], [t].[PanelBundlePath], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t0].[ID], [t0].[DateCreated], [t0].[DateModified], [t0].[RoleID], [t0].[StatusID], [t0].[UserCreatedID], [t0].[UserID], [t0].[UserModifiedID], [t0].[ID0], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Name], [t0].[StatusID0], [t0].[SystemUserTypeID], [t0].[UserCreatedID0], [t0].[UserModifiedID0]
FROM (
SELECT TOP(1) [u].[ID], [u].[AddressID], [u].[AllowedToCommunicate], [u].[DateCreated], [u].[DateModified], [u].[EmailAddress], [u].[FirstName], [u].[FullName], [u].[IdentityNumber], [u].[IntegrationCode], [u].[IsGlobalAdmin], [u].[LanguageID], [u].[LastMobileAppID], [u].[LastMobileLoginDate], [u].[LastName], [u].[LastPasswordModifiedDate], [u].[LastWebLoginDate], [u].[LoggedInBefore], [u].[Password], [u].[PasswordSalt], [u].[PersonnelCode], [u].[PhoneNumber], [u].[ProfileImagePath], [u].[StatusID], [u].[UserAgreementAccepted], [u].[UserCreatedID], [u].[UserModifiedID], [u].[UserName], [l].[ID] AS [ID0], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated] AS [DateCreated0], [l].[DateModified] AS [DateModified0], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID] AS [StatusID0], [l].[UserCreatedID] AS [UserCreatedID0], [l].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[User] AS [u]
INNER JOIN [Definition].[Language] AS [l] ON [u].[LanguageID] = [l].[ID]
WHERE [u].[StatusID] <> @__DeletedStatusID_0 AND [u].[ID] = @__ID_1
ORDER BY [u].[ID] DESC
) AS [t]
LEFT JOIN (
SELECT [u0].[ID], [u0].[DateCreated], [u0].[DateModified], [u0].[RoleID], [u0].[StatusID], [u0].[UserCreatedID], [u0].[UserID], [u0].[UserModifiedID], [r].[ID] AS [ID0], [r].[DateCreated] AS [DateCreated0], [r].[DateModified] AS [DateModified0], [r].[Name], [r].[StatusID] AS [StatusID0], [r].[SystemUserTypeID], [r].[UserCreatedID] AS [UserCreatedID0], [r].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[UserRole] AS [u0]
INNER JOIN [Membership].[Role] AS [r] ON [u0].[RoleID] = [r].[ID]
) AS [t0] ON [t].[ID] = [t0].[UserID]
ORDER BY [t].[ID] DESC, [t].[ID0], [t0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = In...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[AddressID], [t].[AllowedToCommunicate], [t].[DateCreated], [t].[DateModified], [t].[EmailAddress], [t].[FirstName], [t].[FullName], [t].[IdentityNumber], [t].[IntegrationCode], [t].[IsGlobalAdmin], [t].[LanguageID], [t].[LastMobileAppID], [t].[LastMobileLoginDate], [t].[LastName], [t].[LastPasswordModifiedDate], [t].[LastWebLoginDate], [t].[LoggedInBefore], [t].[Password], [t].[PasswordSalt], [t].[PersonnelCode], [t].[PhoneNumber], [t].[ProfileImagePath], [t].[StatusID], [t].[UserAgreementAccepted], [t].[UserCreatedID], [t].[UserModifiedID], [t].[UserName], [t].[ID0], [t].[BundlePath], [t].[CultureCode], [t].[DateCreated0], [t].[DateModified0], [t].[Description], [t].[IconName], [t].[ImagePath], [t].[IsoCode], [t].[MobileBundlePath], [t].[MobileTeamBundlePath], [t].[Name], [t].[PanelBundlePath], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t0].[ID], [t0].[DateCreated], [t0].[DateModified], [t0].[RoleID], [t0].[StatusID], [t0].[UserCreatedID], [t0].[UserID], [t0].[UserModifiedID], [t0].[ID0], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Name], [t0].[StatusID0], [t0].[SystemUserTypeID], [t0].[UserCreatedID0], [t0].[UserModifiedID0]
FROM (
SELECT TOP(1) [u].[ID], [u].[AddressID], [u].[AllowedToCommunicate], [u].[DateCreated], [u].[DateModified], [u].[EmailAddress], [u].[FirstName], [u].[FullName], [u].[IdentityNumber], [u].[IntegrationCode], [u].[IsGlobalAdmin], [u].[LanguageID], [u].[LastMobileAppID], [u].[LastMobileLoginDate], [u].[LastName], [u].[LastPasswordModifiedDate], [u].[LastWebLoginDate], [u].[LoggedInBefore], [u].[Password], [u].[PasswordSalt], [u].[PersonnelCode], [u].[PhoneNumber], [u].[ProfileImagePath], [u].[StatusID], [u].[UserAgreementAccepted], [u].[UserCreatedID], [u].[UserModifiedID], [u].[UserName], [l].[ID] AS [ID0], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated] AS [DateCreated0], [l].[DateModified] AS [DateModified0], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID] AS [StatusID0], [l].[UserCreatedID] AS [UserCreatedID0], [l].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[User] AS [u]
INNER JOIN [Definition].[Language] AS [l] ON [u].[LanguageID] = [l].[ID]
WHERE [u].[StatusID] <> @__DeletedStatusID_0 AND [u].[ID] = @__ID_1
ORDER BY [u].[ID] DESC
) AS [t]
LEFT JOIN (
SELECT [u0].[ID], [u0].[DateCreated], [u0].[DateModified], [u0].[RoleID], [u0].[StatusID], [u0].[UserCreatedID], [u0].[UserID], [u0].[UserModifiedID], [r].[ID] AS [ID0], [r].[DateCreated] AS [DateCreated0], [r].[DateModified] AS [DateModified0], [r].[Name], [r].[StatusID] AS [StatusID0], [r].[SystemUserTypeID], [r].[UserCreatedID] AS [UserCreatedID0], [r].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[UserRole] AS [u0]
INNER JOIN [Membership].[Role] AS [r] ON [u0].[RoleID] = [r].[ID]
) AS [t0] ON [t].[ID] = [t0].[UserID]
ORDER BY [t].[ID] DESC, [t].[ID0], [t0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = In...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[AddressID], [t].[AllowedToCommunicate], [t].[DateCreated], [t].[DateModified], [t].[EmailAddress], [t].[FirstName], [t].[FullName], [t].[IdentityNumber], [t].[IntegrationCode], [t].[IsGlobalAdmin], [t].[LanguageID], [t].[LastMobileAppID], [t].[LastMobileLoginDate], [t].[LastName], [t].[LastPasswordModifiedDate], [t].[LastWebLoginDate], [t].[LoggedInBefore], [t].[Password], [t].[PasswordSalt], [t].[PersonnelCode], [t].[PhoneNumber], [t].[ProfileImagePath], [t].[StatusID], [t].[UserAgreementAccepted], [t].[UserCreatedID], [t].[UserModifiedID], [t].[UserName], [t].[ID0], [t].[BundlePath], [t].[CultureCode], [t].[DateCreated0], [t].[DateModified0], [t].[Description], [t].[IconName], [t].[ImagePath], [t].[IsoCode], [t].[MobileBundlePath], [t].[MobileTeamBundlePath], [t].[Name], [t].[PanelBundlePath], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t0].[ID], [t0].[DateCreated], [t0].[DateModified], [t0].[RoleID], [t0].[StatusID], [t0].[UserCreatedID], [t0].[UserID], [t0].[UserModifiedID], [t0].[ID0], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Name], [t0].[StatusID0], [t0].[SystemUserTypeID], [t0].[UserCreatedID0], [t0].[UserModifiedID0]
FROM (
SELECT TOP(1) [u].[ID], [u].[AddressID], [u].[AllowedToCommunicate], [u].[DateCreated], [u].[DateModified], [u].[EmailAddress], [u].[FirstName], [u].[FullName], [u].[IdentityNumber], [u].[IntegrationCode], [u].[IsGlobalAdmin], [u].[LanguageID], [u].[LastMobileAppID], [u].[LastMobileLoginDate], [u].[LastName], [u].[LastPasswordModifiedDate], [u].[LastWebLoginDate], [u].[LoggedInBefore], [u].[Password], [u].[PasswordSalt], [u].[PersonnelCode], [u].[PhoneNumber], [u].[ProfileImagePath], [u].[StatusID], [u].[UserAgreementAccepted], [u].[UserCreatedID], [u].[UserModifiedID], [u].[UserName], [l].[ID] AS [ID0], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated] AS [DateCreated0], [l].[DateModified] AS [DateModified0], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID] AS [StatusID0], [l].[UserCreatedID] AS [UserCreatedID0], [l].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[User] AS [u]
INNER JOIN [Definition].[Language] AS [l] ON [u].[LanguageID] = [l].[ID]
WHERE [u].[StatusID] <> @__DeletedStatusID_0 AND [u].[ID] = @__ID_1
ORDER BY [u].[ID] DESC
) AS [t]
LEFT JOIN (
SELECT [u0].[ID], [u0].[DateCreated], [u0].[DateModified], [u0].[RoleID], [u0].[StatusID], [u0].[UserCreatedID], [u0].[UserID], [u0].[UserModifiedID], [r].[ID] AS [ID0], [r].[DateCreated] AS [DateCreated0], [r].[DateModified] AS [DateModified0], [r].[Name], [r].[StatusID] AS [StatusID0], [r].[SystemUserTypeID], [r].[UserCreatedID] AS [UserCreatedID0], [r].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[UserRole] AS [u0]
INNER JOIN [Membership].[Role] AS [r] ON [u0].[RoleID] = [r].[ID]
) AS [t0] ON [t].[ID] = [t0].[UserID]
ORDER BY [t].[ID] DESC, [t].[ID0], [t0].[ID]
|
1ms |
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = In...more
Executing DbCommand [Parameters=[@__DeletedStatusID_0='?' (DbType = Int64), @__ID_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [t].[ID], [t].[AddressID], [t].[AllowedToCommunicate], [t].[DateCreated], [t].[DateModified], [t].[EmailAddress], [t].[FirstName], [t].[FullName], [t].[IdentityNumber], [t].[IntegrationCode], [t].[IsGlobalAdmin], [t].[LanguageID], [t].[LastMobileAppID], [t].[LastMobileLoginDate], [t].[LastName], [t].[LastPasswordModifiedDate], [t].[LastWebLoginDate], [t].[LoggedInBefore], [t].[Password], [t].[PasswordSalt], [t].[PersonnelCode], [t].[PhoneNumber], [t].[ProfileImagePath], [t].[StatusID], [t].[UserAgreementAccepted], [t].[UserCreatedID], [t].[UserModifiedID], [t].[UserName], [t].[ID0], [t].[BundlePath], [t].[CultureCode], [t].[DateCreated0], [t].[DateModified0], [t].[Description], [t].[IconName], [t].[ImagePath], [t].[IsoCode], [t].[MobileBundlePath], [t].[MobileTeamBundlePath], [t].[Name], [t].[PanelBundlePath], [t].[StatusID0], [t].[UserCreatedID0], [t].[UserModifiedID0], [t0].[ID], [t0].[DateCreated], [t0].[DateModified], [t0].[RoleID], [t0].[StatusID], [t0].[UserCreatedID], [t0].[UserID], [t0].[UserModifiedID], [t0].[ID0], [t0].[DateCreated0], [t0].[DateModified0], [t0].[Name], [t0].[StatusID0], [t0].[SystemUserTypeID], [t0].[UserCreatedID0], [t0].[UserModifiedID0]
FROM (
SELECT TOP(1) [u].[ID], [u].[AddressID], [u].[AllowedToCommunicate], [u].[DateCreated], [u].[DateModified], [u].[EmailAddress], [u].[FirstName], [u].[FullName], [u].[IdentityNumber], [u].[IntegrationCode], [u].[IsGlobalAdmin], [u].[LanguageID], [u].[LastMobileAppID], [u].[LastMobileLoginDate], [u].[LastName], [u].[LastPasswordModifiedDate], [u].[LastWebLoginDate], [u].[LoggedInBefore], [u].[Password], [u].[PasswordSalt], [u].[PersonnelCode], [u].[PhoneNumber], [u].[ProfileImagePath], [u].[StatusID], [u].[UserAgreementAccepted], [u].[UserCreatedID], [u].[UserModifiedID], [u].[UserName], [l].[ID] AS [ID0], [l].[BundlePath], [l].[CultureCode], [l].[DateCreated] AS [DateCreated0], [l].[DateModified] AS [DateModified0], [l].[Description], [l].[IconName], [l].[ImagePath], [l].[IsoCode], [l].[MobileBundlePath], [l].[MobileTeamBundlePath], [l].[Name], [l].[PanelBundlePath], [l].[StatusID] AS [StatusID0], [l].[UserCreatedID] AS [UserCreatedID0], [l].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[User] AS [u]
INNER JOIN [Definition].[Language] AS [l] ON [u].[LanguageID] = [l].[ID]
WHERE [u].[StatusID] <> @__DeletedStatusID_0 AND [u].[ID] = @__ID_1
ORDER BY [u].[ID] DESC
) AS [t]
LEFT JOIN (
SELECT [u0].[ID], [u0].[DateCreated], [u0].[DateModified], [u0].[RoleID], [u0].[StatusID], [u0].[UserCreatedID], [u0].[UserID], [u0].[UserModifiedID], [r].[ID] AS [ID0], [r].[DateCreated] AS [DateCreated0], [r].[DateModified] AS [DateModified0], [r].[Name], [r].[StatusID] AS [StatusID0], [r].[SystemUserTypeID], [r].[UserCreatedID] AS [UserCreatedID0], [r].[UserModifiedID] AS [UserModifiedID0]
FROM [Membership].[UserRole] AS [u0]
INNER JOIN [Membership].[Role] AS [r] ON [u0].[RoleID] = [r].[ID]
) AS [t0] ON [t].[ID] = [t0].[UserID]
ORDER BY [t].[ID] DESC, [t].[ID0], [t0].[ID]
|