0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select top 100 PostId [Post Link]
from Votes
where VoteTypeId=8
and exists (select 1 from PostHistory 
  where PostHistoryTypeId in (5) 
  and PostId=Votes.PostId 
  and UserId=Votes.UserId 
  and CreationDate < Votes.CreationDate 
  and datediff(hour, CreationDate, Votes.CreationDate) < 48)
order by CreationDate desc

fork query

created oct 19 16 anonymous