Tumbleweeds

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Longterm Tumbleweeds
-- Questions with score <= 0 and no answers after 30 days

select 
-- top 1000 
Id as [Post Link] 
,Tags
from Posts
  where Score <= 0
    and AnswerCount=0
    and ClosedDate is NULL
    and CreationDate < DATEADD(DAY, -8, GETDATE())
    and CommentCount <= 0
    order by CreationDate desc

Enter Parameters

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