Index: openacs-4/packages/courses/www/cc-admin/revision-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/courses/www/cc-admin/revision-list.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/courses/www/cc-admin/revision-list.xql	2 Feb 2005 17:26:55 -0000	1.1
+++ openacs-4/packages/courses/www/cc-admin/revision-list.xql	8 Feb 2005 23:07:53 -0000	1.2
@@ -5,7 +5,8 @@
       <querytext>
 	    select course_id, course_key, course_name, course_info, assessment_id, live_revision
 	    from course_catalog, cr_items
-	    where course_key = :course_key and name= :course_key
+	    where item_id = :item_id and 
+	    course_id in (select revision_id from cr_revisions where item_id = :item_id )
       </querytext>
 </fullquery>