0

Please login or register to vote for this query.

(click on this box to dismiss)

at least 2 downvotes, score of less than -2

Q&A for Drupal developers and administrators

SELECT
  PostId as [Post Link],
  Score,
  COUNT(CASE VoteTypeId WHEN 2 THEN 1 END) AS 'Upvote count',
  COUNT(CASE VoteTypeId WHEN 3 THEN 1 END) AS 'Downvote count',
  ClosedDate
FROM Votes v
INNER JOIN Posts p ON p.Id=v.PostId
WHERE PostTypeId = 1
  AND VoteTypeId IN (2, 3)
  AND Score < -2
GROUP BY v.PostId, p.ClosedDate, p.Score
HAVING COUNT(CASE VoteTypeId WHEN 3 THEN v.PostId END) > 2
ORDER BY Score, COUNT(CASE VoteTypeId WHEN 3 THEN 1 END) DESC

fork query

created aug 9 11 OffBySome