select parties.email as sender_email,
persons.first_names as sender_first_names,
persons.last_name as sender_last_name
from parties,
persons
where parties.party_id = :sender_id
and persons.person_id = :sender_id
select count(*)
from as_sessions s, cr_revisions r
where s.assessment_id = r.revision_id
and s.completed_datetime is not null
and r.item_id = :assessment_id
select parties.email
from parties
where
parties.party_id in (
select s.subject_id
from as_sessions s, cr_revisions r
where s.assessment_id = r.revision_id
and s.completed_datetime is not null
and r.item_id = :assessment_id)
select parties.email
from parties
where parties.party_id in ([template::util::tcl_to_sql_list $user_ids])