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.

Q&A for scientific skepticism

select
  TOP 10
  Answer.Id,
  Question.Title,
  Question.Body,
  Answer.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

fork query

edited jan 24

created sep 19 12 anonymous