aircraftId, deviceName, deviceNo, aircraftType, brandModel, brandFactory, buyDate, org, orgCode, fullName, idCardNo, longitude, latitude, flyHeight, createOn select from base_aircraft where aircraftId = #{aircraftId,jdbcType=BIGINT} select t.aircraftId, t.deviceName, t.deviceNo, t.aircraftType, t.brandModel, t.brandFactory, t.buyDate, t.org, t.orgCode, t.fullName, t.idCardNo, t.longitude, t.latitude, t.flyHeight, t.createOn from base_aircraft t left join sp_activity_aircraft s on t.aircraftId = s.aircraftId aircraftType=#{aircraftType,jdbcType=VARCHAR} and buyDate>=concat(#{buyStartDate},' 00:00:00') AND ( t.deviceName like CONCAT('%', TRIM(#{keywords}), '%') OR t.deviceNo like CONCAT('%', TRIM(#{keywords}), '%') OR org like CONCAT('%', TRIM(#{keywords}), '%') ) and s.activityId=(select id from sp_activity where activityNo=#{activityNo,jdbcType=VARCHAR})