Index: openacs-4/packages/dotlrn/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/Attic/index-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/www/index-oracle.xql	20 Sep 2001 18:29:35 -0000	1.1
+++ openacs-4/packages/dotlrn/www/index-oracle.xql	5 Oct 2001 15:14:29 -0000	1.2
@@ -5,7 +5,7 @@
 
 <fullquery name="select_classes">
 <querytext>
-select class_key, node_id, site_node.url(node_id) as url from dotlrn_classes order by class_key
+select class_key, node_id, site_node.url(node_id) as url from dotlrn_classes, dotlrn_community_types where dotlrn_community_types.community_type=dotlrn_classes.class_key order by class_key
 </querytext>
 </fullquery>