select t.pretty_name as group_type_pretty_name
from acs_object_types t
where t.object_type = :group_type
select t.object_type as group_type, t.pretty_name
from acs_object_types t
where t.supertype = :group_type
select rel.rel_type, t.pretty_name
from acs_rel_types rel, acs_object_types t
where (rel.object_type_one = :group_type
or rel.object_type_two = :group_type)
and rel.rel_type = t.object_type
select count(o.object_id)
from acs_objects o
where o.object_type = :group_type
select count(r.rel_id)
from acs_rels r
where r.rel_type in (select t.rel_type
from acs_rel_types t
where t.object_type_one = :group_type
or t.object_type_two = :group_type)