服务器未知运行时异常: 
### 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 'SELECT sample_id
        FROM business_lab_executive_info
        WHERE is_del =' at line 32
### 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         orderId,sampleId,sampleName,sampleModel,manufacturingNo,appendixDescn,measureContent,remark,sampleStatus,customerName,measurePeriod,         validDeadline,measureLastTime,sampleNo,orderNo,customerNo         FROM (             SELECT sample_name AS "sampleName",sample_no AS "sampleNo",sample_model AS "sampleModel",manufacturing_no AS             "manufacturingNo",appendix_descn AS "appendixDescn",remark,customer_name AS "customerName",measure_period AS             "measurePeriod",valid_deadline AS validDeadline,measure_last_time AS             "measureLastTime",create_time,id,measure_content AS             "measureContent"             FROM customer_sample_info             WHERE is_del=0                                                   )csi         JOIN (             SELECT sample_status AS "sampleSatus",sample_id as "sampleId",order_id AS "orderId",order_code AS "orderNo"             FROM business_order_sample_relation bosr             JOIN (             SELECT id,order_code,customer_no             FROM business_order             WHERE is_del=0                                                                     AND status='2'              )bo ON bo.id=bosr.order_id         AND (sample_status ='1' OR sample_status ='2')               AND sample_id NOT IN                   SELECT sample_id         FROM business_lab_executive_info         WHERE is_del = 0           AND (measure_status = '3'             OR measure_status = '4'             OR measure_status = '5')                  )bor ON bor.sampleId=csi.id) 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 'SELECT sample_id
        FROM business_lab_executive_info
        WHERE is_del =' at line 32
; 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 'SELECT sample_id
        FROM business_lab_executive_info
        WHERE is_del =' at line 32