0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT TOP 1000 p.Score, p.Id AS [Post Link], p.ViewCount, p.Tags
FROM Posts p
WHERE p.PostTypeId = 1 AND p.AcceptedAnswerId IS NULL AND NOT EXISTS (SELECT c.[Id] FROM [Posts] c WHERE c.[Score] > 0 AND c.[ParentId] = p.[Id])
ORDER BY p.ViewCount DESC

fork query

created aug 12 11 TomWij