select
--图片下载数
(select count(1) FROM [down_img_record]) as imgDown
-- 视频下载数
,(select count(1) FROM [down_video_record]) as videoDown
--领导图下载数
,(select count(1) FROM [down_img_record] m
left join img_info i on i.id=m.img_id
where i.exist_leader=1) as leaderDown
--非领导图下载数
,(select count(1) FROM [down_img_record] m
left join img_info i on i.id=m.img_id
where i.exist_leader=0) as other