0

Please login or register to vote for this query.

(click on this box to dismiss)

posts with no upvoted or accepted answer written before 10/10/2012

Q&A for Ubuntu users and developers

SELECT q.Id AS [Post Link]
FROM posts q
WHERE q.PostTypeId = 1
      AND q.ClosedDate IS NULL
      AND q.AcceptedAnswerId IS NULL
      AND q.CreationDate > 2012/10/10
      AND NOT EXISTS (SELECT a.Id
                      FROM Posts a
                      WHERE a.Score > 0)
ORDER BY q.CreationDate ASC

view current version

edited jul 24 17

created jul 24 17 Zanna