Get Kubernetes Questions by Score

0

Please login or register to vote for this query.

(click on this box to dismiss)

CiviCRM

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT TOP 250 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.score > 0
AND p.CreationDate > '2021-09-1' -- Updated condition here
ORDER BY p.CreationDate DESC

Enter Parameters

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