48 hour gap

0

Please login or register to vote for this query.

(click on this box to dismiss)

Programming Puzzles and Code Golf

Q&A for programming puzzle enthusiasts and code golfers

SELECT challenge.Id AS [Post Link]
FROM Posts answer
JOIN Posts challenge ON answer.ParentId = challenge.Id
WHERE NOT EXISTS (SELECT * FROM PostTags WHERE PostTags.PostId = challenge.Id AND PostTags.TagId = 18)
GROUP BY challenge.Id, challenge.CreationDate
HAVING MIN(answer.CreationDate) - challenge.CreationDate >= DATEADD(HOUR, 48, 0)
  AND MIN(answer.CreationDate) >= '2016-1-1'
  AND MIN(answer.CreationDate) < '2017-1-1'
ORDER BY MIN(answer.CreationDate) - challenge.CreationDate DESC

Enter Parameters

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