Posts Edited

0

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 FROM PostHistory ph
    WHERE
        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

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