Downvoted -> edited -> upvoted

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 PostHistory on
  down.PostId = PostHistory.PostId and
  PostHistory.CreationDate > down.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