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