0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

-- Query for comments on questions with Python or JavaScript tags created after December 1, 2023
SELECT
  c.PostId AS PostId,
  c.Text AS CommentText
FROM
  Comments c
JOIN
  Posts q ON c.PostId = q.Id
WHERE
  (q.Tags LIKE '%python%' OR q.Tags LIKE '%javascript%')
  AND q.CreationDate >= '2024-01-01'
  AND q.CreationDate < '2024-02-01' -- Limit to dates between December 1, 2023, and January 1, 2024

UNION ALL

-- Query for comments on answers to questions with Python or JavaScript tags
SELECT
  c.PostId AS PostId,
  c.Text AS CommentText
FROM
  Comments c
JOIN
  Posts a ON c.PostId = a.Id
JOIN
  Posts q ON a.ParentId = q.Id
WHERE
  (q.Tags LIKE '%python%' OR q.Tags LIKE '%javascript%')
  AND q.CreationDate >= '2024-01-01'
  AND q.CreationDate < '2024-02-01' -- Limit to dates between December 1, 2023, and January 1, 2024

view current version

edited feb 28

created feb 28 Amirali