select
pretty_name
from
acs_object_types
where
object_type = :content_type
select
label, mime_type
from
cr_mime_types
where
not exists ( select 1
from
cr_content_mime_type_map
where
mime_type = cr_mime_types.mime_type
and
content_type = :content_type )
order by
label
select
label, m.mime_type
from
cr_mime_types m, cr_content_mime_type_map map
where
m.mime_type = map.mime_type
and
map.content_type = :content_type
order by
label