Questions posted with top 10 most view counts given a tag and the questions' duration

1

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  TOP 10 p1.title AS "Question Title",
          'http://www.stackoverflow.com/questions/' + CAST(p1.id AS VARCHAR) AS "URL",
          p1.ViewCount AS "Number of Views"
    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##'
order by  "NUMBER OF VIEWS" DESC

Enter Parameters

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