1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems

SELECT
  ##UserId## as [User Link],
  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 22 14 tohecz

created sep 9 12 KevinN