Not very recent, unanswered zero-score questions by low-rep users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Game Development

Q&A for professional and independent game developers

SELECT TOP 1000 p.CreationDate, p.Id AS [Post Link], p.Body 
FROM Posts p INNER JOIN Users u ON p.OwnerUserId = u.Id
WHERE u.Reputation <= ##ReputationLimit## AND 
      p.PostTypeId = 1 AND 
      p.Score=0 AND
      DATEDIFF(DAY,p.CreationDate, GETDATE())>25 AND
      ISNULL(p.AnswerCount,0) = 0 AND 
      ClosedDate IS NULL
ORDER BY p.CreationDate DESC

Enter Parameters

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