Q&A by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Windows Phone Meta

Q&A about the site for enthusiasts and power users of Windows Phone OS

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 main site
loading Hold tight while we fetch your results