select count(messages) as nb_messages, sum(count_comments) as nb_comments from (
	select cm.message_id as messages, count(comment_id) as count_comments
	from client_messages as cm left join comments as c on cm.message_id=c.message_id
	group by cm.message_id
) as t;