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.

EOS.IO

Q&A for users and developers of distributed applications built on top of the blockchain operating system, EOS.IO

DECLARE @UserId int = ##UserId##

SELECT COUNT(DISTINCT ph.RevisionGUID) FROM PostHistory ph
    WHERE
        ph.UserId = @UserId AND
        ph.PostHistoryTypeId IN (4, 5) AND
        ph.PostId NOT IN (SELECT p.Id FROM Posts p WHERE p.OwnerUserId = @UserId)

Enter Parameters

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