Questions that got an answer after they got closed

0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackexchange.com/questions/261039/how-often-questions-get-answered-after-they-got-closed

Stack Overflow

Q&A for professional and enthusiast programmers

select q.id as [Post Link]
    ,  q.closeddate
    ,  a.id as [Post Link]
    ,  a.creationdate
    , datediff(mi, q.closeddate, a.creationdate) as [Minutes]
    , datediff(s, q.closeddate, a.creationdate) as [seconds]
from posts q 
inner join posts a on a.parentid = q.id
where q.posttypeid = 1 -- Q
and a.posttypeid = 2 -- A
and q.closeddate is not null -- closed
and a.creationdate > q.closeddate 
and q.id not in (select postid
                 from posthistory 
                 where posthistorytypeid = 10
                 group by postid
                 having count(*) > 1) -- questions that got closed and reopened
 order by datediff(s, q.closeddate, a.creationdate) desc

Enter Parameters

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