id_, name_, type_, unit_, total_num_, usable_num_, repair_num_, scrap_num_, distribute_time_, memo_, sn_, is_dele_, create_by_, create_org_id_, create_time_, update_org_id_, update_by_, update_time_, last_time_, org_id_, org_name_, warehouse_location_ SELECT type_ as type,count(*) as count FROM biz_train_equipment_data WHERE is_dele_ ='0' org_id_ = #{vo.orgId} GROUP BY type_