2

Please login or register to vote for this query.

(click on this box to dismiss)

Searches for all edits made on others' posts

Q&A for professional and enthusiast programmers

-- What posts have I edited that were not mine?
-- Searches for all edits made on others' posts

DECLARE @UserId int = ##UserId##

SELECT h.PostId AS [Post Link], h.*
    FROM Posts p
    JOIN PostHistory h ON p.Id = h.PostId
    WHERE p.OwnerUserId != @UserId AND h.UserId = @UserId
    ORDER BY h.PostId DESC, h.Id DESC

fork query

created feb 23 11 Jeff Mercado