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
  v.VoteTypeId = 3
group by p.Id
order by Downvotes desc

view current version

edited feb 8 12

created feb 8 12 e