Counts the number of title and/or body revisions you've made on other people's non-deleted posts.
Q&A about the site for serious players and enthusiasts of chess
-- 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)