postgresql7.2
SELECT
i.item_id,
repeat(:indent_pattern, (tree_level(i.tree_sortkey) - 2)* :indent_factor) as indent,
t.folder_id,
t.content_type,
p.project_name,
p.project_folder_id,
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 cr_items i, cr_folder_type_map t, pm_projectsx p
WHERE t.content_type = 'pm_project' AND
i.item_id = t.folder_id AND
p.project_folder_id = t.folder_id
ORDER BY i.tree_sortkey