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.
Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática
Question.id as [question_id],
Question.Tags as [tags],
Question.Title as [question_title],
Question.Body as [question_body],
Answer.id as [answer_id],
Answer.Body as [answer],
Answer.Score * 500 +
case when Question.ViewCount/10 > 1000 then 1000 else Question.ViewCount/10 end
) as [Weighted]
from Posts Answer
join Posts question ON Answer.ParentId = Question.Id
Answer.PostTypeId = 2