spGetEmailsByListID

    CREATE PRocedure [dbo].[spGetEmailsByListID]
@EmailListID int

as

SELECT e.[ID]
      ,[EmailTemplateID]
      ,[Name]
      ,[Description]
      ,[OwnerID]
      ,[Deleted]
      ,[Guid]
      ,[Type]
      ,[Status]
      ,[ContentHTML]
      ,[ContentText]
      ,[FromAddress]
      ,[FromDisplayName]
      ,[Subject]
      ,[Priority]
      ,[ReplyAddress]
      ,[ReturnReceipt]
      ,[ReturnReceiptAddress]
      ,[ForwardDSN]
      ,[ForwardDSNAddress]
      ,[SendAfterDate]
      ,[CreateDate]
  FROM [dbo].[Email] e INNER JOIN Email_EmailList eel on e.[ID] = eel.EmailID
  WHERE eel.EmailListID = @EmailListID