id_, name_, code_, asset_type_, start_date_, end_date_, risk_measures_, loan_status_, belongs_org_id_, belongs_org_name_, belongs_org_full_id_, remark_, asset_audit_, 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_ SELECT asset_type_ AS assetType, IFNULL(count(*), 0) AS count FROM biz_asset_intangible_info WHERE is_dele_ = '0' and asset_audit_ = '2' and belongs_org_full_id_ like '${fullId}%' GROUP BY asset_type_