spGetFundraiserSolicitorContactActions

            CREATE PROCEDURE [dbo].[spGetFundraiserSolicitorContactActions]
            (            
                @FundraiserSolicitorContactID int 
            )
            AS

            SELECT     
                frsca.[ID], 
                frsca.[FundraiserSolicitorContactID], 
                frsca.[AddressbookContactsID], 
                frsca.[FundraiserSolicitorsID], 
                frsca.[CreateDate], 
                frsca.[UpdateDate], 
                frsca.[Deleted],
                frsca.[Type], 
                frsca.[Status], 
                frsca.[StatusReport],
                frsca.[FundRaiserDonationsID],
                frsca.[FundRaiserSolicitorEmailID],
                frsca.[EmailJobRecipientID],
                frsca.[EmailRecipientID],
                frsca.[ForwardEmailJobRecipientID],
                frsca.[ForwardingContactActionID],
                isnull(ejr.[Opened], ejr2.[Opened]) [Opened],
                isnull(ejr.[OpenedDate], ejr2.[OpenedDate]) [OpenedDate],
                isnull(frd.[IsAthon], 0) [IsAthon],
                isnull(frd.Amount, 0) [Amount],
                [Children] = (SELECT COUNT(a2.ID)
                        FROM emailjob_recipient r 
                        inner join FundraiserSolicitorContactAction a2 on r.ID = isnull(a2.EmailJobRecipientID, a2.ForwardEmailJobRecipientID)
                        WHERE frsca.EmailJobRecipientID is null and r.EmailRecipientID = frsca.EmailRecipientID)
            FROM FundraiserSolicitorContactAction frsca
            LEFT JOIN EmailJob_Recipient ejr ON isnull(frsca.EmailJobRecipientID, [dbo].[fnEmailJobRecipientIDByEmailRecipientID](frsca.EmailRecipientID)) = ejr.ID 
            LEFT JOIN EmailJob_Recipient ejr2 ON frsca.ForwardEmailJobRecipientID = ejr2.ID
            LEFT JOIN FundRaiserDonations frd on frd.ID = frsca.FundRaiserDonationsID
            WHERE FundraiserSolicitorContactID = @FundraiserSolicitorContactID