SELECT NIT.[Id] AS NewItemTrackingId
      ,NIT.[SubBannerId]
      ,NIT.[ProductSkuId]
      ,NIT.[BeginDate]
      ,NIT.[EndDate]
      ,NIT.[Source]
      ,NIT.[SourceId]
    ,SR.[Id] AS ServiceRequestId
    ,SR.[ClientId]
    ,SR.[ActivitySubTypeId]
    ,SR.[SiteId]
  FROM [newitem].[NewItemTracking] NIT
  JOIN [coordinator].[LinkedRequestSource] LRS ON LRS.[RequestSourceType] = 'NewItemTracking' AND LRS.[RequestSourceId] = NIT.[Id]
  JOIN [coordinator].[ServiceRequest] SR ON SR.[Id] = LRS.[ServiceRequestId] AND LRS.[PartitionDate] = SR.[PartitionDate]
  --Use joins if needing to lookup a specific store
  --JOIN [threesixty].[MasterDataMapping] MDM ON SR.[SiteId] = MDM.[EntityId] AND MDM.[EntityType] = 'Site' AND MDM.[IsActive] = 1
  --JOIN [dbo].[Store] S ON S.[MdmId] = MDM.[MappedId] AND S.[Id] = 'c63a1eaf-4955-4e3c-8d1f-b0fd01021c41' 
  WHERE NIT.[Status] = 'Complete' --Complete means alerts were created
  AND NIT.[SubBannerId] = 'F8A21633-C626-42F6-8811-B03D0148383D' --SubBannerId GUID
  AND NIT.[ProductSkuId] = '62D02E6B-E88E-475B-B40D-B108015EBDA3' --ProductSkuId GUID
  ORDER BY NIT.[ModifiedDate] DESC