SELECT q.Id as [Post Link] FROM posts AS q INNER JOIN pos...

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 q.Id as [Post Link]
  FROM posts AS q
  INNER JOIN posts AS a ON a.ParentId = q.Id
  LEFT OUTER JOIN posts AS a2 ON a2.ParentId = a.ParentId AND a2.Id > a.Id
  INNER JOIN posttags AS pt ON pt.PostId = q.Id
  INNER JOIN tags AS t ON pt.TagId = t.Id
  WHERE t.TagName = 'python' AND a.Score >= 10 AND a2.Id IS NULL

Enter Parameters

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