select top 100 PostId [Post Link] from Votes where VoteTy...

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 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

Enter Parameters

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