Index: openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql,v diff -u -r1.7.4.2 -r1.7.4.3 --- openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql 25 May 2004 17:39:56 -0000 1.7.4.2 +++ openacs-4/packages/file-storage/sql/oracle/file-storage-views-create.sql 25 May 2004 18:54:03 -0000 1.7.4.3 @@ -90,7 +90,7 @@ when cr_items.content_type = 'content_folder' then 0 else 1 end as sort_key - from cr_items, cr_extlinks, cr_folders, cr_revisions, acs_objects + from cr_items, cr_extlinks, cr_folders, cr_revisions, acs_objects, cr_mime_types where cr_items.item_id = cr_extlinks.extlink_id(+) and cr_items.item_id = cr_folders.folder_id(+) and cr_items.item_id = acs_objects.object_id