OrderByScore

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

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