fnPageStatsByRERecordID

CREATE function [dbo].[fnPageStatsByRERecordID](@ClientsID int) returns table
as 
return (
select top 100 percent 
        coalesce(dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(cu.id), s.SourceREID) RaisersEdgeRecordID,
        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) > 0 
        and s.ClientsID=@ClientsID
        group by p.pagename,p.id,cu.ID, s.SourceREID
        order by RaisersEdgeRecordID ASC,NUMVISITS DESC)