Questions ready for processing

0

Please login or register to vote for this query.

(click on this box to dismiss)

Want to exercise your democratic 10k rights? Can't find questions to delete? Want to give that barrel a good ol' bottom-scraping? Behold, the worst questions ever. Sorted by score and how long they've been closed.

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