select S.content
, SUM(C.clickTimes) as total
from subVote S left join clickCount C ON C.subID=S.id where S.ParentID=7"
group by S.content
, SUM(C.clickTimes) as total
from subVote S left join clickCount C ON C.subID=S.id where S.ParentID=7"
group by S.content
from subvote s where s.parentid=7
group by s.content