Number of Views for all posts given a specific tag and duration

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select    SUM(p1.viewcount) "NUMBER OF VIEWS",
          DATENAME(mm, p1.CreationDate) AS MONTH_NAME,
          DATENAME(yyyy, p1.CreationDate) AS YEAR,
          MONTH(p1.CreationDate) AS MONTH_NUM
  from    Posts p1, PostTags ptags1, Tags t1, PostTypes ptypes1 
 where    p1.posttypeid = ptypes1.id
   and    ptypes1.id = 1
   and    p1.id = ptags1.postid 
   and    ptags1.tagid = t1.id 
   and    t1.tagname = '##TagName##'
   and    p1.CreationDate >= '##startdate##'
   and    p1.CreationDate <= '##enddate##'
group by  DATENAME(yyyy, p1.CreationDate), MONTH(p1.CreationDate), DATENAME(mm, p1.CreationDate)
order by  DATENAME(yyyy, p1.CreationDate) ASC, MONTH(p1.CreationDate) ASC, DATENAME(mm, p1.CreationDate) ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results