Total votes on you

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

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

Enter Parameters

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