Test

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.

Amateur Radio

Q&A for amateur radio enthusiasts

SELECT p.Id     AS [Post Link],
       count(*) AS Downvotes
FROM   Posts p
       INNER JOIN Votes v
         ON p.Id = v.PostId
WHERE  p.OwnerUserId = ##UserId:int##
       AND v.VoteTypeId = 3
GROUP  BY p.Id
ORDER  BY Downvotes DESC

Enter Parameters

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