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.

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
--AND COUNT(Votes.Id) = 4
--GROUP BY Posts.Id;

fork query

created feb 17 11 yelton.jared