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)