New badge - first answer with a score of 2 or more on an 1 month old question

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- New badge - first answer with a score of 2 or more on an 1 month old question

select a.Id as [Post Link] from Posts a 
join Posts q on q.Id = a.ParentId 
where a.CreationDate  > q.CreationDate + 30
and a.Score > 1 and a.CommunityOwnedDate is not null 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 > 1 and q2.Id = q.Id
) 

Enter Parameters

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