diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml
index 267638d..d5e402d 100644
--- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml
+++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml
@@ -34,9 +34,6 @@
         <include refid="Join_Table"/>
         LEFT JOIN ter_device_monitoring_data_realtime tb ON ta.sn = tb.sn
       where 1=1 and ta.del_flag = 0
-<!--        <if test="request.userId != null and request.userId != ''">-->
-<!--            and pu.user_id = #{request.userId}-->
-<!--        </if>-->
         <if test="request.projectName != null and request.projectName != ''">
             and pu.project_name  like concat('%',#{request.projectName},'%')
         </if>
@@ -71,6 +68,9 @@
             </foreach>
         </if>
 
+        <if test="request.userId != null and request.userId != ''">
+            and pu.user_id = #{request.userId}
+        </if>
         <choose>
             <when test="request.orderBy != null and request.orderBy != ''">
                 order by ${request.orderBy}
@@ -84,9 +84,8 @@
 
     <sql id="Join_Table">
         <if test="request.userId != null and request.userId != ''">
-            and pu.user_id = #{request.userId}
+            left join ter_project_user pu on ta.project_code = pu.project_code
         </if>
-        INNER JOIN ter_project_user pu ON ta.project_code = pu.project_code AND pu.user_id = #{request.userId}
     </sql>
 
     <update id="updateMonitorDevice">