Questions ready for Cleanup

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cleanup needs a list of questions. Here is a list of unanswered questions at least 60 days old.

Physics

Q&A for active researchers, academics and students of physics

SELECT q.Id
FROM   Posts q
WHERE  q.PostTypeId = 1
  AND q.LastEditDate < DATEADD(d, -60, GETDATE())
  AND q.ClosedDate IS NULL
  AND q.AcceptedAnswerId IS NULL
  AND (q.AnswerCount IS NULL
    OR q.AnswerCount = 0
    OR NOT EXISTS (
      SELECT Id
      FROM   Posts a
      WHERE  a.PostTypeId = 2
        AND a.ParentId = q.Id
        AND a.Score > 0
    )
  )
ORDER  BY q.Id ASC

Enter Parameters

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