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.2 -r1.3
--- openacs-4/packages/courses/www/cc-admin/revision-list.xql	8 Feb 2005 23:07:53 -0000	1.2
+++ openacs-4/packages/courses/www/cc-admin/revision-list.xql	9 Feb 2005 22:54:02 -0000	1.3
@@ -3,10 +3,10 @@
 
 <fullquery name="get_course_info">      
       <querytext>
-	    select course_id, course_key, course_name, course_info, assessment_id, live_revision
-	    from course_catalog, cr_items
-	    where item_id = :item_id and 
-	    course_id in (select revision_id from cr_revisions where item_id = :item_id )
+	    select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.live_revision
+	    from course_catalog cc, cr_items ci
+	    where ci.item_id = :item_id and 
+	    cc.course_id in (select revision_id from cr_revisions where item_id = :item_id )
       </querytext>
 </fullquery>