0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  Q.Id AS [Post Link],
  A.Id AS [Post Link],
  Q.Score,
  A.Score
FROM Posts Q INNER JOIN Posts A ON Q.Id = A.ParentId
WHERE
  -- Parent post is question
  Q.PostTypeId = 1
  -- Question is by Bubbler
  AND Q.OwnerUserId = 78410
  -- Child post is an answer
  AND A.PostTypeId = 2
ORDER BY A.Score DESC, Q.Score DESC

fork query

edited nov 25 21

created nov 25 21 Bubbler