select sum(c.read_num)/sum(c.show_num) as fans_ctr from c left join b on c.content_id=b.content_id left join a on b.author_id=a.author_id where c.fans_id=a.fans_id