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')