1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT TOP(##num?1000##)
  PostId AS [Post Link],
  CreationDate,
  revisions = 'site://posts/' + CAST(PostId AS varchar)+'/revisions', 
  timelines = 'site://posts/' + CAST(PostId AS varchar)+'/timeline'
FROM PostHistory
WHERE PostHistoryTypeId in (##types?1000##)

fork query

created oct 27 22 Martin20528