OrderByScoreQues

0

Please login or register to vote for this query.

(click on this box to dismiss)

Quantum Computing

Q&A for engineers, scientists, programmers, and computing professionals interested in quantum computing

SELECT
	TOP ##NumberOfQuestionsToFetch## question.Id AS QuestionId,
	question.Score AS QuestionScore,
	question.Title AS QuestionTitle,
	question.Body AS QuestionBody,
	question.Tags,
	answer.Id AS AcceptedAnswerId,
	answer.Score AS AnswerScore,
	answer.Body AS AnswerBody 
FROM
	Posts AS question 
	JOIN
		Posts AS answer 
		ON question.AcceptedAnswerId = answer.Id 
	INNER JOIN
		PostTags AS question_tags 
		ON question_tags.PostId = question.Id 
	INNER JOIN
		Tags 
		ON question_tags.TagId = Tags.Id 
WHERE
	question.Score > ##Score## AND Tags.TagName IN ('##Tag##')
ORDER BY
	question.Score DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results