四表作左连接

select sum(comment_sum) comment_sum,sum(view_sum) view_sum,sum(praise_sum) 
from tb_xyh_dynamicinfo a 
left join 
(select DYNAMICINFO_ID,count(1) as comment_sum 
from tb_xyh_dynamicinfo_comment  txc
where 1=1 and  txc.CREATE_TIME>='2017-02-01' and txc.CREATE_TIME<='2020-12-25' 
group by DYNAMICINFO_ID) b 
on a.DYNAMIC_INFO_ID = b.dynamicinfo_id 
left join 
(select dynamicinfo_id,count(1) as view_sum from tb_xyh_dynamicinfo_viewcount txv
where 1=1 and  txv.CREATE_TIME>='2017-02-01' and txv.CREATE_TIME<='2020-12-25' 
group by dynamicinfo_id ) c on a.DYNAMIC_INFO_ID = c.DYNAMICINFO_ID
left join 
(select dynamic_info_id,count(1) as praise_sum from news_xyh_praise nxp
where 1=1 and  nxp.CREATE_TIME>='2017-02-01' and nxp.CREATE_TIME<='2020-12-25' 
group by dynamic_info_id ) d on a.DYNAMIC_INFO_ID = d.dynamic_info_id
where 1=1 
-- and TITLE like '%2019.1.25周五OKR胜利会议回顾！%'
order BY  title DESC