spGetSolicitorContactActionChildren

            CREATE PROCEDURE [dbo].[spGetSolicitorContactActionChildren]
            (
                @EmailRecipientID int
            )
            AS
            BEGIN
                select
                a2.id as ChildActionID

                from FundraiserSolicitorContactAction a
                left outer join emailjob_recipient as r on r.EmailRecipientID = a.EmailRecipientID
                left outer join FundraiserSolicitorContactAction a2 on r.ID = isnull(a2.EmailJobRecipientID, a2.ForwardEmailJobRecipientID)
                where a.EmailRecipientID = @EmailRecipientID and a.emailjobrecipientid is null
                order by a2.CreateDate
            END