0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT
    Posts.Id AS QuestionId,
    Posts.Title,
    Posts.Body AS QuestionBody,
    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
LEFT JOIN Users ON Posts.OwnerUserId = Users.Id
WHERE
    Tags.TagName = 'unity3d'
    AND Posts.PostTypeId = 1 -- 1 for Questions
    AND Posts.CreationDate >= DATEADD(month, -5, GETDATE())
ORDER BY Posts.CreationDate DESC

fork query

created dec 13 anonymous