select u.first_names || ' ' || u.last_name as name, u.email as email from acs_objects ao, cc_users u where ao.object_id = :event_id and ao.creation_user = u.user_id select t.interval_id from time_intervals t, timespans s, acs_events ae where ae.event_id = :event_id and ae.timespan_id = s.timespan_id and s.interval_id = t.interval_id select to_char($which_date,'$date_format') from time_intervals t, timespans s where s.timespan_id = :timespan_id and t.interval_id = s.interval_id select to_char(reg_deadline,'$date_format') from events_events e where event_id = :event_id update events_events set refreshments_note = :refreshments_note, av_note = :av_note, additional_note = :additional_note where event_id = :event_id select 1 from attachments_fs_root_folder_map where package_id = :package_id select 1 from events_events ee, events_activities ea, acs_events ae where ee.event_id = :event_id and ae.event_id = :event_id and ae.activity_id = ea.activity_id and ea.package_id = :package_id select 1 from events_events ee, dual where ee.event_id = :event_id and ee.reg_deadline < sysdate update events_events set bulk_mail_id = :bulk_mail_id where event_id = :event_id select to_char(ti.start_date, 'DDD') as day_of_year, to_char(ti.start_date, 'YYYY') as year, to_char(ti.start_date, 'HH24:MI:SS') as time, ee.bulk_mail_id from time_intervals ti, timespans ts, acs_events ae, events_events ee where ti.interval_id = ts.interval_id and ts.timespan_id = ae.timespan_id and ae.event_id = :event_id and ee.event_id = :event_id select pa.email from parties pa, events_registrations er where er.user_id = pa.party_id and er.reg_state = 'approved' and event_id = '$event_id'