Index: openacs-4/packages/evaluation/www/admin/tasks/task-delete-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/tasks/task-delete-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/evaluation/www/admin/tasks/task-delete-postgresql.xql 28 Apr 2004 11:09:54 -0000 1.1 +++ openacs-4/packages/evaluation/www/admin/tasks/task-delete-postgresql.xql 7 Jun 2004 16:05:16 -0000 1.2 @@ -6,14 +6,9 @@ - select et3.task_name, - count(ets.solution_id) as task_sols, - count(ea.answer_id) as task_answers - from evaluation_tasks et3, - evaluation_tasks et2 left outer join evaluation_tasks_solsi ets on (ets.task_id = et2.task_id and content_revision__is_live(ets.solution_id) = true), - evaluation_tasks et left outer join evaluation_answersi ea on (ea.task_id = et.task_id and content_revision__is_live(ea.answer_id) = true) - where et3.task_id = :task_id - group by et3.task_name + select et.task_name + from evaluation_tasks et + where et.task_id = :task_id