| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475 | SELECT	(		SELECT			CASE		WHEN media_id = 1 THEN			'头条'		WHEN media_id = 2 THEN			'快手'		WHEN media_id = 3 THEN			'头条内广'		ELSE			''		END		FROM			ctop_project		WHERE			id = t1.project_id	) AS '媒体',	(		SELECT			project_name		FROM			ctop_project		WHERE			id = t1.project_id	) AS '项目',	CONCAT('`',t1.account_id,'`' )  AS '账户id',	(		SELECT			realname		FROM			sys_user		WHERE			id = t1.transferor	) AS '转户人',	(		SELECT			realname		FROM			sys_user		WHERE			id = t1.assignee	) AS '受让人',	t1.transferor_date AS '转户人绩效统计截止日期',	t1.assignee_date AS '受让人绩效统计开始日期'FROM	ctop_transfer_account t1WHERE	t1.transferor_date >= '2022-01-01'AND t1.transferor_date <= '2022-01-31'and t1.transferor in(SELECT user_id  from user_company WHERE company_id = '4b10089775c040119e139087517aed88')ORDER BY	t1.account_id	select company_name,       project_name,       user.realname,       leader.realname,       concat('`',account_id,'`') as account_id,       account_name,       chargefrom (select company_name, project_name, user_id, leader_id, account_id, account_name, charge      from application.app_kuaishou_account_report_busi_m      where stat_mon = 202206        and company_id = '4b10089775c040119e139087517aed88') a         left join `jeecg-boot`.sys_user user                   on a.user_id = user.id         left join `jeecg-boot`.sys_user leader                   on a.leader_id = leader.id
 |