Question posted with most associated comments (Q&A's comments) 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.CommentCount + p3.NUM) AS "Number of Comments"
    from  Posts p1, PostTypes ptypes1, PostTags ptags1, Tags t1,
         (
            select   SUM(p2.CommentCount) AS "NUM", p2.ParentId AS "ID"
              from   Posts p2, PostTypes ptypes2
             where   p2.posttypeid = ptypes2.id
               and   ptypes2.id = 2
          group by   p2.ParentId
          ) AS p3
   where  p1.id = p3.ID
     and  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 Comments" DESC

Enter Parameters

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