id_, project_id_, building_name_, building_code_, building_number_, floor_, floor_ground_, floor_underground_, longitude_, latitude_, belongs_org_id_, belongs_org_name_, belongs_org_full_id_, remark_, create_by_, create_name_, create_org_id_, create_org_name_, create_dept_id_, create_dept_name_, create_time_, update_by_, update_name_, update_org_id_, update_org_name_, update_dept_id_, update_dept_name_, update_time_, is_dele_, last_time_, tenant_id_ SELECT b.*,p.project_name_ FROM biz_asset_business_building b LEFT JOIN biz_asset_business_project p on p.id_ = b.project_id_ ${ew.customSqlSegment} SELECT id_,project_name_ as name,project_code_ as code, "project" as type, '0' as parent_id_ FROM biz_asset_business_project WHERE IS_DELE_ = '0' and belongs_org_full_id_ LIKE #{fullId} UNION all SELECT id_,building_name_ as name,building_code_ as code, "building" as type, project_id_ as parent_id_ FROM biz_asset_business_building WHERE IS_DELE_ = '0'