List of my edits that were rolled back


Please login or register to vote for this query.

(click on this box to dismiss)

Edits of mine that were rolled back.

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

-- I don't know how to SQL ignore this query
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

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results