spFundRaisersForTFReports

            CREATE PROCEDURE [dbo].[spFundRaisersForTFReports](@ClientsID int)
            AS
                SELECT  
                    fr.[ID], 
                    [SiteContentID], 
                    [BackOfficeID], 
                    fr.[Name], 
                    fr.[Description], 
                    [CategoryID], 
                    [StartDate], 
                    [EndDate], 
                    [Inactive], 
                    [Goal], 
                    [Dirty],
                    [Options],
                    [Title],
                    fr.[SyncStatus]
                FROM dbo.FundRaisers fr
                    inner join dbo.SiteContent sc on fr.SiteContentID=sc.ID
                    inner join dbo.ClientSites cs on sc.ClientSitesID=cs.ID
                WHERE 
                    fr.IsFunctional = 1 and fr.IsCarePageManager = 0 and
                    cs.ID=@ClientsID
                ORDER BY
                    [Title]