SELECT A.Id, Q.Title FROM Posts A INNER JOIN Posts Q ON A...

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
    A.Id, Q.Title
FROM Posts A
  INNER JOIN Posts Q ON A.ParentId = Q.Id
WHERE
    -- DATEDIFF(DAY, Q.CreationDate, A.CreationDate) > 180
    Q.CreationDate < '2014-01-01 00:00:00'
    AND A.CreationDate >= '2015-01-01 00:00:00'
    AND A.CreationDate <= '2015-12-31 23:59:59'
    AND NOT EXISTS (SELECT * FROM PostTags WHERE PostId = Q.Id AND TagId = 18)
--    AND A.Score >= 5

Enter Parameters

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