Premium Retail Services

Adjust date and other criteria but this will help easily identify NewItem tracking records.

SELECT NIT.[BeginDate], NIT.[EndDate], NIT.[Source], NIT.[SourceId],
  PrI.[Upc], PrI.[UpcCheckDigit], PrI.[Name] AS ProductName, C.[Name] AS ClientName, SB.[MdmId] AS SubBannerId, SB.[Name] AS SubBannerName
  FROM [newitem].[NewItemTracking] NIT
  JOIN [dbo].[ProductSku] PS ON NIT.[ProductSkuId] = PS.[Id] AND PS.[Active] = 1
  LEFT JOIN [dbo].[ProductItem] PrI ON PS.[ProductItemId] = PrI.[Id] AND PrI.[Active] = 1 
  LEFT JOIN [dbo].[ClientItem] CI ON PrI.[Id] = CI.[ProductItemId] AND CI.[Active] = 1 AND CI.[ExecutionClientItem] = 1
  LEFT JOIN [dbo].[Client] C ON CI.[ClientId] = C.[Id] AND C.[Active] = 1 AND C.[ExecutionClient] = 1
  JOIN [dbo].[SubBanner] SB ON NIT.[SubBannerId] = SB.[Id] AND SB.[Active] = 1
  WHERE [Status] <> 'Canceled' AND '2024-11-28' BETWEEN [BeginDate] AND [EndDate]