spGetEmailProjectAppealEmailsByType

CREATE  PROCEDURE [dbo].[spGetEmailProjectAppealEmailsByType]
@ProjectAppealID int,
@EmailType tinyint

as

SELECT epale.[ID]
      ,epale.[EmailProjectAppealID]
      ,[EmailProjectAppealListID]
      ,e.[ID] as EmailID
      ,[SampleSize]
      ,[SampleType]
      ,e.[Name] "EmailName"
      ,el.[Name] "ListName"
  FROM [dbo].[EmailProjectAppeal_ListEmail] epale 
  INNER JOIN [dbo].[Email] e on epale.[ID] = e.[ProjectAppealListEmailID] 
  INNER JOIN [dbo].[EmailProjectAppeal_EmailList] epael on epale.[EmailProjectAppealListID] = epael.[ID] 
  INNER JOIN [dbo].[EmailList] el on epael.[EmailListID] = el.[ID]
  WHERE epale.[EmailProjectAppealID] = @ProjectAppealID AND e.[Type] = @EmailType
  AND epale.Deleted = 0