fnPageStatsForOneRERecordID

CREATE function [dbo].[fnPageStatsForOneRERecordID](@ClientsID int, @RaisersEdgeRecordID int) returns table
    as 
    return (
    select top 100 percent 
        p.pagename 'PageName',
        p.id 'PageID',
        count(*) 'NumVisits',
        max(s.RequestDate) 'DateLastVisited',
        min(s.RequestDate) 'DateFirstVisited',
        'LoggedIn' = cast((case coalesce(cu.id,0) when 0 then 0 else 1 end) as bit)
        from dbo.Stats s
        inner join dbo.SitePages p on s.pageID=p.ID
        left join dbo.ClientUsers cu on s.UserID=cu.id
        where coalesce(dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(cu.id),s.SourceREID) = @RaisersEdgeRecordID 
        and s.ClientsID=@ClientsID
        group by p.pagename,p.id,cu.id
        order by NUMVISITS DESC)