postgresql7.1 select spf.folder_id, case when spf.folder_id = :root_folder_id then '[acs_root_dir]/www/' else content_item__get_title(spf.folder_id)||'/' end as folder_name, static_page__five_n_spaces(lev) as spaces, static_page_id, substr(filename,instr(filename,'/',-1)+1) as filename, case when p_file.grantee_id is NULL then 'not commentable' else 'commentable' end as file_permission, case when show_comments_p = 't' then 'comments displayed' else 'comments summarized' end as display_policy, case when p_folder.grantee_id is NULL then 'children not commentable' else 'children commentable' end as folder_permission FROM ((static_pages sp RIGHT OUTER JOIN (select s1.folder_id, tree_level(s1.tree_sortkey) as lev from sp_folders s1, sp_folders s2 where s2.folder_id = :root_folder_id and s1.tree_sortkey between s2.tree_sortkey and tree_right(s2.tree_sortkey) ) as spf ON spf.folder_id = sp.folder_id) LEFT OUTER JOIN acs_permissions p_file ON (p_file.grantee_id = acs__magic_object_id('the_public') and p_file.privilege = 'general_comments_create' and p_file.object_id = sp.static_page_id)) LEFT OUTER JOIN acs_permissions p_folder ON (p_folder.grantee_id = acs__magic_object_id('the_public') and p_folder.privilege = 'general_comments_create' and p_folder.object_id = spf.folder_id)