Q&A for active researchers, academics and students of physics
SELECT TOP(##num?500##) p.Id AS [Post Link], concat('site://posts/', p.Id, '/revisions' ) [Revisions Link], p.OwnerUserId AS [User Link], p.Score, p.CreationDate, p.ViewCount, p.AnswerCount, p. Tags FROM PostHistory ph INNER JOIN Posts p ON ph.PostId=p.Id WHERE ph.PostHistoryTypeId=52 ORDER BY p.Id DESC