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 about the site for administrators, end users, developers and designers for Craft CMS

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

select top 20 count(v2.id)-count(v.id) as 'Vote count', p.id AS [Post Link],p.body
from posts p
left join votes v ON (v.postid=p.id AND v.VoteTypeId=3)
left join votes v2 ON (v2.postid=p.id AND v.VoteTypeId=2)
where PostTypeId = 2
group by p.id, p.body
order by 'Vote count' desc

fork query

edited jun 25 13 anonymous

created jun 3 11 jon.doe5752