1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Reference: https://meta.stackexchange.com/questions/2677/database-schema-documentation-for-the-public-data-dump-and-sede/2678#2678

SELECT 
  a.UserId AS [User Link]
  , a.PostId as [Post Link]
  , Comment
  , *
FROM 
  PostHistory a
  INNER JOIN Posts b
  ON a.PostId = b.id
WHERE 
  a.PostHistoryTypeId = 5 -- Edit Body
  AND a.UserId != b.OwnerUserId
  AND a.CreationDate >= '2017-01-01'
  AND a.UserId = ##UserId##

fork query

edited jun 17 17

created jun 17 17 ShreevatsaR