Counts the number of title and/or body revisions you've made
on other people's non-deleted posts.
Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS
-- 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
ph.UserId = @UserId AND
ph.PostHistoryTypeId IN (4, 5) AND
ph.PostId NOT IN (SELECT p.Id FROM Posts p WHERE p.OwnerUserId = @UserId)