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