spREINT_GetPersonalPagesInfo

            CREATE  PROCEDURE [dbo].[spREINT_GetPersonalPagesInfo] 
            (
                @MaxRecords int,
                @DownloadStartpoint nvarchar(50)
            )
            AS
                SET ROWCOUNT @MaxRecords 
                SELECT fs.id,
                    fs.clientusersID,
                    fp.DisplayName,
                    sp.id AS "PAGEID",
                    [dbo].[fnFundRaiserPageHits](fs.id) AS "NUMVISITS",
                    MAX(s.requestdate) as "LASTVISIT",
                    '' AS "URL"
                FROM dbo.fundraisersolicitors fs
                INNER JOIN dbo.fundraiserpages fp 
                ON fs.fundraiserid = fp.fundraiserid
                INNER JOIN dbo.sitepages sp 
                ON fp.sitepageid = sp.id
                LEFT OUTER JOIN dbo.stats s 
                ON s.pageid = sp.id and s.frsolicitorid = fs.id
                WHERE fs.backofficeid IS NOT NULL
                AND s.requestdate > @DownloadStartpoint
                GROUP BY fs.id,fs.clientusersID,fp.DisplayName,sp.PublishDate,sp.id
                ORDER BY MAX(s.requestdate) ASC
                SET ROWCOUNT 0