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 for professional and enthusiast programmers

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