0

Please login or register to vote for this query.

(click on this box to dismiss)

Edits of mine that were rolled back.

Q&A for enthusiasts and scholars of mythology and folklore

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 my.UserId = @UserId
       AND other.CreationDate > my.CreationDate
       and other.UserId != @UserId
ORDER  BY my.Id DESC

fork query

edited feb 26 12 e

created aug 21 11 PaulEbermann