postgresql7.1 select '[db_quote $sender_email]' as from_addr, '[db_quote $sender_first_names]' as sender_first_names, '[db_quote $sender_last_name]' as sender_last_name, parties.email, (case acs_objects.object_type when 'user' then (select first_names from persons where person_id = parties.party_id) when 'group' then (select group_name from groups where group_id = parties.party_id) when 'rel_segment' then (select segment_name from rel_segments where segment_id = parties.party_id) else '' end) as first_names, (case acs_objects.object_type when 'user' then (select last_name from persons where person_id = parties.party_id) else '' end) as last_name from parties, acs_objects, users where parties.party_id <> 0 and parties.party_id = users.user_id and parties.party_id = acs_objects.object_id and exists (select 1 from acs_object_party_privilege_map m where m.object_id = $assessment_id and m.party_id = parties.party_id and m.privilege = 'read') select '[db_quote $sender_email]' as from_addr, '[db_quote $sender_first_names]' as sender_first_names, '[db_quote $sender_last_name]' as sender_last_name, parties.email, (case acs_objects.object_type when 'user' then (select first_names from persons where person_id = parties.party_id) when 'group' then (select group_name from groups where group_id = parties.party_id) when 'rel_segment' then (select segment_name from rel_segments where segment_id = parties.party_id) else '' end) as first_names, (case acs_objects.object_type when 'user' then (select last_name from persons where person_id = parties.party_id) else '' end) as last_name from parties, acs_objects, users where parties.party_id = users.user_id and parties.party_id = acs_objects.object_id and 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 '[db_quote $sender_email]' as from_addr, '[db_quote $sender_first_names]' as sender_first_names, '[db_quote $sender_last_name]' as sender_last_name, parties.email, (case acs_objects.object_type when 'user' then (select first_names from persons where person_id = parties.party_id) when 'group' then (select group_name from groups where group_id = parties.party_id) when 'rel_segment' then (select segment_name from rel_segments where segment_id = parties.party_id) else '' end) as first_names, (case acs_objects.object_type when 'user' then (select last_name from persons where person_id = parties.party_id) else '' end) as last_name, '[db_quote $community_name]' as community_name, '[db_quote $community_url]' as community_url from parties, acs_objects, users where parties.party_id <> 0 and parties.party_id = users.user_id and parties.party_id = acs_objects.object_id and parties.party_id not 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) and exists (select 1 from acs_object_party_privilege_map m where m.object_id = $assessment_id and m.party_id = parties.party_id and m.privilege = 'read') select '[db_quote $sender_email]' as from_addr, '[db_quote $sender_first_names]' as sender_first_names, '[db_quote $sender_last_name]' as sender_last_name, 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 '[db_quote $sender_email]' as from_addr, '[db_quote $sender_first_names]' as sender_first_names, '[db_quote $sender_last_name]' as sender_last_name, parties.email from parties where parties.party_id in ([template::util::tcl_to_sql_list $user_ids])