部分sql 不能格式化

studio版本1.1.0，点击格式化，没有效果， SQL为：
with j_trip as (select * from (select biz_id, app_id, user_id, trip_no, fellow_no, in_voucher_no, out_voucher_no, in_time, out_time, in_line_name, out_line_name, in_station_name, in_station_no, out_station_name, out_station_no, out_confirm_type, trip_sts_seq, service_id, trip_sts, sub_app_id, op_id, row_number() over(partition by trip_no, fellow_no, biz_id order by trip_sts_seq desc) rk2 from (select biz_id, app_id, user_id, trip_no, fellow_no, in_voucher_no, out_voucher_no, in_time, out_time, in_line_name, out_line_name, in_station_name, in_station_no, out_station_name, out_station_no, out_confirm_type, trip_sts_seq, service_id, trip_sts, sub_app_id, op_id, row_number() over ( partition by trip_no, fellow_no, biz_id, trip_sts_seq order by offset_id desc ) rk1 from fdm.f_csm_j_trip_sync_all where service_id = 'METRO' and user_id in ('1' ) and recv_time between '2025-02-27' and '2025-05-28' ) a where rk1 = 1 ) b where rk2 = 1), j_trip_order as (select order_no, biz_id, trip_no, fellow_no, ttsp_order_no, trip_sts_seq, base_amount, trans_amount, discount_amount, fine_amount from (select *, row_number() over ( partition by ttsp_order_no order by offset_id desc ) rk from (select b.order_no, b.biz_id, b.trip_no, b.fellow_no, b.ttsp_order_no, b.trip_sts_seq, b.base_amount, b.trans_amount, b.discount_amount, b.fine_amount, 1 offset_id from (select * from fdm.f_csm_j_trip_order where recv_time between '2025-02-27' and '2025-05-28' ) b join j_trip a on a.biz_id = b.biz_id and a.trip_no = b.trip_no and a.fellow_no = b.fellow_no and a.trip_sts_seq = b.trip_sts_seq union all select b.order_no, b.biz_id, b.trip_no, b.fellow_no, b.ttsp_order_no, b.trip_sts_seq, b.base_amount, b.trans_amount, b.discount_amount, b.fine_amount, offset_id from fdm.f_csm_j_trip_order_flink_load b join j_trip a on a.biz_id = b.biz_id and a.trip_no = b.trip_no and a.fellow_no = b.fellow_no and a.trip_sts_seq = b.trip_sts_seq) b) x where rk = 1), t_trip_consume_notify as (select order_no, uo_order_status, uo_trade_amt from (select order_no, send_status uo_order_status, settlement_amount uo_trade_amt, row_number() over ( partition by order_no order by offset_id desc ) rk from fdm.f_csm_t_trip_consume_notify_all where user_id in ('1' ) and create_time between '2025-02-27' and '2025-05-28' ) a where rk = 1), t_trip_refund_notify as (select order_no, uo_refund_status from (select order_no, send_status uo_refund_status, row_number() over ( partition by order_no order by offset_id desc ) as rk from fdm.f_csm_t_trip_refund_notify_all where create_time between '2025-02-27' and '2025-05-28' ) a where rk = 1), t_consume_info as (select order_no, zg_order_no, zg_order_status, actual_trans_amt from (select order_no, buss_no zg_order_no, order_status zg_order_status, trans_amount actual_trans_amt, row_number() over ( partition by order_no order by offset_id desc ) as rk from (select * from fdm.f_csm_t_consume_info_all where user_id in ('1' ) and create_time between '2025-02-27' and '2025-05-28' ) temp) a where rk = 1), res_mess as (select a.biz_id, a.app_id, a.user_id, a.trip_no, a.fellow_no, a.in_voucher_no, a.out_voucher_no, date_format(a.in_time, '%Y-%m-%d %H:%i:%s') in_time, date_format(a.out_time, '%Y-%m-%d %H:%i:%s') out_time, a.in_line_name, a.out_line_name, a.in_station_name, a.in_station_no, a.out_station_name, a.out_station_no, a.out_confirm_type, a.service_id, a.trip_sts, a.sub_app_id, a.op_id, b.ttsp_order_no, b.order_no, b.base_amount, b.trans_amount, b.discount_amount, b.fine_amount, e.zg_order_no, e.zg_order_status, e.actual_trans_amt, c.uo_order_status, c.uo_trade_amt, d.uo_refund_status from j_trip a left join j_trip_order b on a.biz_id = b.biz_id and a.trip_no = b.trip_no and a.fellow_no = b.fellow_no left join t_trip_consume_notify c on b.ttsp_order_no = c.order_no left join t_trip_refund_notify d on b.ttsp_order_no = d.order_no left join t_consume_info e on b.ttsp_order_no = e.order_no where a.trip_sts_seq = b.trip_sts_seq or b.trip_no is null) select * from res_mess WHERE 1 = 1 order by ifnull(in_time,out_time) desc limit 0,50