postgresql7.1 select my_view.group_name, my_view.group_id from (select DISTINCT g.group_name, g.group_id from acs_objects o, groups g, application_group_element_map app_group where g.group_id = o.object_id and o.object_type = :group_type and (app_group.package_id = :package_id and app_group.element_id = g.group_id or o.object_id = -2) and acs_permission__permission_p(g.group_id, :user_id, 'read') order by g.group_name, g.group_id) my_view limit 26