select top 50 p.Id as [Post Link] from Comments c join Po...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 50 p.Id as [Post Link]
from Comments c
join Posts p on c.PostId = p.Id
left join Comments c2 on c2.PostId = c.PostId and c2.CreationDate < c.CreationDate and c2.Score >= 50
where c.Score >= 50 and p.LastEditDate < c.CreationDate and c2.Id is null
group by c.Id, p.Id

Enter Parameters

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