0

Please login or register to vote for this query.

(click on this box to dismiss)

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##

SELECT
  MIN( ph.Id )
    ,
  MIN( ph.PostId )
    ,
  MIN( ph.CreationDate )
    ,
  MIN( ph.UserId )
    ,
  MIN( ph.UserDisplayName )
    ,
  MIN( ph.Comment )
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 )
GROUP BY
  ph.RevisionGUID

view current version

edited oct 3 12 MετάEd

created may 25 11 Jon Seigel