0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 20 questions with the most down-votes (ignores up-votes)

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

-- Most Down-Voted Questions
-- The top 20 questions with the most down-votes (does NOT ignore up-votes)

with vote_counts as
(
  select postid
  , sum ( case when VoteTypeId=2 then 1 when VoteTypeId=3 then -1 else 0 end ) vcnt
  from votes 
  group by postid
)

select top 40 vcnt as 'Net Vote Count', v.postid AS [Post Link],p.body
from vote_counts v 
inner join posts p on p.id=v.postid
where PostTypeId = 1 
order by vcnt asc

fork query

edited sep 14 anonymous

created jun 3 11 jon.doe5752