Answers Posted Before Their Parent Question (?)

1

Please login or register to vote for this query.

(click on this box to dismiss)

German Language Meta

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

SELECT 
  CONCAT('site://q/', a.Id, '|', q.Title) AS [Post],
  q.CreationDate AS [Question Posted],
  a.CreationDate AS [Answer Posted],
  DATEDIFF(mi, q.CreationDate, a.CreationDate) AS [Minutes Between Q & A]
FROM Posts AS q
JOIN Posts a ON a.ParentId = q.Id
LEFT JOIN PostHistory ph ON ph.PostId = q.Id AND ph.PostHistoryTypeId = 18
WHERE DATEDIFF(mi, q.CreationDate, a.CreationDate) < 0
  AND ph.Id IS NULL

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results