postgresql7.1 select fs.folder_id, fs.package_id, content_item__get_path(fs.folder_id,-100) as url, cf.label, case when d.node_id is not null then 1 else 0 end as dav_enabled_p from fs_root_folders fs left join dav_site_node_folder_map d on d.folder_id = fs.folder_id, cr_folders cf where fs.folder_id=cf.folder_id