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.

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

view current version

edited feb 8 12

created feb 8 12 e