Find Questions Voted 4/5 To Close

0

Please login or register to vote for this query.

(click on this box to dismiss)

Find questions which have 4 out of the required 5 votes to close.

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

-- Find Questions Voted 4/5 To Close
-- Find questions which have 4 out of the required 5 votes to close.

SELECT TOP 10 Posts.Id AS [Post Link]
FROM Posts
LEFT JOIN Votes
ON (PostId = Posts.Id)
WHERE Posts.PostTypeId = 1
AND Votes.VoteTypeId = 6
GROUP BY Posts.Id
HAVING COUNT(Votes.Id) >= 4;

Enter Parameters

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