id_, type_, name_, mf_code_, person_liable_, battle_code_, org_id_, org_, loading_time_, unit_, zjqf_, status_, memo_, sn_, is_dele_, create_by_, create_org_id_, create_time_, update_org_id_, update_by_, update_time_, last_time_ SELECT type_ as type,count(*) as count FROM biz_equipment_base_data WHERE is_dele_ ='0' org_id_ = #{vo.orgId} GROUP BY type_