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
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 user_id,
username,
authority_id,
first_names,
last_name,
first_names || ' ' || last_name as name,
email,
url,
screen_name,
priv_name,
priv_email,
email_verified_p,
email_bouncing_p,
no_alerts_until,
last_visit,
to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi,
second_to_last_visit,
to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi,
n_sessions,
password_question,
password_answer,
password_changed_date,
member_state,
rel_id,
extract(day from current_timestamp - password_changed_date) as password_age_days,
creation_date,
creation_ip
from cc_users
where user_id = :user_id