翻译以下代码 <select id="getExistCount" resultMap="baseRm"> select * from (select * from (select vsci.validate_sim_card_id,vsci.device_code,vsci.manufacturer_id, vsci.protocol_name,vsci.device_type,vsci.device_type_name,vsci.appkey from iledproduction.validate_sim_card_info vsci where vsci.manufacturer_id in <foreach collection="manufacturerIdList" item="item" index="index" open="(" close=")" separator=","> #{item} </foreach> <if test="propMap.size>0 and propMap!=null"> <foreach collection="propMap" index="index" item="item"> <if test='index.toString=="device_type"'> and vsci.device_code = "${item[1]}" </if> </foreach> </if>)a left join (select psi.station_name,psi.appkey as appkey_b,psi.department_key from iledproduction.production_station_info psi ) b on a.appkey=b.appkey_b )c left join (select dp.department_name,dp.department_key as department_key_d from iledproduction.department dp )d on c.department_key=d.department_key_d <if test="propMap.size>0 and propMap!=null"> <foreach collection="propMap" index="index" item="item"> <if test='index.toString=="manufacturer_id"'> where vsci.manufacturer_id = ${item[1]} </if> </foreach> </if> limit #{firstResult},#{maxResults} </select>
时间: 2023-12-21 10:07:46 浏览: 27
```sql
SELECT *
FROM (
SELECT *
FROM (
SELECT vsci.validate_sim_card_id, vsci.device_code, vsci.manufacturer_id, vsci.protocol_name, vsci.device_type, vsci.device_type_name, vsci.appkey
FROM iledproduction.validate_sim_card_info vsci
WHERE vsci.manufacturer_id IN
<foreach collection="manufacturerIdList" item="item" index="index" open="(" close=")" separator=",">
#{item}
</foreach>
<if test="propMap.size > 0 and propMap != null">
<foreach collection="propMap" index="index" item="item">
<if test='index.toString == "device_type"'>
AND vsci.device_code = "${item[1]}"
</if>
</foreach>
</if>
) a
LEFT JOIN (
SELECT psi.station_name, psi.appkey AS appkey_b, psi.department_key
FROM iledproduction.production_station_info psi
) b ON a.appkey = b.appkey_b
) c
LEFT JOIN (
SELECT dp.department_name, dp.department_key AS department_key_d
FROM iledproduction.department dp
) d ON c.department_key = d.department_key_d
<if test="propMap.size > 0 and propMap != null">
<foreach collection="propMap" index="index" item="item">
<if test='index.toString == "manufacturer_id"'>
WHERE vsci.manufacturer_id = ${item[1]}
</if>
</foreach>
</if>
LIMIT #{firstResult}, #{maxResults}
```