服务器未知运行时异常: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY csi.deliverer DESC) TOTAL' at line 22
### The error may exist in file [D:\cz\203\徐州计量\code\casic-metering\casic-metering-dao\target\classes\mapper\customer\CustomerSampleMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) FROM (SELECT  order_id AS "orderId",order_code AS  "orderCode",order_time AS   orderTime,         customer_no AS customerCode,customer_name AS "customerName",deliverer,real_deliver_time AS "deliverTime"         FROM         (             SELECT  id             FROM customer_sample_info csi             WHERE csi.id=?             AND  csi.is_del =0         )csi         JOIN         (            SELECT sample_id,order_id,real_deliver_time            FROM  business_order_sample_relation            WHERE sample_id =?         )bosr   ON  bosr.sample_id=csi.id         JOIN (            SELECT *            FROM  business_order            WHERE sample_id =?         )bo  ON  bo.id=bosr.order_id         WHERE         ORDER BY csi.deliverer DESC) TOTAL
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY csi.deliverer DESC) TOTAL' at line 22
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY csi.deliverer DESC) TOTAL' at line 22