and etg.group_id not in ([join $done_students ","]) dotlrn_member_rels_approved app, and app.community_id = :community_id and app.user_id = ev.party_id and app.role='student' where p.person_id not in ([join $done_students ","]) , cc_users cu where p.person_id = cu.person_id and cu.member_state = 'approved' select p.person_id as party_id, p.last_name||', '||p.first_names as party_name from persons p $not_in_clause select app.user_id as party_id, p.last_name||', '||p.first_names as party_name from dotlrn_member_rels_approved app, persons p $not_in_clause and app.community_id = :community_id and app.user_id = p.person_id and app.role = 'student' $sql_query $orderby_na select 1 from dual where :submission_date_ansi > :evaluation_date_ansi select 1 from dual where :submission_date_ansi > :due_date_ansi and ev.party_id not in ([join $done_students ","]) select et.task_name, et.task_item_id, eg.grade_id, eg.grade_plural_name, eg.weight as grade_weight, et.weight as task_weight, to_char(et.due_date, 'YYYY-MM-DD HH24:MI:SS') as due_date_ansi, et.number_of_members, et.online_p from evaluation_grades eg, evaluation_tasks et, cr_items cri where et.task_id = :task_id and et.grade_item_id = eg.grade_item_id and cri.live_revision = eg.grade_id select g.group_name as party_name, g.group_id as party_id from groups g, evaluation_task_groups etg, evaluation_tasks et, acs_rels map where g.group_id = etg.group_id and etg.group_id = map.object_id_one and map.rel_type = 'evaluation_task_group_rel' and etg.task_item_id = et.task_item_id and et.task_id = :task_id $not_in_clause group by g.group_id, g.group_name