1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

SELECT p.Id AS [Post Link], MAX(ph.Comment) AS 'Edit summary',
  ph.CreationDate AS 'Edited on'
  FROM PostHistory AS ph
  INNER JOIN Posts AS p
    ON ph.PostId = p.Id
  WHERE ph.UserId = ##UserId:int##
    AND ph.UserId != p.OwnerUserId
    AND ph.PostHistoryTypeId IN (4, 5, 6)
    AND p.PostTypeId IN (1, 2)
  GROUP BY p.Id, ph.CreationDate
  ORDER BY ph.CreationDate DESC

fork query

edited jun 8

created jun 8 Glorfindel