Q&A about the site for administrators, end users, developers and designers for Craft CMS
WITH a AS ( SELECT OwnerUserId, CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END Upvote, CASE WHEN VoteTypeId = 3 THEN 1 ELSE 0 END Downvote, CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END Questionvote, CASE WHEN PostTypeId = 2 THEN 1 ELSE 0 END Answervote FROM Posts p INNER JOIN Votes v ON v.PostId = p.Id ) Select top 10000 sum(Answervote*(Upvote-Downvote)) as AnswerScore, OwnerUserId As [User Link], sum(Questionvote*(Upvote-Downvote)) as QuestionScore from a Group By OwnerUserId Order By sum(Answervote*(Upvote-Downvote)) desc