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
  Questions.Id AS QuestionId,
  Questions.Title,
  Questions.Body,
  LOWER(Questions.Tags) AS Tags,  -- Convert tags to lowercase for case-insensitive matching
  Comments.Id AS CommentId,
  Comments.Text
FROM
  Posts AS Questions
LEFT JOIN
  Posts AS Answers ON Questions.Id = Answers.ParentId
LEFT JOIN
  Comments ON (Questions.Id = Comments.PostId OR Answers.Id = Comments.PostId)
WHERE
  (LOWER(Questions.Tags) LIKE '%python%' OR LOWER(Questions.Tags) LIKE '%javascript%')  -- Use lowercase for tags
  AND YEAR(Questions.CreationDate) >= 2014

Enter Parameters

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