0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- Enter Query Title
-- Enter Query Description

select top 10 Posts.Title, COUNT(UpVotes.ID) as Upvote, COUNT(DownVotes.ID) as Downvote
from posts 
  left outer join (select * from Votes where VoteTypeId = 2) UpVotes on
                   Posts.Id = UpVotes.PostID
  left outer join (select * from Votes where VoteTypeId = 3) DownVotes on
                   Posts.Id = DownVotes.PostID
group by Posts.ID, Posts.Title
order by COUNT(UpVotes.ID)+COUNT(DownVotes.ID) desc

fork query

created jan 17 11 anonymous