Q&A for professional mathematicians
SELECT p.Id AS [Post Link], concat('site://posts/', p.Id, '/revisions' ) [Revisions Link], p.OwnerUserId AS [User Link], p.Score, p. ViewCount, p.Tags FROM PostHistory ph INNER JOIN Posts p ON ph.PostId=p.Id WHERE ph.PostHistoryTypeId=52 AND p.ClosedDate IS NOT NULL ORDER BY p.Id DESC ---52 = Question became hot network question