Up and down vote count for user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Unix and Linux

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems.

select VoteTypeId as type,count(*) from Votes v
where VoteTypeId in (2,3) and v.PostId in (
   select p.id from posts p where p.posttypeid=1 and p.OwnerUserId=##USERID##
) GROUP BY VoteTypeId

Enter Parameters

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