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