Top 50k scored answers for questions asked in a given year


Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

SELECT TOP 50000 ''+ cast( as nvarchar) as AnswerLink,
                  Question.Title as QuestionTitle,
                  Question.Body as Question,
                  Answer.Body as Answer, 
                  Question.Tags as QuestionTags, 
                  Answer.Score as AnswerScore, 
                  cast(DATEPART(YYYY, Question.CreationDate) as int) as QuestionYear
FROM Posts Answer
INNER JOIN Posts Question
ON Answer.ParentId=Question.Id
WHERE Answer.PostTypeId=2 --Answers only
AND DATEPART(YYYY, Question.CreationDate) = 2011
ORDER BY Answer.Score DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results