Question posted with most favorites given the specified tag and 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",
          'http://www.stackoverflow.com/questions/' + CAST(p1.id AS VARCHAR) AS "URL",
          p1.FavoriteCount AS "Favorite Votes"
    from  Posts p1, PostTypes ptypes1, PostTags ptags1, Tags t1
   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  "Favorite Votes" DESC

Enter Parameters

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