ID_, CONTRACT_CODE_, CONTRACT_NAME_, CONTRACT_TYPE_, SIGN_DATE_, START_DATE_, END_DATE_, PERSON_LIABLE_, CONTRACT_STATUS_, MEMO_, IS_DELE_, CREATE_BY_, CREATE_TIME_, UPDATE_BY_, UPDATE_TIME_, VERSION_, LAST_TIME_ SELECT s.*, c.COMPANY_NAME_ AS companyName FROM device_base_contract s LEFT JOIN device_relation_supplier_contract rsc ON rsc.CONTRACT_ID_ = s.ID_ LEFT JOIN device_base_company c ON c.id_ = rsc.COMPANY_ID_ ${ew.customSqlSegment} WHERE AND s.IS_DELE_ = 0 SELECT d.* FROM device_base_contract d LEFT JOIN device_relation_contract rg on rg.contract_id_ = d.id_ where rg.device_id_ = #{deviceId}