DECLARE @__siteId_0 int = 1; SELECT DISTINCT [p].[ProductId], [p].[AIRewritten], [p].[AvailabilityText], [p].[DateTImeCreated], [p].[DateTimeUpdated], [p].[DetailPageURL], [p].[DetailPageURL2], [p].[DisplayCurrency], [p].[DisplayPrice], [p].[DisplayPriceFormatted], [p].[IsAmazonFulfilled], [p].[IsDeleted], [p].[IsFreeShippingEligible], [p].[IsHidden], [p].[IsInStock], [p].[IsPrime], [p].[ObjectData], [p].[OriginalProductTitle], [p].[PAAPIData], [p].[ProductBackupTitle], [p].[ProductGuid], [p].[ProductTitle], [p].[ProductType], [p].[Rating], [p].[RatingResult], [p].[SavingDisplayPrice], [p].[SavingsFormatted], [p].[SearchText], [p].[SiteDataProviderId], [p].[SiteId], [p].[SmallThumbnailURL], [p].[ThumbnailURL], [p].[UniqueCode] FROM [Product] AS [p] WHERE [p].[SiteId] = @__siteId_0