文章列表
select ext, count(1) from t_cmp_type_fileentity entity where exists
(
select 1 from t_cmp_type_fileinformation info, t_cmp_ref_fileinfo_fileentity relation where mimetype = 'none'
and info.objectid = relation.source_id and entity.objectid = relation.target_id
)
group by ext;