py/js questions their answers (last 3 years)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

SELECT
  q.Id AS QuestionId,
  q.Title AS QuestionTitle,
  q.Body AS QuestionBody,
  q.Tags AS QuestionTags,
  a.Id AS AnswerId,
  a.ParentId AS AnswerParentId,
  a.Body AS AnswerBody
FROM
  Posts q
LEFT JOIN
  Posts a ON q.Id = a.ParentId
WHERE
  (q.Tags LIKE '%python%' OR q.Tags LIKE '%javascript%')
  AND YEAR(q.CreationDate) >= 2021

Enter Parameters

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