downvoted -> edited, non-negative score

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 Posts on
  down.PostId = Posts.ID
join PostHistory on
  down.PostId = PostHistory.PostId and
  PostHistory.CreationDate > down.CreationDate
where
  Posts.Score >= 0 and
  down.VoteTypeId = 3 and
  PostHistory.PostHistoryTypeId IN (4, 5, 6)

Enter Parameters

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