48 hour gap


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) >= '2017-1-1'
  AND MIN(answer.CreationDate) < '2018-1-1'
ORDER BY MIN(answer.CreationDate) - challenge.CreationDate DESC

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results