0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for operations research and analytics professionals, educators, and students

SELECT DISTINCT p.*
FROM Posts p
INNER JOIN PostTags pt ON p.Id = pt.PostId
INNER JOIN Tags t ON pt.TagId = t.Id
--INNER JOIN Users u ON p.OwnerUserId = u.Id
WHERE (
    p.Title IS NOT NULL 
    AND (
        p.Title LIKE '%github actions%'
        OR p.Title LIKE '%github-actions%'
        OR p.Title LIKE '%Github actions%'
        OR p.Title LIKE '%Github-actions%'
        OR p.Title LIKE '%Github Actions%'
        OR p.Title LIKE '%Github-Actions%'
    )
    --OR t.TagName IN ('github-actions', 'building-github-actions', 'github-actions-self-hosted-runners', 'github-actions-runners', 'github-actions-services', 'github-actions-artifacts', 'github-actions-reusable-workflows', 'github-actions-workflows', 'github-actions-marketplace') -- Replace with your list of tags
    --)
    AND p.CreationDate >= '2019-11-14 00:00:00'
    AND p.CreationDate < '2023-11-01 00:00:00'
    )
ORDER BY p.Score DESC;

fork query

edited nov 24 23

created nov 6 23 anonymous