Lists title and/or body revisions made on other people's non-deleted posts.
Q&A for network engineers
-- 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##
MIN( ph.Id ) AS Id
MIN( ph.PostId ) AS PostId
MIN( ph.CreationDate ) AS CreationDate
MIN( ph.UserId ) AS UserId
MIN( ph.Comment ) AS Comment
ph.UserId = @UserId
ph.PostHistoryTypeId IN ( 4 , 5 )
ph.PostId NOT IN ( SELECT p.Id FROM Posts p WHERE p.OwnerUserId = @UserId )