Maintenance edits to Books questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT
  a.Id AS [Post Link],
  ph.UserId AS [User Link],
  ph.CreationDate AS 'Edit date',
  q.CreationDate AS 'Ask date',
  CONCAT('site://posts/',a.Id,'/revisions|link') AS 'Revisions link',
  ph.Comment
FROM PostHistory ph
JOIN Posts a ON a.Id = ph.PostId
JOIN Posts q ON q.Id = a.ParentId
WHERE q.Tags LIKE '%<resource-recommendations>%'
  AND ph.PostHistoryTypeId = 5 --edit body
  AND ph.UserId != a.OwnerUserId --remove edits to self-owned answers
  AND ph.Comment != 'Commonmark migration'
  AND ph.Comment NOT LIKE 'replaced http://%'
ORDER BY ph.CreationDate DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results