postgresql7.2 SELECT p.item_id, p.project_id, repeat(:indent_pattern, (tree_level(p.tree_sortkey) - 5)* :indent_factor) as indent, p.parent_id as folder_id, p.object_type as content_type, p.title as project_name, p.project_code, to_char(p.planned_start_date, 'YYYY MM DD') as planned_start_date, to_char(p.planned_end_date, 'YYYY MM DD') as planned_end_date, p.ongoing_p FROM pm_projectsx p, cr_items i WHERE p.project_id = i.live_revision ORDER BY i.tree_sortkey