Index: openacs-4/packages/evaluation/www/admin/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/index-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/evaluation/www/admin/index-postgresql.xql	30 Jul 2004 22:50:09 -0000	1.4
+++ openacs-4/packages/evaluation/www/admin/index-postgresql.xql	10 Sep 2004 19:16:30 -0000	1.5
@@ -9,9 +9,9 @@
 		select eg.grade_plural_name,
 		eg.grade_id,
 	   	eg.grade_item_id
-   	 	from evaluation_gradesx eg, acs_objects ao
-		where content_revision__is_live(eg.grade_id) = true
-          and eg.item_id = ao.object_id
+   	 	from evaluation_grades eg, acs_objects ao, cr_items cri
+		where cri.live_revision = eg.grade_id
+          and eg.grade_item_id = ao.object_id
    		  and ao.context_id = :package_id
 		order by grade_plural_name desc