Reanimator - one possibility

1

Please login or register to vote for this query.

(click on this box to dismiss)

Answered more than 120 days later scoring 4 or more with earliest answer scoring 2 or more. http://meta.stackoverflow.com/q/69116

Stack Overflow

Q&A for programmers

-- Reanimator - one possibility
-- Answered more than 120 days later scoring 4 or more with earliest answer scoring 2 or more. http://meta.stackoverflow.com/q/69116

select a.Id as [Post Link] from Posts a 
join Posts q on q.Id = a.ParentId 
where a.CreationDate  > q.CreationDate + 90
and a.Score >= 4 and q.ClosedDate is null

and a.Id = ( 
 select min(a2.Id) from Posts q2 
 join Posts a2 on a2.ParentId = q2.Id
 where a2.Score >= 2 and q2.Id = q.Id
) 

Enter Parameters

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