0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

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.Id > ##LastFetchedQuestionId## AND Tags.TagName IN ('##Tag##') ORDER BY question.Score DESC

fork query

edited jun 25 20

created jan 31 20 anonymous