| 123456789101112131415161718192021222324252627282930313233343536 | 
							-        select
 
-        a.account_id as `账户 `,
 
-        signature   as `视频md5`,
 
-        photo_url as `视频链接`,
 
-        video_name as `视频名称`,
 
-        project_name   `项目名称`,
 
-        clip_name      `剪辑`,
 
-        plan_name      `编导`,
 
-        shot_name      `拍摄`,
 
-        leader_name   `负责人`,
 
-        sum(charge) as `消耗`,
 
-        case when channel_type =0 then '内部' when channel_type=1 then '塑造' else '-' end as `渠道`
 
- from (select account_id,
 
-              signature,
 
-              channel_type,
 
-              project_name,
 
-              leader_name,
 
-              plan_name,
 
-              clip_name,
 
-              shot_name,
 
-              charge,
 
-              clip_company_id,
 
-              photo_url,
 
-              video_name
 
-       from application.kuaishou_material_video_report_daily_dw
 
-       where stat_date between 20220401 and 20220430) a
 
-          inner join (
 
-     select account_id
 
-     from `jeecg-boot`.ctop_user_allocation
 
-     where user_id in (
 
-         select user_id from `jeecg-boot`.user_company where company_id = 'd57fecdcf7a94d009736d9c850731582'
 
-     )
 
- ) b
 
-                    on a.account_id = b.account_id
 
-  where clip_company_id='1648c7ceb4d449a9a13fbed7a8d9976c'
 
- group by signature, a.account_id
 
 
  |