<selectid="leftJoinPageList"resultMap="MonitoringDataResult"parameterType="com.ktt.carbon.verification.domain.bo.MonitoringDataBo">
SELECT d.* from carbon_monitoring_data d LEFT JOIN carbon_monitoring_site s on d.site_id=s.id
<where><iftest="bo.siteName != null">
and site_name like concat('%',#{bo.siteName},'%')
</if><iftest="bo.siteNumber != null">
and site_number like concat('%',#{bo.siteNumber},'%')
</if><iftest="bo.siteNumber != null">
and site_number like concat('%',#{bo.siteNumber},'%')
</if></where>
where s.site_name like "%test1%"
</select>