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