Filtered by keyword github actions and variants in Title

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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;

Enter Parameters

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