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

Enter Parameters

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