Answered zombie sniper

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

SELECT
  floor(q.Score + q.AnswerCount*10 + log(q.ViewCount, 10) / 10 - 10) as Weight,
  q.Score,
  q.AnswerCount as Answers,
  q.ViewCount,
  q.Id as "Post Link",
  q.Tags,
  q.ClosedDate
FROM Posts q
WHERE q.PostTypeId = 1
  AND q.AnswerCount > 0
  AND NOT EXISTS (
    SELECT 1
    FROM Posts a
    WHERE a.ParentId = q.Id
      AND a.Score > 0
  )
ORDER BY Weight DESC

Enter Parameters

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