select user_id from acs_users_all where lower(screen_name) = lower(:screen_name)
select user_id from acs_users_all where lower(email) = lower(:email)
select email from parties where party_id = :party_id
select group_id from groups where group_name = :name
select first_names, last_name
from persons
where person_id = :person_id
update persons
set first_names = :first_names,
last_name = :last_name
where person_id = :person_id
update acs_objects
set title = :first_names || ' ' || :last_name
where object_id = :person_id
select distinct first_names||' '||last_name as person_name
from persons
where person_id = :person_id
select distinct first_names||' '||last_name as person_name
from persons, parties
where person_id = party_id
and email = :email
select bio
from persons
where person_id = :person_id
update persons
set bio = :bio
where person_id = :person_id
update users
set [join $cols ", "]
where user_id = :user_id
select user_id
from users
where lower(username) = lower(:username)
and authority_id =:authority_id
select 1
from registered_users
where user_id = :user_id
update parties
set [join $cols ", "]
where party_id = :party_id
update acs_objects
set title = :email
where object_id = :party_id
and object_type = 'party'
select party_id
from parties
where lower(email) = lower(:email)
select user_id from users where lower(screen_name) = lower(:screen_name)
select rel_id
from cc_users
where user_id = :user_id
select c.item_id
from acs_rels a, cr_items c
where a.object_id_two = c.item_id
and a.object_id_one = :user_id
and a.rel_type = 'user_portrait_rel'