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