Identification questions with a minimum question score and answer score


Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

SELECT question.Id [Post Link], question.Score AS 'Question Score', question.ClosedDate
FROM Posts question
INNER JOIN PostTags pt ON pt.PostId = question.Id
INNER JOIN Tags t on pt.TagId = t.Id
INNER JOIN Posts answer ON question.Id = answer.ParentId
WHERE t.TagName LIKE '%identification%'
AND question.Score > ##MinQuestionScore##
AND answer.Score > ##MinAnswerScore##
ORDER BY question.Score DESC;

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results