0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT
    Posts.Id AS PostId,
    Posts.Title,
    Posts.Body,
    Posts.CreationDate,
    Tags.TagName
FROM
    Posts
    INNER JOIN PostTags ON Posts.Id = PostTags.PostId
    INNER JOIN Tags ON PostTags.TagId = Tags.Id
WHERE
    Posts.CreationDate >= '2024-01-01'
    AND Posts.CreationDate < '2025-01-01'
    AND Tags.TagName = 'java'
    AND Posts.PostTypeId = 1 -- 只提取问题帖子
ORDER BY
    Posts.CreationDate DESC

fork query

created dec 9 anonymous