0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professional and independent game developers

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