SELECT
        *,
        ( CASE WHEN t.if_color_num = 0 THEN 1 WHEN t.order_count = t.if_color_num THEN 2 ELSE 3 END ) color_type
        FROM (
        SELECT
        a.order_name,
        a.order_id,
        a.cust_id,
        a.use_type,
        a.state,
        a.create_time,
        a.state_date,
        a.dev_id,
        a.print_class,
        a.exec_print_flag,
        a.checked_flag,
        a.station_ver,
        g.pay_method,
        g.amount,
        g.bean_amt,
        g.channel_amt,
        (SELECT mobile FROM t_cust cust WHERE cust.cust_id = a.cust_id) mobile,
        d.station_id,
        d.station_name,
        d.merchant_id,
        d.set_id,
        e.merchant_name,
        e.merchant_short_name,
        g.return_amt AS return_fee,
        s.set_name,
        a.checked_ops_name,
        a.checked_time,
        a.print_mode,
        ( SELECT w.total_set_name FROM t_total_set w WHERE w.total_set_id = s.total_set_id ) total_set_name,
        ( SELECT SUM( g.printed_page ) FROM t_order_file g WHERE g.order_id = a.order_id ) printed_page,
        ( SELECT SUM(CEILING(g.page_num / g.shrink_plate_num) * g.copy_num) FROM t_order_file g WHERE g.order_id =
        a.order_id ) page_num,
        ( SELECT SUM( g.if_color ) FROM t_order_file g WHERE g.order_id = a.order_id ) if_color_num,
        ( SELECT COUNT( 1 ) FROM t_order_file g WHERE g.order_id = a.order_id ) order_count,
        '' AS startPage,
        '' AS endPage,
        ( SELECT GROUP_CONCAT(CONCAT(t.file_id, ':', t.err_msg) SEPARATOR ';$$$') FROM t_order_file_msg t WHERE
        t.order_id =
        a.order_id
        AND err_msg != '') errMsgConcat,
        ( SELECT GROUP_CONCAT(CONCAT('退款描述',t.return_id,':', t.problem_desc) SEPARATOR ';$$$') FROM t_order_return t
        WHERE t.order_id = a.order_id
        AND problem_desc != '') problemDescConcat
        FROM
        t_order a
        LEFT JOIN t_station d ON a.station_id = d.station_id
        LEFT JOIN t_device c ON a.dev_id = c.dev_id
        LEFT JOIN t_set s ON a.set_id = s.set_id
        LEFT JOIN t_merchant e ON s.merchant_id = e.merchant_id
        LEFT JOIN t_pay g ON a.pay_id = g.pay_id
        WHERE
        1 = 1                                         
             AND a.create_time >= '2025-09-23 00:00:00'                 
             AND a.create_time <= '2025-09-23 23:59:59'                                  
            AND (
            EXISTS (SELECT 1 FROM t_order_file_msg s WHERE s.order_id = a.order_id AND s.err_msg!='' AND s.err_msg LIKE
            CONCAT('%','重复','%'))
            OR EXISTS (SELECT 1 FROM t_order_return s WHERE s.order_id = a.order_id AND s.problem_desc!='' AND
            s.problem_desc LIKE
            CONCAT('%','重复','%'))
            )                                             
            AND a.station_id IS NOT NULL         
        ) t WHERE 1=1
        ORDER BY create_time DESC, order_id DESC LIMIT 0,30