postgresql7.1 select r.rel_id, r.related_object_id as item_id, t.pretty_name as type_name, coalesce(r.relation_tag, '-') as tag, trim(coalesce(content_item__get_title(r.related_object_id,'f'), i.name)) as title, ot.pretty_name as content_type from cr_item_rels r, acs_objects o, acs_object_types t, cr_items i, acs_object_types ot where r.item_id = :item_id and o.object_id = r.rel_id and t.object_type = o.object_type and i.item_id = r.related_object_id and ot.object_type = i.content_type order by order_n, title