diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessSiteExecutiveLogMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessSiteExecutiveLogMapper.xml
index b282ac7..c872cd2 100644
--- a/casic-metering-dao/src/main/resources/mapper/business/BusinessSiteExecutiveLogMapper.xml
+++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessSiteExecutiveLogMapper.xml
@@ -36,6 +36,7 @@
             JOIN(
                 SELECT customer_name AS customerName,id AS customerId
                 FROM customer_info
+                where is_del=0
                 <if test="request.customerName != null and request.customerName !=''">
                     and customer_name like concat('%', #{request.customerName}, '%')
                 </if>