2

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

Q&A for professional and enthusiast programmers

SELECT DISTINCT
  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?117549##--You did the edit
  AND rollbacks.UserId <> ##UserId?117549##--You didn't do the rollback
  AND DATEDIFF(DAY, edits.CreationDate, GETDATE()) < 90
  order by edits.creationdate DESC

fork query

edited dec 31 17 Jeff Schaller

created mar 28 12 jadarnel27