0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT
  TOP 50
  quest.CreationDate as [posted at],
  ans.CreationDate as [answerd at]
FROM Posts ans
JOIN PostTypes pt ON pt.Id = ans.PostTypeId
JOIN Posts quest ON quest.Id = ans.ParentId
WHERE ans.PostTypeId = 2 
  AND quest.CreationDate > '2018-01-01 00:00:00'
ORDER BY [posted at]

fork query

edited dec 13

created dec 13 anonymous