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
|