0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for developers and end users of the Sitecore CMS and multichannel marketing software

SELECT     TOP ##numberofquestionstofetch## tags.tagname AS kha,
           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        question.tags LIKE '##Tag##' 
/*AND        tags.tagname='python' */
ORDER BY   question.score DESC

fork query

edited aug 14 20

created jan 31 20 anonymous