update cr_items set $update_string where item_id = :folder_id update cr_folders set label = :label where folder_id = :folder_id select i.name, i.parent_id, f.label, f.description, f.has_child_folders, f.has_child_symlinks, f.package_id from cr_folders f, cr_items i where f.folder_id = :folder_id and i.item_id = f.folder_id select folder_id from cr_folders where package_id = :package_id select f.folder_id from cr_folders f, cr_items i where f.package_id = :package_id and i.item_id = f.folder_id and i.parent_id = :parent_id