py/js questions their answers (last 3 years)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

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 >= '2023-12-01'
UNION ALL
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 a.CreationDate >= '2024-01-01'

Enter Parameters

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