0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

SELECT TOP 1000 p.Id, p.Title, p.Body, p.CreationDate, p.Score, p.ViewCount
FROM Posts p
INNER JOIN PostTags pt ON p.Id = pt.PostId
INNER JOIN Tags t ON pt.TagId = t.Id
WHERE t.TagName = 'istio'
AND p.PostTypeId = 1 -- 1 for Questions
AND p.CreationDate > '2021-09-1' -- Updated condition here
AND p.Score > 0
AND AnswerCount > 0
ORDER BY p.CreationDate ASC

fork query

edited feb 26

created jan 18 anonymous