0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jan 2 18 PhiNotPi

created dec 20 16 anonymous