postgresql7.1 select a.attribute_id, a.attribute_name, a.pretty_name, a.pretty_plural, a.datatype, t.pretty_name as object_pretty_name from acs_attributes a, acs_object_types t where t.object_type in (select ot1.object_type from acs_object_types ot1, acs_object_types ot2 where ot2.tree_sortkey between tree_left(ot1.tree_sortkey) and tree_right(ot1.tree_sortkey) and ot2.object_type = :object_type) and a.object_type = t.object_type order by t.tree_sortkey desc, a.sort_order asc;