SELECT DA.[Id] AS DmcAlertId
    ,DA.[Upc]
  ,DA.[CountryId]
  ,DA.[StoreAssociationId]
    ,SR.[Id] AS ServiceRequestId
    ,SR.[ClientId]
    ,SR.[ActivitySubTypeId]
    ,SR.[SiteId]
  FROM dmc.[DmcAlertFile] DAF
  JOIN dmc.[DmcAlert] DA ON DA.[DmcAlertFileId] = DAF.[Id]
  JOIN [coordinator].[LinkedRequestSource] LRS ON LRS.[RequestSourceType] = 'DmcAlert' AND LRS.[RequestSourceId] = DA.[Id]
  JOIN [coordinator].[ServiceRequest] SR ON SR.[Id] = LRS.[ServiceRequestId] AND LRS.[PartitionDate] = SR.[PartitionDate]
  WHERE DAF.[FileName] = '' --DmcAlertFile Name