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

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT 
  edits.PostId AS [Post Link], 
  edits.Comment AS [Edit Comment], 
  rollbacks.Comment AS [Rollback Comment]
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 main site
loading Hold tight while we fetch your results