How many Copy Editor/Strunk & White-qualifying edits have I made?

17

Please login or register to vote for this query.

(click on this box to dismiss)

Counts the number of title and/or body revisions you've made on other people's non-deleted posts.

Language Learning

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

-- How many Copy Editor/Strunk & White-qualifying edits have I made?
-- Counts the number of title and/or body revisions you've made
-- on other people's non-deleted posts.

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