select reg_id from events_registrations where event_id = :event_id and user_id = :user_id and reg_state <> 'canceled' select eo.role, eo.user_id, eo.role_id, u.first_names || ' ' || u.last_name as organizer_name from events_organizers eo, cc_users u where eo.event_id = :event_id and eo.public_role_p = 't' and u.user_id = eo.user_id select attr_value from acs_attribute_values where object_id = :user_id and attribute_id = (select attribute_id from acs_attributes where object_type = 'person' and attribute_name = 'bio')