How many of my edits have been rolled back?

4

Please login or register to vote for this query.

(click on this box to dismiss)

Lists all of your posts where someone else performed a rollback after your edit. There could be some false positives here, where someone edited after you and the rollback just reverted their changes (and not yours).

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT edits.Id, edits.Comment, rollbacks.Id, rollbacks.Comment
FROM PostHistory edits
  INNER JOIN PostHistory rollbacks
    ON edits.PostId = rollbacks.PostId
    --AND rollbacks.CreationDate > edits.CreationDate
WHERE 
  edits.PostHistoryTypeId IN (4,5,6)
  AND rollbacks.PostHistoryTypeId IN (7,8,9)
  AND edits.UserId = ##UserId##

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results