Q&A for professional and enthusiast programmers
select * from votetypes left join ( select count(*) as num, votetypeid from votes where postid = 194812 group by votetypeid) a on a.votetypeid = votetypes.id