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 AnswerCount > 0 ORDER BY p.CreationDate ASC