Index: openacs-4/packages/lorsm/lib/repository-shared-courses.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/lib/repository-shared-courses.tcl,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/lorsm/lib/repository-shared-courses.tcl	17 Nov 2008 13:36:43 -0000	1.6
+++ openacs-4/packages/lorsm/lib/repository-shared-courses.tcl	12 Dec 2008 14:25:32 -0000	1.7
@@ -70,29 +70,7 @@
         }
     }
 
-db_multirow -extend { ims_md_id community_url } d_courses select_d_courses {
-    select
-           cp.man_id,
-           cp.course_name,
-           cp.identifier,
-           cp.version,
-           case
-              when hasmetadata = 't' then 'Yes'
-              else 'No'
-           end as hasmetadata,
-           cp.fs_package_id,
-           cp.folder_id,
-       acs.creation_user,
-       acs.creation_date,
-       acs.context_id
-    from ims_cp_manifests cp, acs_objects acs
-    where cp.man_id = acs.object_id
-        and cp.isshared = 't'
-        and cp.man_id in ( select cr.live_revision
-            from cr_items cr
-            where content_type = 'ims_manifest_object' )
-    order by acs.creation_date desc
-} {
+db_multirow -extend { ims_md_id community_url } d_courses select_d_courses { } {
     set ims_md_id $man_id
     set community_url $com_url
 }