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 Id AS [Post Link]
FROM Posts q
WHERE CreationDate < 2012/10/10
      AND ClosedDate IS NULL
      AND AcceptedAnswerId IS NULL
      
      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