Find tag specific tumbleweed

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT
    Posts.Id AS [Post Link], Tags, CreationDate, ViewCount, CommentCount
FROM Posts
    INNER JOIN PostTags ON Posts.Id       = PostTags.PostId
    INNER JOIN Tags     ON PostTags.TagId = Tags.id
WHERE Score = 0
    AND AnswerCount = 0
    AND CommentCount = 0
    AND CreationDate < DATEADD(DAY, -7, GETDATE())
    AND ViewCount < 60
    AND ClosedDate IS NULL
    AND DeletionDate IS NULL
    AND CommunityOwnedDate IS NULL
    AND Tags.TagName IN ('##tag##')
ORDER BY CreationDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results