Counts the number of title and/or body revisions you've made
on other people's non-deleted posts.
Q&A for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
-- 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)