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 update users set password_question = :password_question, password_answer = :password_answer 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'