0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

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