Downvote -> comment -> edit -> upvote

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

Select count(distinct down.PostId) from Votes as down
join Comments on
  down.PostId = Comments.PostId and
  Comments.CreationDate > down.CreationDate
 join PostHistory on
  down.PostId = PostHistory.PostId and
  PostHistory.CreationDate > Comments.CreationDate
 join Votes as up on
  up.PostId = down.PostId and
  up.CreationDate > PostHistory.CreationDate
where
  up.VoteTypeId = 2 and 
  down.VoteTypeId = 3 and
  PostHistory.PostHistoryTypeId IN (4, 5, 6)

Enter Parameters

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