Questions with no upvoted answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mi Yodeya

Q&A for those who base their lives on Jewish law and tradition and anyone interested in learning more

SELECT q.ID AS [Post Link]
FROM Posts q 
WHERE PostTypeId = 1 
AND Score > 0 
AND ClosedDate is null 
AND (select count(*) from Posts a where a.ParentId = q.Id and a.Score > -1) = 0
AND AcceptedAnswerId is null 
AND DATEDIFF(day, CreationDate, CURRENT_TIMESTAMP) > 30
AND q.ID != 1872
ORDER BY CreationDate asc

Enter Parameters

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