select pretty_name, target_type, relation_tag, min_n, max_n from cr_type_relations r, acs_object_types o where o.object_type = r.target_type and r.content_type = :content_type order by pretty_name, relation_tag select pretty_name, child_type, relation_tag, min_n, max_n from cr_type_children c, acs_object_types o where c.child_type = o.object_type and c.parent_type = :content_type order by pretty_name, relation_tag