select 

data_date as riqi,

if(toDate(subtractMinutes(now(),510)) = toDate(riqi) ,dateDiff('hour' ,now() ,addMinutes(toDate(riqi),1950)) ,1)  as "剩余工作时间"

from (

select 

data_date,

formatDateTime(prod_time_range,'%Y-%m-%d %H:%M:%S') as riqi

from zh_ads.ads_zzqlc_produce_detail final 

where 1=1 

${if(len(起始时间)==0,"","and data_date >= ('" + 起始时间 +"')")}

${if(len(结束时间)==0,"","and data_date <= ('" + 结束时间 +"')")})

IF里的riqi字段用的是子查询里的prod_time_range,还是主查询里data_date as riqi这个字段？