diff --git a/src/main/resources/mapper/smartwell/SmartwellDataMapper.xml b/src/main/resources/mapper/smartwell/SmartwellDataMapper.xml
index d247b8d..801f20e 100644
--- a/src/main/resources/mapper/smartwell/SmartwellDataMapper.xml
+++ b/src/main/resources/mapper/smartwell/SmartwellDataMapper.xml
@@ -37,12 +37,18 @@
     </select>
 
     <select id="countDeviceByType" resultType="Map">
-        SELECT  count(*)  AS  count,DEVICE_TYPE AS "deviceType"
-        FROM bus_device  bd
-		JOIN BUS_DEVICE_WELL   bdw   on   bdw.device_id=bd.id
-		join bus_well_info  bwi  on   bwi.id=bdw.well_id
-		WHERE  bd.valid=1 AND bwi.valid=1
-        GROUP BY  DEVICE_TYPE
+        SELECT COUNT( * ) AS COUNT,
+        DEVICE_TYPE AS "deviceType"
+        FROM
+            bus_device bd
+            JOIN BUS_DEVICE_WELL bdw ON bdw.device_id = bd.ID
+            JOIN bus_well_info bwi ON bwi.ID = bdw.well_id
+        WHERE
+            bd.valid = '1'
+            AND bdw."valid"='1'
+            AND bwi.VALID = '1'
+        GROUP BY
+            DEVICE_TYPE
     </select>
 
     <select id="countAlarmByRoad" resultType="Map">