spGetRawPageStats

CREATE procedure [dbo].[spGetRawPageStats](@ClientSitesID int, @FromDate datetime)
as
BEGIN
set nocount on
select     sp.[ID] PageID, 
    sp.PageName,
    sp.Category,
    s.RequestDate,
    s.TCPIPAddress,
    s.ReferringPageURL,
    s.SourceID,
    s.SourceTypeID,
    dbo.fnGetRecordIDFromLinkedUserID(cu.id,0) RaisersEdgeID,
    s.SourceREID
    from dbo.[stats] s
    full join dbo.sitepages sp on ((sp.[ID] = s.PageID) and (sp.IsTemplatePage = 0) and (s.ClientSitesID = @ClientSitesID)) 
    left join dbo.clientusers cu on cu.[ID] = s.UserID
    where s.RequestDate>=isnull(@FromDate, s.RequestDate)
END