spFundraiserSolicitorsBackOfficeAndSolicitorIDs

            CREATE PROCEDURE dbo.spFundraiserSolicitorsBackOfficeAndSolicitorIDs
            (@FRID int)
            AS
            BEGIN
                SELECT BackOfficeID, frs.ID, ClientUsersID
                FROM dbo.FundraiserSolicitors frs
                INNER JOIN dbo.ClientUsers cu on frs.ClientUsersID = cu.ID and cu.Deleted = 0
                WHERE RootFundraiserID = @FRID
            END