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.

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

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