为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8
【操作系统】：
【CPU】:
【问题描述】*：
select a.id,
a.capital_id,
a.room_num,
a.building_id,
d.label as roomType,
e.label as roomUseType,
a.area,
a.unit,
a.remark,
b.name as capitalName,
b.full_name as fullName ,
c.building_num as buildingNum,
a.latitude,
a.longitude,
a.border,
a.img_url,
a.type,
bb.labelName,
bb.labelIds,
(select count(1)
from "ks-saas-base"."base_people_room_relation" rprr
where rprr.room_id = a.id
and rprr.del_flag = 0) as peopleNum
from "ks-saas-base"."base_building_room" a
left join "ks-saas-base"."base_building" c
on a.building_id=c.id
and c.del_flag=0
left join "ks-saas-base"."base_capital" b
on c.community_id = b.id
left join "ks-saas-base"."sys_dict_data" d
on a.room_type = d.value
and d.type = 'base_room_type'
left join "ks-saas-base"."sys_dict_data" e
on a.room_use_type = e.value
and e.type = 'base_room_use_type'
left join (select wm_concat(bl.name) as labelName ,
wm_concat(bl.id) as labelIds ,
room
from "ks-saas-base"."base_label_relation" blr
left join "ks-saas-base"."base_label" bl
on blr.label = bl.id
group by room ) bb
on a.id = bb.room
where a.del_flag = 0
order by a.unit ,
cast(a.room_num as UNSIGNED) asc