diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusWellInfoMapper.xml b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusWellInfoMapper.xml
index dbbed5e..5e0e1fb 100644
--- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusWellInfoMapper.xml
+++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/BusWellInfoMapper.xml
@@ -65,8 +65,13 @@
         COALESCE (devicecount,0) AS "deviceCount"
         FROM bus_well_info w
         LEFT JOIN
-        (SELECT COUNT(1) AS devicecount,well_id
-        FROM bus_device_well d WHERE d.VALID = '1' GROUP BY well_id) c
+        (
+            SELECT COUNT(1) AS devicecount,well_id
+            FROM bus_device_well d
+            JOIN bus_device  bd ON  bd.id=d.device_id
+            WHERE bd.VALID = '1'
+            GROUP BY well_id
+        ) c
         ON w.id = c.well_id
         WHERE w.VALID = '1'
         <if test="wellType != null and wellType !=''">