Zero Voted Questions Oldest first

1

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT 
      TOP 500
      DATEDIFF(dd, CONVERT(date,Question.CreationDate), CONVERT(date, GETDATE()) ) [Days old],
      Question.Id AS [Post Link],
      Question.AnswerCount,
      Question.Tags
 FROM
      POSTS "Question"
WHERE Question.PostTypeId = 1
AND   Question.Score = 0
AND   DATEDIFF(dd, CONVERT(date,Question.CreationDate), CONVERT(date, GETDATE()) ) > 10
and closeddate is null
ORDER BY
      [Days old] desc

Enter Parameters

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