UDQ

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

declare @start date = dateadd(week, -140, getdate())
select Score, p.Id as [Post Link], Body
from Posts p
join PostHistory h on p.Id = h.PostId
where p.postTypeId = 1
and h.PostHistoryTypeId = 13
and p.CreationDate >= @start
ORDER BY Score DESC

Enter Parameters

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