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.

German Language Meta

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

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 main site
loading Hold tight while we fetch your results