WITH market_list AS (

SELECT

( u.name ) AS name,

u.dm_admin_id,

u.id AS 匹配填报系统 ID,

d.DepartmentID,

d.ParentID,

u.join_time,

u.status,

d.Level,

d.DivisionID,

CASE

WHEN dm_admin_id = 168 THEN

1.1 

WHEN t1.Name = '暴富星球' THEN

2.1 

WHEN t1.Name = '多金星球' THEN

2.2 

WHEN t1.Name = '招财组' THEN

2.3 

WHEN t1.Name = '进宝组' THEN

2.4 

WHEN t1.Name = '大富组' THEN

2.5 

WHEN t1.Name = '财源滚滚' THEN

2.6 

WHEN t1.Name = '旺旺星球' THEN

3 

WHEN t1.Name = '玫瑰星云' THEN

4 ELSE 99 

END 排序 ,

CASE

WHEN t1.Name IS NULL THEN

u.Name ELSE t1.Name 

END 一级部门 ,

CASE

WHEN d.DepartmentID IS NULL THEN

'' #有些人二级部门直接用名字 1310、1311、1269 

WHEN d.DepartmentID IN ( 1310, 1311, 1269 ) THEN

u.name 

WHEN d.ParentID = 0 THEN

d.Name ELSE d.Name 

END 二级部门 ,

CASE

WHEN ( ParentID != 1269 AND d.DepartmentID != 1269 ) # kalika 和旺旺星球做的国际业务 

OR dm_admin_id = 168 THEN

'International' 

WHEN ParentID = 1269 

OR d.DepartmentID = 1269 THEN

'Local' ELSE '其他' 

END 原始部门 

FROM

duomai_cps.users AS u

LEFT JOIN duomai_cps.departments AS d ON u.department_id = d.DepartmentID

LEFT JOIN ( SELECT DepartmentID, Name FROM duomai_cps.departments WHERE LEVEL = 1 ) AS t1 ON u.department_id = t1.DepartmentID 

OR d.ParentID = t1.DepartmentID 

WHERE

( d.DivisionID = 114 # 114 = moneverse市场 OR u.id = 2573 ) #市场部最大的领导 

AND dm_admin_id != 0 #有订单的人 

AND d.DeleteAt IS NULL 

ORDER BY

排序, 二级部门,

join_time 

) 

SELECT

drs.ads_id AS '计划id',

drs.date AS '下单日期（日）',

date_format ( drs.date, '%Y-%m' ) '年月',

drs.our_commission AS '广告主佣金',

drs.market_id AS '市场ID',

dm_ads.id AS '计划ID',

dm_ads.title AS '计划名',

dm_ads.adser_id AS '广告主id',

daas.labels AS '业务线',

market_list.name AS '市场名',

market_list.一级部门,

market_list.二级部门 

FROM

dm_report_site drs

LEFT JOIN duomai_cps.dm_ads ON drs.ads_id = dm_ads.id

LEFT JOIN duomai_cps.dm_adser_additional_settings AS daas ON dm_ads.adser_id = daas.adser_id

LEFT JOIN market_list ON drs.market_id = market_list.dm_admin_id 

WHERE

drs.date >= '${下单时间开始}' 

AND drs.date <= '${下单时间结束}'

删除这个分号

检查一下，date 字段是日期类型吗？控件返回值是字符串吗？可能是格式不一致的问题。

你这个是什么写法