Q&A for professional mathematicians
SELECT TOP(##num?500##) p.Id AS [Post Link], concat('site://posts/', p.Id, '/revisions' ) [Revisions Link], p.OwnerDisplayName AS [User Link], p.CreationDate, h.CreationDate, p.Score, p.ViewCount, p.AnswerCount, p.Tags FROM Posts p JOIN PostHistory h ON p.Id=h.PostId WHERE h.PostHistoryTypeId=52 AND p.PostTypeId=1 ORDER BY p.Id DESC