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
                            AND a.ParentId = q.Id)
ORDER BY q.CreationDate ASC

view current version

edited jul 24 17

created jul 24 17 Zanna