New Answers to Old Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Worldbuilding

Q&A for writers/artists using science, geography and culture to construct imaginary worlds and settings

SELECT TOP 15
  post.Id AS [Post Link],
  post.OwnerUserId AS [User Link],
  post.CreationDate AS [Posted On],
  parent.CreationDate AS [Question Asked On]
FROM Posts AS post
INNER JOIN Posts AS parent ON post.ParentId = parent.Id
WHERE
  post.PostTypeId = 2
  AND post.CreationDate - parent.CreationDate > 30
  AND GETDATE() - post.CreationDate < 7
ORDER BY (GETDATE() - post.CreationDate) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results