postgresql7.3 select ese.party_id, case when et.number_of_members = 1 then (select last_name||', '||first_names from persons where person_id = ese.party_id) else (select group_name from groups where group_id = ese.party_id) end as party_name, round(ese.grade,2) as grade, ese.last_modified as evaluation_date, et.online_p, et.due_date, ese.evaluation_id from evaluation_tasks et, evaluation_student_evalsi ese, cr_items cri where et.task_id = :task_id and et.task_item_id = ese.task_item_id and cri.live_revision = ese.evaluation_id $orderby select count(party_id) from evaluation_answers ea, cri_items cri where ea.task_item_id = :task_item_id $processed_clause and cri.live_revision = ea.answer_id select 1 from dual where :submission_date > :evaluation_date select 1 from dual where :submission_date > :due_date select ea.data as answer_data, ea.title as answer_title, ea.revision_id, to_char(ea.creation_date, 'YYYY-MM-DD HH24:MI:SS') as submission_date_ansi, ea.last_modified as submission_date from evaluation_answersi ea, cr_items cri where ea.party_id = :party_id and ea.task_item_id = :task_item_id and cri.live_revision = ea.answer_id select count(*) from evaluation_student_evals ese, evaluation_tasks et, cr_items cri where ese.task_item_id = et.task_item_id and et.task_id = :task_id and cri.live_revision = ese.evaluation_id and ea.party_id not in ([join $done_students ","]) select ea.party_id, case when et.number_of_members = 1 then (select last_name||', '||first_names from persons where person_id = ea.party_id) else (select group_name from groups where group_id = ea.party_id) end as party_name, ea.party_id, ea.data as answer_data, ea.title as answer_title, ea.revision_id, to_char(ea.last_modified, 'YYYY-MM-DD HH24:MI:SS') as submission_date_ansi, et.due_date, ea.last_modified as submission_date from evaluation_answersi ea, evaluation_tasks et, cr_items cri where ea.task_item_id = et.task_item_id and et.task_id = :task_id and ea.data is not null and cri.live_revision = ea.answer_id $processed_clause $orderby_wa 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