Most useful answers with question, title and tags

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.

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

select
  TOP 50000
  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],
  (
    len(Answer.Body) +
    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
where
  Answer.PostTypeId = 2
order by 
  [Weighted] desc

Enter Parameters

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