SELECT TOP (90)
    [Project1].[Id] AS [Id],
    [Project1].[ExternalId] AS [ExternalId],
    [Project1].[SkuAvailability] AS [SkuAvailability],
    [Project1].[Colour] AS [Colour],
    [Project1].[SIZE] AS [SIZE],
    [Project1].[GenderId] AS [GenderId],
    [Project1].[ManufacturerId] AS [ManufacturerId],
    [Project1].[ProductTypeId] AS [ProductTypeId],
    [Project1].[ParentGroupedProductId] AS [ParentGroupedProductId],
    [Project1].[VisibleIndividually] AS [VisibleIndividually],
    [Project1].[Name] AS [Name],
    [Project1].[ShortDescription] AS [ShortDescription],
    [Project1].[FullDescription] AS [FullDescription],
    [Project1].[AdminComment] AS [AdminComment],
    [Project1].[ProductTemplateId] AS [ProductTemplateId],
    [Project1].[VendorId] AS [VendorId],
    [Project1].[ShowOnHomePage] AS [ShowOnHomePage],
    [Project1].[MetaKeywords] AS [MetaKeywords],
    [Project1].[MetaDescription] AS [MetaDescription],
    [Project1].[MetaTitle] AS [MetaTitle],
    [Project1].[AllowCustomerReviews] AS [AllowCustomerReviews],
    [Project1].[ApprovedRatingSum] AS [ApprovedRatingSum],
    [Project1].[NotApprovedRatingSum] AS [NotApprovedRatingSum],
    [Project1].[ApprovedTotalReviews] AS [ApprovedTotalReviews],
    [Project1].[NotApprovedTotalReviews] AS [NotApprovedTotalReviews],
    [Project1].[SubjectToAcl] AS [SubjectToAcl],
    [Project1].[LimitedToStores] AS [LimitedToStores],
    [Project1].[Sku] AS [Sku],
    [Project1].[ManufacturerPartNumber] AS [ManufacturerPartNumber],
    [Project1].[Gtin] AS [Gtin],
    [Project1].[IsGiftCard] AS [IsGiftCard],
    [Project1].[GiftCardTypeId] AS [GiftCardTypeId],
    [Project1].[RequireOtherProducts] AS [RequireOtherProducts],
    [Project1].[RequiredProductIds] AS [RequiredProductIds],
    [Project1].[AutomaticallyAddRequiredProducts] AS [AutomaticallyAddRequiredProducts],
    [Project1].[IsDownload] AS [IsDownload],
    [Project1].[DownloadId] AS [DownloadId],
    [Project1].[UnlimitedDownloads] AS [UnlimitedDownloads],
    [Project1].[MaxNumberOfDownloads] AS [MaxNumberOfDownloads],
    [Project1].[DownloadExpirationDays] AS [DownloadExpirationDays],
    [Project1].[DownloadActivationTypeId] AS [DownloadActivationTypeId],
    [Project1].[HasSampleDownload] AS [HasSampleDownload],
    [Project1].[SampleDownloadId] AS [SampleDownloadId],
    [Project1].[HasUserAgreement] AS [HasUserAgreement],
    [Project1].[UserAgreementText] AS [UserAgreementText],
    [Project1].[IsRecurring] AS [IsRecurring],
    [Project1].[RecurringCycleLength] AS [RecurringCycleLength],
    [Project1].[RecurringCyclePeriodId] AS [RecurringCyclePeriodId],
    [Project1].[RecurringTotalCycles] AS [RecurringTotalCycles],
    [Project1].[IsShipEnabled] AS [IsShipEnabled],
    [Project1].[IsFreeShipping] AS [IsFreeShipping],
    [Project1].[AdditionalShippingCharge] AS [AdditionalShippingCharge],
    [Project1].[DeliveryDateId] AS [DeliveryDateId],
    [Project1].[WarehouseId] AS [WarehouseId],
    [Project1].[IsTaxExempt] AS [IsTaxExempt],
    [Project1].[TaxCategoryId] AS [TaxCategoryId],
    [Project1].[ManageInventoryMethodId] AS [ManageInventoryMethodId],
    [Project1].[StockQuantity] AS [StockQuantity],
    [Project1].[DisplayStockAvailability] AS [DisplayStockAvailability],
    [Project1].[DisplayStockQuantity] AS [DisplayStockQuantity],
    [Project1].[MinStockQuantity] AS [MinStockQuantity],
    [Project1].[LowStockActivityId] AS [LowStockActivityId],
    [Project1].[NotifyAdminForQuantityBelow] AS [NotifyAdminForQuantityBelow],
    [Project1].[BackorderModeId] AS [BackorderModeId],
    [Project1].[AllowBackInStockSubscriptions] AS [AllowBackInStockSubscriptions],
    [Project1].[OrderMinimumQuantity] AS [OrderMinimumQuantity],
    [Project1].[OrderMaximumQuantity] AS [OrderMaximumQuantity],
    [Project1].[AllowedQuantities] AS [AllowedQuantities],
    [Project1].[AllowAddingOnlyExistingAttributeCombinations] AS [AllowAddingOnlyExistingAttributeCombinations],
    [Project1].[DisableBuyButton] AS [DisableBuyButton],
    [Project1].[DisableWishlistButton] AS [DisableWishlistButton],
    [Project1].[AvailableForPreOrder] AS [AvailableForPreOrder],
    [Project1].[PreOrderAvailabilityStartDateTimeUtc] AS [PreOrderAvailabilityStartDateTimeUtc],
    [Project1].[CallForPrice] AS [CallForPrice],
    [Project1].[Price] AS [Price],
    [Project1].[RRP] AS [RRP],
    [Project1].[ProductCost] AS [ProductCost],
    [Project1].[FromPrice] AS [FromPrice],
    [Project1].[ToPrice] AS [ToPrice],
    [Project1].[FromRRP] AS [FromRRP],
    [Project1].[DiscountPercentage] AS [DiscountPercentage],
    [Project1].[SpecialPrice] AS [SpecialPrice],
    [Project1].[SpecialPriceStartDateTimeUtc] AS [SpecialPriceStartDateTimeUtc],
    [Project1].[SpecialPriceEndDateTimeUtc] AS [SpecialPriceEndDateTimeUtc],
    [Project1].[CustomerEntersPrice] AS [CustomerEntersPrice],
    [Project1].[MinimumCustomerEnteredPrice] AS [MinimumCustomerEnteredPrice],
    [Project1].[MaximumCustomerEnteredPrice] AS [MaximumCustomerEnteredPrice],
    [Project1].[HasTierPrices] AS [HasTierPrices],
    [Project1].[HasDiscountsApplied] AS [HasDiscountsApplied],
    [Project1].[Weight] AS [Weight],
    [Project1].[LENGTH] AS [LENGTH],
    [Project1].[Width] AS [Width],
    [Project1].[Height] AS [Height],
    [Project1].[AvailableStartDateTimeUtc] AS [AvailableStartDateTimeUtc],
    [Project1].[AvailableEndDateTimeUtc] AS [AvailableEndDateTimeUtc],
    [Project1].[DisplayOrder] AS [DisplayOrder],
    [Project1].[Published] AS [Published],
    [Project1].[Deleted] AS [Deleted],
    [Project1].[CreatedOnUtc] AS [CreatedOnUtc],
    [Project1].[UpdatedOnUtc] AS [UpdatedOnUtc]
    FROM ( SELECT [Project1].[Id] AS [Id], [Project1].[ExternalId] AS [ExternalId], [Project1].[SkuAvailability] AS [SkuAvailability], [Project1].[Colour] AS [Colour], [Project1].[SIZE] AS [SIZE], [Project1].[GenderId] AS [GenderId], [Project1].[ManufacturerId] AS [ManufacturerId], [Project1].[ProductTypeId] AS [ProductTypeId], [Project1].[ParentGroupedProductId] AS [ParentGroupedProductId], [Project1].[VisibleIndividually] AS [VisibleIndividually], [Project1].[Name] AS [Name], [Project1].[ShortDescription] AS [ShortDescription], [Project1].[FullDescription] AS [FullDescription], [Project1].[AdminComment] AS [AdminComment], [Project1].[ProductTemplateId] AS [ProductTemplateId], [Project1].[VendorId] AS [VendorId], [Project1].[ShowOnHomePage] AS [ShowOnHomePage], [Project1].[MetaKeywords] AS [MetaKeywords], [Project1].[MetaDescription] AS [MetaDescription], [Project1].[MetaTitle] AS [MetaTitle], [Project1].[AllowCustomerReviews] AS [AllowCustomerReviews], [Project1].[ApprovedRatingSum] AS [ApprovedRatingSum], [Project1].[NotApprovedRatingSum] AS [NotApprovedRatingSum], [Project1].[ApprovedTotalReviews] AS [ApprovedTotalReviews], [Project1].[NotApprovedTotalReviews] AS [NotApprovedTotalReviews], [Project1].[SubjectToAcl] AS [SubjectToAcl], [Project1].[LimitedToStores] AS [LimitedToStores], [Project1].[Sku] AS [Sku], [Project1].[ManufacturerPartNumber] AS [ManufacturerPartNumber], [Project1].[Gtin] AS [Gtin], [Project1].[IsGiftCard] AS [IsGiftCard], [Project1].[GiftCardTypeId] AS [GiftCardTypeId], [Project1].[RequireOtherProducts] AS [RequireOtherProducts], [Project1].[RequiredProductIds] AS [RequiredProductIds], [Project1].[AutomaticallyAddRequiredProducts] AS [AutomaticallyAddRequiredProducts], [Project1].[IsDownload] AS [IsDownload], [Project1].[DownloadId] AS [DownloadId], [Project1].[UnlimitedDownloads] AS [UnlimitedDownloads], [Project1].[MaxNumberOfDownloads] AS [MaxNumberOfDownloads], [Project1].[DownloadExpirationDays] AS [DownloadExpirationDays], [Project1].[DownloadActivationTypeId] AS [DownloadActivationTypeId], [Project1].[HasSampleDownload] AS [HasSampleDownload], [Project1].[SampleDownloadId] AS [SampleDownloadId], [Project1].[HasUserAgreement] AS [HasUserAgreement], [Project1].[UserAgreementText] AS [UserAgreementText], [Project1].[IsRecurring] AS [IsRecurring], [Project1].[RecurringCycleLength] AS [RecurringCycleLength], [Project1].[RecurringCyclePeriodId] AS [RecurringCyclePeriodId], [Project1].[RecurringTotalCycles] AS [RecurringTotalCycles], [Project1].[IsShipEnabled] AS [IsShipEnabled], [Project1].[IsFreeShipping] AS [IsFreeShipping], [Project1].[AdditionalShippingCharge] AS [AdditionalShippingCharge], [Project1].[DeliveryDateId] AS [DeliveryDateId], [Project1].[WarehouseId] AS [WarehouseId], [Project1].[IsTaxExempt] AS [IsTaxExempt], [Project1].[TaxCategoryId] AS [TaxCategoryId], [Project1].[ManageInventoryMethodId] AS [ManageInventoryMethodId], [Project1].[StockQuantity] AS [StockQuantity], [Project1].[DisplayStockAvailability] AS [DisplayStockAvailability], [Project1].[DisplayStockQuantity] AS [DisplayStockQuantity], [Project1].[MinStockQuantity] AS [MinStockQuantity], [Project1].[LowStockActivityId] AS [LowStockActivityId], [Project1].[NotifyAdminForQuantityBelow] AS [NotifyAdminForQuantityBelow], [Project1].[BackorderModeId] AS [BackorderModeId], [Project1].[AllowBackInStockSubscriptions] AS [AllowBackInStockSubscriptions], [Project1].[OrderMinimumQuantity] AS [OrderMinimumQuantity], [Project1].[OrderMaximumQuantity] AS [OrderMaximumQuantity], [Project1].[AllowedQuantities] AS [AllowedQuantities], [Project1].[AllowAddingOnlyExistingAttributeCombinations] AS [AllowAddingOnlyExistingAttributeCombinations], [Project1].[DisableBuyButton] AS [DisableBuyButton], [Project1].[DisableWishlistButton] AS [DisableWishlistButton], [Project1].[AvailableForPreOrder] AS [AvailableForPreOrder], [Project1].[PreOrderAvailabilityStartDateTimeUtc] AS [PreOrderAvailabilityStartDateTimeUtc], [Project1].[CallForPrice] AS [CallForPrice], [Project1].[Price] AS [Price], [Project1].[RRP] AS [RRP], [Project1].[ProductCost] AS [ProductCost], [Project1].[FromPrice] AS [FromPrice], [Project1].[ToPrice] AS [ToPrice], [Project1].[FromRRP] AS [FromRRP], [Project1].[DiscountPercentage] AS [DiscountPercentage], [Project1].[SpecialPrice] AS [SpecialPrice], [Project1].[SpecialPriceStartDateTimeUtc] AS [SpecialPriceStartDateTimeUtc], [Project1].[SpecialPriceEndDateTimeUtc] AS [SpecialPriceEndDateTimeUtc], [Project1].[CustomerEntersPrice] AS [CustomerEntersPrice], [Project1].[MinimumCustomerEnteredPrice] AS [MinimumCustomerEnteredPrice], [Project1].[MaximumCustomerEnteredPrice] AS [MaximumCustomerEnteredPrice], [Project1].[HasTierPrices] AS [HasTierPrices], [Project1].[HasDiscountsApplied] AS [HasDiscountsApplied], [Project1].[Weight] AS [Weight], [Project1].[LENGTH] AS [LENGTH], [Project1].[Width] AS [Width], [Project1].[Height] AS [Height], [Project1].[AvailableStartDateTimeUtc] AS [AvailableStartDateTimeUtc], [Project1].[AvailableEndDateTimeUtc] AS [AvailableEndDateTimeUtc], [Project1].[DisplayOrder] AS [DisplayOrder], [Project1].[Published] AS [Published], [Project1].[Deleted] AS [Deleted], [Project1].[CreatedOnUtc] AS [CreatedOnUtc], [Project1].[UpdatedOnUtc] AS [UpdatedOnUtc], ROW_NUMBER() OVER (ORDER BY [Project1].[Name] DESC) AS [ROW_NUMBER]
        FROM ( SELECT
            [Extent1].[Id] AS [Id],
            [Extent1].[ExternalId] AS [ExternalId],
            [Extent1].[SkuAvailability] AS [SkuAvailability],
            [Extent1].[Colour] AS [Colour],
            [Extent1].[SIZE] AS [SIZE],
            [Extent1].[GenderId] AS [GenderId],
            [Extent1].[ManufacturerId] AS [ManufacturerId],
            [Extent1].[ProductTypeId] AS [ProductTypeId],
            [Extent1].[ParentGroupedProductId] AS [ParentGroupedProductId],
            [Extent1].[VisibleIndividually] AS [VisibleIndividually],
            [Extent1].[Name] AS [Name],
            [Extent1].[ShortDescription] AS [ShortDescription],
            [Extent1].[FullDescription] AS [FullDescription],
            [Extent1].[AdminComment] AS [AdminComment],
            [Extent1].[ProductTemplateId] AS [ProductTemplateId],
            [Extent1].[VendorId] AS [VendorId],
            [Extent1].[ShowOnHomePage] AS [ShowOnHomePage],
            [Extent1].[MetaKeywords] AS [MetaKeywords],
            [Extent1].[MetaDescription] AS [MetaDescription],
            [Extent1].[MetaTitle] AS [MetaTitle],
            [Extent1].[AllowCustomerReviews] AS [AllowCustomerReviews],
            [Extent1].[ApprovedRatingSum] AS [ApprovedRatingSum],
            [Extent1].[NotApprovedRatingSum] AS [NotApprovedRatingSum],
            [Extent1].[ApprovedTotalReviews] AS [ApprovedTotalReviews],
            [Extent1].[NotApprovedTotalReviews] AS [NotApprovedTotalReviews],
            [Extent1].[SubjectToAcl] AS [SubjectToAcl],
            [Extent1].[LimitedToStores] AS [LimitedToStores],
            [Extent1].[Sku] AS [Sku],
            [Extent1].[ManufacturerPartNumber] AS [ManufacturerPartNumber],
            [Extent1].[Gtin] AS [Gtin],
            [Extent1].[IsGiftCard] AS [IsGiftCard],
            [Extent1].[GiftCardTypeId] AS [GiftCardTypeId],
            [Extent1].[RequireOtherProducts] AS [RequireOtherProducts],
            [Extent1].[RequiredProductIds] AS [RequiredProductIds],
            [Extent1].[AutomaticallyAddRequiredProducts] AS [AutomaticallyAddRequiredProducts],
            [Extent1].[IsDownload] AS [IsDownload],
            [Extent1].[DownloadId] AS [DownloadId],
            [Extent1].[UnlimitedDownloads] AS [UnlimitedDownloads],
            [Extent1].[MaxNumberOfDownloads] AS [MaxNumberOfDownloads],
            [Extent1].[DownloadExpirationDays] AS [DownloadExpirationDays],
            [Extent1].[DownloadActivationTypeId] AS [DownloadActivationTypeId],
            [Extent1].[HasSampleDownload] AS [HasSampleDownload],
            [Extent1].[SampleDownloadId] AS [SampleDownloadId],
            [Extent1].[HasUserAgreement] AS [HasUserAgreement],
            [Extent1].[UserAgreementText] AS [UserAgreementText],
            [Extent1].[IsRecurring] AS [IsRecurring],
            [Extent1].[RecurringCycleLength] AS [RecurringCycleLength],
            [Extent1].[RecurringCyclePeriodId] AS [RecurringCyclePeriodId],
            [Extent1].[RecurringTotalCycles] AS [RecurringTotalCycles],
            [Extent1].[IsShipEnabled] AS [IsShipEnabled],
            [Extent1].[IsFreeShipping] AS [IsFreeShipping],
            [Extent1].[AdditionalShippingCharge] AS [AdditionalShippingCharge],
            [Extent1].[DeliveryDateId] AS [DeliveryDateId],
            [Extent1].[WarehouseId] AS [WarehouseId],
            [Extent1].[IsTaxExempt] AS [IsTaxExempt],
            [Extent1].[TaxCategoryId] AS [TaxCategoryId],
            [Extent1].[ManageInventoryMethodId] AS [ManageInventoryMethodId],
            [Extent1].[StockQuantity] AS [StockQuantity],
            [Extent1].[DisplayStockAvailability] AS [DisplayStockAvailability],
            [Extent1].[DisplayStockQuantity] AS [DisplayStockQuantity],
            [Extent1].[MinStockQuantity] AS [MinStockQuantity],
            [Extent1].[LowStockActivityId] AS [LowStockActivityId],
            [Extent1].[NotifyAdminForQuantityBelow] AS [NotifyAdminForQuantityBelow],
            [Extent1].[BackorderModeId] AS [BackorderModeId],
            [Extent1].[AllowBackInStockSubscriptions] AS [AllowBackInStockSubscriptions],
            [Extent1].[OrderMinimumQuantity] AS [OrderMinimumQuantity],
            [Extent1].[OrderMaximumQuantity] AS [OrderMaximumQuantity],
            [Extent1].[AllowedQuantities] AS [AllowedQuantities],
            [Extent1].[AllowAddingOnlyExistingAttributeCombinations] AS [AllowAddingOnlyExistingAttributeCombinations],
            [Extent1].[DisableBuyButton] AS [DisableBuyButton],
            [Extent1].[DisableWishlistButton] AS [DisableWishlistButton],
            [Extent1].[AvailableForPreOrder] AS [AvailableForPreOrder],
            [Extent1].[PreOrderAvailabilityStartDateTimeUtc] AS [PreOrderAvailabilityStartDateTimeUtc],
            [Extent1].[CallForPrice] AS [CallForPrice],
            [Extent1].[Price] AS [Price],
            [Extent1].[RRP] AS [RRP],
            [Extent1].[ProductCost] AS [ProductCost],
            [Extent1].[FromPrice] AS [FromPrice],
            [Extent1].[ToPrice] AS [ToPrice],
            [Extent1].[FromRRP] AS [FromRRP],
            [Extent1].[DiscountPercentage] AS [DiscountPercentage],
            [Extent1].[SpecialPrice] AS [SpecialPrice],
            [Extent1].[SpecialPriceStartDateTimeUtc] AS [SpecialPriceStartDateTimeUtc],
            [Extent1].[SpecialPriceEndDateTimeUtc] AS [SpecialPriceEndDateTimeUtc],
            [Extent1].[CustomerEntersPrice] AS [CustomerEntersPrice],
            [Extent1].[MinimumCustomerEnteredPrice] AS [MinimumCustomerEnteredPrice],
            [Extent1].[MaximumCustomerEnteredPrice] AS [MaximumCustomerEnteredPrice],
            [Extent1].[HasTierPrices] AS [HasTierPrices],
            [Extent1].[HasDiscountsApplied] AS [HasDiscountsApplied],
            [Extent1].[Weight] AS [Weight],
            [Extent1].[LENGTH] AS [LENGTH],
            [Extent1].[Width] AS [Width],
            [Extent1].[Height] AS [Height],
            [Extent1].[AvailableStartDateTimeUtc] AS [AvailableStartDateTimeUtc],
            [Extent1].[AvailableEndDateTimeUtc] AS [AvailableEndDateTimeUtc],
            [Extent1].[DisplayOrder] AS [DisplayOrder],
            [Extent1].[Published] AS [Published],
            [Extent1].[Deleted] AS [Deleted],
            [Extent1].[CreatedOnUtc] AS [CreatedOnUtc],
            [Extent1].[UpdatedOnUtc] AS [UpdatedOnUtc]
            FROM  [dbo].[Product] AS [Extent1]
            INNER JOIN [dbo].[Product_Category_Mapping] AS [Extent2] ON [Extent1].[Id] = [Extent2].[ProductId]
            WHERE [Extent2].[CategoryId] = 1 /* @p__linq__0 */
        )  AS [Project1]
    )  AS [Project1]
    WHERE [Project1].[ROW_NUMBER] > 0
    ORDER BY [Project1].[Name] DESC