sql

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;