服务器未知运行时异常: 
### 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 ') TOTAL' at line 27
### The error may exist in file [D:\code\xuzhou\casic-metering\casic-metering-dao\target\classes\mapper\business\BusinessCertificateReportMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) FROM (SELECT         bcr.*,         csi.sample_no AS sampleNo,         csi.sample_name AS sampleName,         csi.sample_model AS sampleModel,         csi.manufacturing_no AS manufacturingNo,         csi.measure_category AS measureCategory,         bo.order_code AS orderCode,         su.name AS measurePersonName         FROM business_certificate_report bcr         LEFT JOIN business_order bo         ON bcr.order_id=bo.id         LEFT JOIN customer_sample_info csi         ON bcr.sample_id=csi.id         LEFT JOIN sys_user su         ON bcr.measure_person_id=su.id         WHERE bcr.is_del = 0         AND approval_status = ?         AND bcr.create_user = ?                                                                                   and bcr.id in) 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 ') TOTAL' at line 27
; 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 ') TOTAL' at line 27