update acs_events set recurrence_id= :recurrence_id where event_id= :cal_item_id insert into cal_items (cal_item_id, on_which_calendar) select event_id, (select on_which_calendar as calendar_id from cal_items where cal_item_id = :cal_item_id) from acs_events where recurrence_id= :recurrence_id and event_id <> :cal_item_id 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 ) update acs_events set name = :name, description = :description 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 [join $colspecs ", "] where cal_item_id in (select event_id from acs_events where recurrence_id = :recurrence_id)