select
wmsys.wm_concat(sdt.nsrsbh)nsrsbh,
wmsys.wm_concat(sdn.nsrmc)nsrmc,sy.bdcdyh,
wmsys.wm_concat(sdt.tdzldz) tdzldz,
wmsys.wm_concat(sdt.tdsyzbh) tdsyzbh
from (
select sds.* from sw_data_sy sds
where sds.bdcdyh in (select wgz.bdcdyh from wf_gis_zd wgz where wgz.del_flag!='1')
) sy
left join sw_data_tdsy sdt on sdt.sy_id=sy.id
left join sw_data_nsr sdn on sdn.id=sdt.nsr_id
group by sy.bdcdyh