0

Please login or register to vote for this query.

(click on this box to dismiss)

More correctly this is the previous calendar month

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 DateAdd(month, -2, GETDATE()) and 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

view current version

edited feb 25

created feb 25 Jim