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

DECLARE
--  @UserId int = 14073
  @PostId int = 70000

SELECT
  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
    ,
  MIN( ph.Text ) AS Text

FROM
  PostHistory ph

WHERE
--  ph.UserId = @UserId
--  ph.PostId = @PostId
  ph.PostId > @PostId
--    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

ORDER BY
  CreationDate DESC

fork query

edited oct 3 12 MετάEd

created may 25 11 Jon Seigel