SELECT a.cameraId FROM sp_device_camera a WHERE a.serialNumber = #{serialNumber} limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT a.serialNumber ,CONCAT(a.cameraId,'') AS cameraId ,a.fullName ,a.factory ,a.ipAddress ,a.ipAddress6 ,a.longitude ,a.latitude ,a.installAreaCode ,a.installAddress ,a.controlOrg ,a.controlOrgCode ,a.dataType ,a.deviceCameraType ,a.monitorDirection ,a.monitorArea ,a.cameraPositionType ,a.cameraUse FROM base_camera a INNER JOIN sp_activity_camera_total b ON a.cameraId = b.deviceCameraId LEFT JOIN sp_activity c ON b.activityId = c.id WHERE c.activityNo = #{activityNo} AND ( a.serialNumber like CONCAT('%', #{keywords}, '%') OR a.fullName like CONCAT('%', #{keywords}, '%') OR a.monitorDirection like CONCAT('%', #{keywords}, '%') OR a.controlOrg like CONCAT('%', #{keywords}, '%') OR a.controlOrgCode like CONCAT('%', #{keywords}, '%') ) AND a.deviceCameraType = #{deviceCameraType}