My downvoted posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists all of your posts that have received any downvotes, sorted by number of downvotes.

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

SELECT p.Id     AS [Post Link],
       SUM(CASE WHEN v.VoteTypeId = 3 THEN 1 ELSE 0 END) AS Downvotes,
       SUM(CASE WHEN v.VoteTypeId = 2 THEN 1 ELSE 0 END) AS Upvotes       
FROM   Posts p
       INNER JOIN Votes v
         ON p.Id = v.PostId  
WHERE  p.OwnerUserId = ##UserId:int##
GROUP  BY p.Id
HAVING SUM(CASE WHEN v.VoteTypeId = 3 THEN 1 ELSE 0 END) > 0
ORDER  BY Downvotes DESC

Enter Parameters

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