Q&A about the site for project managers
SELECT TOP(##num?100##) ph.CreationDate, ph.PostHistoryTypeId, p.Tags AS [Tags], p.Id AS [Post Link], concat('site://posts/', p.Id, '/revisions' ) [Revisions Link] FROM PostHistory ph INNER JOIN Posts p ON ph.PostId=p.Id AND ph.PostHistoryTypeId=52 AND p.PostTypeId=1 ORDER BY ph.CreationDate DESC