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


京公网安备 11010502036488号