Top answers for tag from previous month

0

Please login or register to vote for this query.

(click on this box to dismiss)

More correctly this is the previous calendar month

Windows Phone Meta

Q&A about the site for enthusiasts and power users of Windows Phone OS

select top 100
       q.id as [Post Link]
     , q.score as "Q-Score"
     , a.score as "A-Score"
     , q.creationdate
     , q.tags
     , q.answercount
from posts q 
inner join posttags pt 
      on pt.postid = q.id
inner join tags t 
      on t.id = pt.tagid
inner join string_split(##tags:string?delphi,extjs##,',') sel 
      on sel.value = t.tagname
inner join posts a
      on a.ParentId = q.id
where 
1=1 -- simplify predicate editing
and a.PostTypeId = 2 -- Answer
and q.PostTypeId = 1 -- Question
and q.creationdate between GETDATE() and DateAdd(month, 2, GETDATE())
and a.score > 1
and q.score > 1
and q.acceptedanswerid is not null
and q.closeddate is null -- not closed
order by q.creationdate desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results