top posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

SELECT
  q.Id AS QuestionId,
  q.Title AS QuestionTitle,
  q.Score AS QuestionScore,
  a.Id AS AnswerId,
  a.Score AS AnswerScore
FROM
  Posts AS q
JOIN
  Posts AS a ON a.ParentId = q.Id
WHERE
  q.PostTypeId = 1 -- Question
  AND q.Score > 5
  AND a.Score > 5
  AND a.PostTypeId = 2 -- Answer
ORDER BY
  q.Score DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results