postgresql7.3 select evaluation__party_name(ese.party_id,et.task_id) as party_name, ese.party_id, ese.grade, ese.last_modified as evaluation_date, et.online_p, et.due_date, ese.evaluation_id from evaluation_tasks et, evaluation_student_evalsi ese where et.task_id = :task_id and et.task_item_id = ese.task_item_id and content_revision__is_live(ese.evaluation_id) = true $orderby select count(party_id) from evaluation_answers ea where ea.task_item_id = :task_item_id $processed_clause and content_revision__is_live(ea.answer_id) = true 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 where ea.party_id = :party_id and ea.task_item_id = :task_item_id and content_revision__is_live(ea.answer_id) = true select count(*) from evaluation_student_evals ese, evaluation_tasks et where ese.task_item_id = et.task_item_id and et.task_id = :task_id and content_revision__is_live(ese.evaluation_id) = true and ea.party_id not in ([join $done_students ","]) select evaluation__party_name(ea.party_id, :task_id) 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