0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited nov 1 14 tohecz

created sep 9 12 KevinN