select grantee_id, privilege from acs_permissions where object_id = :on_which_calendar select recurrence_id from acs_events where event_id= :cal_item_id update acs_activities set name = :name, description = :description where activity_id in ( select activity_id from acs_events where event_id = :cal_item_id ) select interval_id from timespans where timespan_id in ( select timespan_id from acs_events where event_id = :cal_item_id ) select recurrence_id from acs_events where event_id= :event_id update acs_activities set name = :name, description = :description where activity_id in ( select activity_id from acs_events where recurrence_id = :recurrence_id ) update acs_events set name= :name, description= :description where recurrence_id= :recurrence_id update cal_items set item_type_id= :item_type_id where cal_item_id in (select event_id from acs_events where recurrence_id= :recurrence_id)