Top x questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Movies and TV Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results