Q&A about the site for professional and independent game developers
-- Vote count by type SELECT COUNT(1), vt.Name FROM Votes v INNER JOIN VoteTypes vt ON v.VoteTypeId = vt.Id WHERE v.UserId = ##UserId## GROUP BY vt.Name