0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

SELECT *
FROM
  Posts
JOIN
  PostTags ON Posts.Id = PostTags.PostId
JOIN
  Tags ON PostTags.TagId = Tags.Id
WHERE
  Tags.TagName = 'python'
  AND Posts.CreationDate >= '2024-01-01'
  AND Posts.CreationDate < '2024-05-01'
ORDER BY
  CreationDate;

view current version

edited may 26

created may 26 user25244630