Most useful answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Get your most useful answers, based on post length, score, and view count of the question. This is more useful than just the post score, as sometimes you end up posting a lengthy post which received no upvotes, or a short (and useful) post to an often-asked question.

Skeptics

Q&A for scientific skepticism

select
  TOP 10000
  Answer.Id,
  Answer.Body,
  Question.Body,
  len(Answer.Body) as [Length],
  (
    len(Answer.Body) +
    Answer.Score * 500 +
    case when Question.ViewCount/10 > 1000 then 1000 else Question.ViewCount/10 end
  ) as [Weighted],
  Answer.Id as [Post Link]
from Posts Answer
join Posts question ON Answer.ParentId = Question.Id
where
  Answer.PostTypeId = 2
order by 
  [Weighted] desc

Enter Parameters

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