Total votes on you

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

SELECT
  votetype.name as type,
  post.posttypeid as posttype,
  count(*) as count
FROM
    votetypes as votetype
  inner join
    votes as vote
   on 
    vote.votetypeid = votetype.id
  inner join
    posts as post
   on
    vote.postid = post.id AND post.owneruserid = ##userid##
GROUP BY
  votetype.name, post.posttypeid

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results