Controversial edits by user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @userid as int = ##UserId:int##

select
    SuggestedEditId as [Suggested Edit Link],
    up = sum(case when VoteTypeId = 2 then 1 else 0 end), 
    down = sum(case when VoteTypeId = 3 then 1 else 0 end)
from SuggestedEditVotes
where TargetUserId = @userid
group by SuggestedEditId

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results