Q&A for professional and enthusiast programmers
select sum(a.score * 10) from Posts a inner join posts q on a.parentid = q.id inner join posthistory ph on a.parentid = ph.postid inner join closereasontypes cr on ph.comment = cr.id where q.closeddate is not null and ph.posthistorytypeid = 10 and ph.comment != 101 and ph.comment != 1 and a.owneruserid = ##UserId##