How many of my edits have been rolled back?

3

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

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT 
  edits.PostId AS [Post Link], 
  edits.Comment AS [Edit Comment],
  edits.CreationDate AS [Edit Date],
  rollbacks.Comment AS [Rollback Comment],
  rollbacks.CreationDate AS [Rollback Date]
FROM PostHistory edits
  INNER JOIN PostHistory rollbacks
    ON edits.PostId = rollbacks.PostId--rollback and edit occurred on same post
    AND rollbacks.CreationDate > edits.CreationDate --rollback occurred after your edit
WHERE 
  edits.PostHistoryTypeId IN (4,5,6)--title, tag, or body edits
  AND rollbacks.PostHistoryTypeId IN (7,8,9)--title, tag, or body rollbacks
  AND edits.UserId = ##UserId##--You did the edit
  AND rollbacks.UserId <> ##UserId##--You didn't do the rollback

Enter Parameters

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