Posts with 3 or 4 close votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace

Q&A for members of the workforce navigating the professional setting

SELECT
  Posts.ID as [Post Link],
  Score
FROM 
  Posts
  INNER JOIN Votes ON Posts.ID = Votes.PostID
WHERE
  Posts.PostTypeID = 1
  AND Votes.VoteTypeID = 6
GROUP BY
  Posts.ID, Score
HAVING COUNT(DISTINCT Votes.ID) <5 and COUNT(DISTINCT Votes.ID) >1

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results