List of my edits that were rolled back

0

Please login or register to vote for this query.

(click on this box to dismiss)

Edits of mine that were rolled back.

Physics

Q&A for active researchers, academics and students of physics

DECLARE @UserId AS INT = ##UserId:int##

SELECT my.PostId AS [Post Link],
                type.Name AS [Action],
                other.UserId [User Link]
FROM   Posts p
JOIN   PostHistory my
         ON p.Id = my.PostId
JOIN   PostHistory other
         ON p.Id = other.PostId 
JOIN   PostHistoryTypes type
         ON my.PostHistoryTypeId = type.Id
WHERE  p.OwnerUserId != @UserId
       AND other.PostHistoryTypeId IN (7, 8, 9)
       AND my.UserId = @UserId
       AND other.CreationDate > my.CreationDate
       AND other.UserId != @UserId
ORDER  BY my.Id DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results