spStats_Pages

CREATE PROCEDURE [dbo].[spStats_Pages]
AS
BEGIN
    set nocount on

    declare @YYYYMM nvarchar(7)
    set @YYYYMM = (CONVERT(nchar(6),getutcdate(),112)+'%')
    select sp.id, sp.PageName, 
    ISNULL(SUM(smp.PageViews),0) + ISNULL(SUM(sdp.PageViews),0) PageViews
    from [dbo].[sitepages] sp
    left outer join (SELECT PageID, SUM(PageViews) PageViews FROM [dbo].[StatisticsMonthPage] GROUP BY PAGEID) smp on smp.PageID = sp.id
    left outer join (SELECT PageID, SUM(PageViews) PageViews FROM [dbo].[StatisticsDayPage] WHERE YYYYMMDD LIKE @YYYYMM GROUP BY PAGEID) sdp on sdp.PageID = sp.id
    where sp.IsTemplatePage = 0
    group by sp.id, pagename 
    order by PageViews desc
END