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
  Title,
  Body,
  LOWER(Tags) AS Tags
FROM
  Posts
WHERE
  (LOWER(Tags) LIKE '%python%' OR LOWER(Tags) LIKE '%javascript%')
  AND YEAR(CreationDate) >= 2014
  AND PostTypeId = 1  -- Filter for questions by PostTypeId (1 for questions)

Enter Parameters

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