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 DISTINCT 
    p.*, 
    CONCAT('https://stackoverflow.com/q/', p.Id)
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 
--          (p.Body IS NOT NULL 
--          AND (
--              p.Body LIKE '%github actions%'
--              OR p.Body LIKE '%github-actions%'
--              OR p.Body LIKE '%Github actions%'
--              OR p.Body LIKE '%Github-actions%'
--              OR p.Body LIKE '%Github Actions%'
--              OR p.Body 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 27 Sandro.Hernandez.Goicochea

created nov 6 anonymous