How many of my edits have been rolled back?


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).

Unix and Linux

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

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
  edits.PostHistoryTypeId IN (4,5,6)
  AND rollbacks.PostHistoryTypeId IN (7,8,9)
  AND edits.UserId = ##UserId##

Enter Parameters

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