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