1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

SELECT
  a.Id AS [Post Link],
  a.CreationDate, q.CreationDate,
  a.OwnerUserId AS [User Link],
  a.OwnerDisplayName,
  'site://posts/' + CAST(q.Id AS varchar)+'/revisions' AS [Question revisions],
  'site://posts/' + CAST(a.Id AS varchar)+'/revisions' AS [Answer revisions]
FROM Posts q INNER JOIN Posts a ON a.ParentId=q.Id
WHERE (a.CreationDate < q.CreationDate)
ORDER BY a.Id

fork query

edited apr 22

created apr 13 Martin20528