0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT TOP 700 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 > 1
ORDER BY p.CreationDate ASC

fork query

edited feb 25

created jan 18 anonymous