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).
Q&A about the site for linguists, teachers and students of the Ukrainian language
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
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