0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems

SELECT
    Posts.Id AS PostId,
    PostTypes.Name AS PostType,
    Posts.Title,
    Posts.Body,
    Posts.CreationDate,
    Posts.Score,
    Users.DisplayName AS Author,
    Users.Reputation AS AuthorReputation
FROM Posts
JOIN PostTags ON PostTags.PostId = Posts.Id
JOIN Tags ON Tags.Id = PostTags.TagId
JOIN PostTypes ON Posts.PostTypeId = PostTypes.Id
LEFT JOIN Users ON Posts.OwnerUserId = Users.Id
WHERE
    Tags.TagName = 'confluent'
    AND Posts.CreationDate >= DATEADD(month, -3, GETDATE())
ORDER BY Posts.CreationDate DESC

fork query

created jul 17 anonymous