Most useful answers with question, title and tags


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

  TOP 50000 as [question_id],
  Question.Tags as [tags],
  Question.Title as [question_title],
  Question.Body as [question_body], 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
  Answer.PostTypeId = 2
order by 
  [Weighted] desc

Enter Parameters

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