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