postgresql7.3 select et.task_id, et.task_name, et.weight from evaluation_tasksi et, evaluation_grades eg, cr_items cri where cri.live_revision = et.task_id and eg.grade_id = :grade_id and eg.grade_item_id = et.grade_item_id order by task_name select cu.first_names||', '||cu.last_name as student_name, cu.user_id $sql_query from cc_users cu $orderby select cu.first_names||', '||cu.last_name as student_name, cu.user_id $sql_query from cc_users cu, dotlrn_member_rels_approved app where app.community_id = :community_id and app.user_id = cu.person_id and app.role = 'student' $orderby , round((select coalesce((select (ese.grade*et.weight*eg.weight)/10000 from evaluation_student_evals ese, evaluation_tasks et, evaluation_grades eg, cr_items cri1, cr_items cri2 where party_id = ( select CASE WHEN et3.number_of_members = 1 THEN cu.user_id ELSE (select etg2.group_id from evaluation_task_groups etg2, evaluation_tasks et2, acs_rels map where map.object_id_one = etg2.group_id and map.object_id_two = cu.user_id and etg2.task_item_id = et2.task_item_id and et2.task_id = et.task_id) END as nom from evaluation_tasks et3 where et3.task_id = et.task_id ) and et.task_id = $task_id and ese.task_item_id = et.task_item_id and et.grade_item_id = eg.grade_item_id and cri1.live_revision = ese.evaluation_id and cri2.live_revision = eg.grade_id),0)),2) as task_${task_id} -- , [lc_numeric trunc(evaluation__task_grade(cu.user_id,$task_id),2)] as task_$task_id , round((select coalesce((select sum((ese.grade*et.weight*eg.weight)/10000) from evaluation_grades eg, evaluation_tasks et, evaluation_student_evals ese where et.task_item_id = ese.task_item_id and et.grade_item_id = eg.grade_item_id and eg.grade_id = $grade_id and ese.party_id = ( select CASE WHEN et3.number_of_members = 1 THEN cu.user_id ELSE (select etg2.group_id from evaluation_task_groups etg2, evaluation_tasks et2, acs_rels map where map.object_id_one = etg2.group_id and map.object_id_two = cu.user_id and etg2.task_item_id = et2.task_item_id and et2.task_id = et.task_id) END as nom from evaluation_tasks et3 where et3.task_id = et.task_id ) and et.requires_grade_p = 't' and exists (select 1 from cr_items where live_revision = et.task_id) and exists (select 1 from cr_items where live_revision = ese.evaluation_id)),0)),2) as total_grade -- , 1 as total_grade -- , [lc_numeric trunc(evaluation__grade_total_grade(cu.user_id,:grade_id),2)] as total_grade