Searches for all edits made on others' posts. Ordered by post score.
Q&A for linguists, etymologists, and serious English language enthusiasts
-- 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