Tumbleweed Prevention with Tag


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

    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, -14, GETDATE())
    AND CreationDate < DATEADD(DAY, -3, GETDATE())
    AND ClosedDate IS NULL
    AND DeletionDate IS NULL
    AND CommunityOwnedDate IS NULL
    AND Tags.TagName IN ('##tag##')
ORDER BY CreationDate

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results