Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT TOP(##num?500##) PostId AS [Post Link], CreationDate, timeline = 'site://posts/' + CAST(PostId AS varchar)+'/timeline', revisions = 'site://posts/' + CAST(PostId AS varchar)+'/revisions' FROM PostHistory WHERE PostHistoryTypeId=50 ORDER BY CreationDate DESC