Q&A by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
   question.Id,
   question.CreationDate,
   question.ViewCount,
   question.Tags,
   question.Title,
   question.Body,
   question.Score,
   answer.Body,
   answer.Score 
FROM
   Posts question 
   LEFT JOIN
      Posts answer 
      ON answer.Id = question.AcceptedAnswerId 
      AND answer.PostTypeId = 2 
WHERE
   question.PostTypeId = 1 
   AND answer.Score > 0 
   AND answer.Body IS NOT NULL 
   AND question.Tags LIKE '%<numpy>%' 
   AND question.Body IS NOT NULL 
   AND question.CreationDate > '2016-01-01' 
ORDER BY
   question.CreationDate ASC

Enter Parameters

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