spFundRaiserSolicitorEmailIDsForwarded

CREATE PROCEDURE dbo.spFundRaiserSolicitorEmailIDsForwarded
(@FundRaiserSolicitorsID int)
AS
SELECT 
DISTINCT FREmail.ID as SolicitorEmailID
FROM
dbo.FundraiserSolicitorEmail FREmail
inner join dbo.FundraiserSolicitorContactAction FRActionEmail on FRActionEmail.FundRaiserSolicitorEmailID = FREmail.ID
inner join dbo.EmailJob_Recipient EmailjobRec on EmailjobRec.EmailRecipientID = FRActionEmail.EmailRecipientID
inner join dbo.FundraiserSolicitorContactAction FRActionDonation on FRActionDonation.ForwardEmailJobRecipientID = EmailjobRec.ID
inner join dbo.FundraiserSolicitorContactAction FRActionForward on FRActionForward.ForwardingContactActionID = FRActionDonation.ID
WHERE
FRActionForward.FundraiserSolicitorsID = @FundRaiserSolicitorsID
and
FRActionForward.type = 6