<select id="findContingencyPlan" resultType="cn.com.xx.xx.xx.vo.ContingencyPlanApplyVo">
SELECT
TS. ID
FROM
T_CONTINGENCY_SB ts
LEFT JOIN T_COMPANY_INFO ti ON TS.COMP_ID = TI. ID
LEFT JOIN T_S_USER us ON TS.COMP_ID = US.COMP_ID
LEFT JOIN T_S_TERRITORY tt ON US.TERRITORY_ID = TT. ID
<where>
<if test="cv.compName != null and cv.compName != ''">
AND TI.COMPNAME LIKE '%${cv.compName}%'
</if>
<if test="territoryCode != null and territoryCode != ''">
AND TT.TERRITORYCODE LIKE '%${territoryCode}%'
</if>
</where>
</select>