0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for movie and tv enthusiasts

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

created jan 31 20 anonymous