select calendar_id from calendars where private_p = 'f' and package_id = :community_package_id select cal_item_id from evaluation_cal_task_map where task_item_id = :item_id update cr_revisions set content = :filename, mime_type = :mime_type, content_length = :content_length where revision_id = :revision_id insert into evaluation_cal_task_map ( task_item_id, cal_item_id ) values ( :item_id, :cal_item_id ) select task_id from evaluation_tasks where task_id=:task_id and due_date is null update evaluation_tasks set points=:points,perfect_score=:perfect_score,relative_weight=:relative_weight,forums_related_p=:forums_related_p where task_id=:revision_id