spGetAnonymousSubscriberDetailsFromRecipientID

Create PROCEDURE [dbo].[spGetAnonymousSubscriberDetailsFromRecipientID]( 
    @RecipientID int
)
AS

begin

    select 
    ejr.id RecipientID,
    ej.id JobID,
    et.id TemplateID,
    et.Name Newsletter,
    etel.EmailListID ListId,
    s.FirstName,
    s.LastName,
    s.emailaddress,
    s.id subscriberID,
    s.UserID,
    s.BackOfficeSystemPeopleID,
    s.hasOpted
    from 
    emailjob_recipient ejr inner join emailjob ej on ejr.EmailJobid = ej.id
    inner join emailtemplate et on et.id = ej.emailtemplateid
    inner join emailtemplate_emaillist etel on etel.emailtemplateid=et.id
    inner join emaillist_subscription s on s.emaillistid = etel.emaillistid and ejr.emailaddress=s.emailaddress
    where ejr.id=@RecipientID

end