select q.Id as [Post Link] from Posts q join PostHistory ...

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 q.Id as [Post Link]
from Posts q
join PostHistory ch on ch.PostId=q.Id and ch.PostHistoryTypeId=10 and ch.CreationDate = q.ClosedDate
where ClosedDate between getdate()-67 and getdate()-37 -- who knows what day it is, and I'm too lazy to calculate the dump date
and datediff(hour, q.CreationDate, q.ClosedDate) < 1
and q.Score <= 0
and q.AnswerCount > 0
and ch.Comment <> '101'

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results