Possible Silencium candidates, with comments on the Q after posting the A

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT a.Id AS [Post Link]
  FROM Posts AS q
  INNER JOIN Posts AS a ON a.ParentId = q.Id
  LEFT OUTER JOIN Comments AS c ON c.PostId = q.Id
                               AND c.CreationDate < a.CreationDate
  WHERE a.Score >= 7
    AND a.CommentCount = 0
    AND q.CommentCount > 0
    AND a.CreationDate >= '2017-12-13'
    AND c.Id IS NULL

Enter Parameters

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