postgresql7.4 select et.task_name, eg.grade_id, eg.grade_name, eg.weight as grade_weight, et.weight as task_weight, to_char(et.due_date,'Month DD YYYY') as due_date, et.number_of_members, et.online_p from evaluation_grades eg, evaluation_tasks et where et.task_id = :task_id and et.grade_id = eg.grade_id select count(*) from evaluation_student_evals where task_id = :task_id select count(*) from evaluation_task_groups where group_id not in ([join $done_students ","]) and etg.group_id not in ([join $done_students ","]) select count(*) from evaluation_task_groups etg where etg.task_id = :task_id $not_in_clause where p.person_id not in ([join $done_students ","]) select count(*) from cc_users p $not_in_clause select acs_group__name(etg.group_id) as party_name, etg.group_id as party_id from evaluation_task_groups etg where etg.task_id = :task_id $not_in_clause $orderby_na select p.person_id as party_id, p.last_name||', '||p.first_names as party_name from cc_users p $not_in_clause $orderby_na $sql_query