Open questions with downvotes but no comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query aims to show the magnitude of the problem where users don't give feedback after voting to close or downvoting. See http://meta.stackoverflow.com/questions/179003/stack-exchange-is-too-harsh-to-new-usersplease-help-them-improve-low-quality-po/179016#179016 for more on this issue.

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT Id as [Post Link], Score, ClosedDate
FROM Posts
WHERE
  ClosedDate is NULL
  AND PostTypeId = 1
  AND Id NOT IN (
    SELECT Comments.PostId FROM Comments
  )
  AND Id IN (
    SELECT Votes.PostId
    FROM Votes
    WHERE Votes.VoteTypeId = 3
  )
ORDER BY Id DESC;

Enter Parameters

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