Posts Edited


Please login or register to vote for this query.

(click on this box to dismiss)

Counts number of edits made by a user. Excludes: Tag-only edits, edits to own posts, rollbacks. Barring the exclusions, multiple edits to the same posts are counted. This should match with the "Posts Edited" stat on one's profile.

DevOps Meta

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

DECLARE @UserId int = ##UserId##

SELECT ph.PostId, ph.PostHistoryTypeId FROM PostHistory ph
        ph.UserId = @UserId AND
        ph.PostHistoryTypeId IN (7, 9) AND
        ph.PostId NOT IN (SELECT p.Id FROM Posts p WHERE p.OwnerUserId = @UserId)

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results