Index: openacs-4/packages/lorsm/www/delivery/menu.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/delivery/menu.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lorsm/www/delivery/menu.xql	17 May 2005 17:23:27 -0000	1.1
+++ openacs-4/packages/lorsm/www/delivery/menu.xql	12 Jun 2006 02:06:10 -0000	1.2
@@ -1,36 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
 
-<fullquery name="sql">
-  <querytext>
-        SELECT
-         	i.parent_item,
- 		i.ims_item_id,
-                i.item_title as item_title
-        FROM 
-		acs_objects o, ims_cp_items i, cr_items cr
-	WHERE 
-		o.object_type = 'ims_item_object'
-           AND
-		i.org_id = :org_id
-	   AND
-		o.object_id = i.ims_item_id
-	   $extra_query
-           AND
-                cr.item_id = ( select item_id from cr_revisions where revision_id = i.ims_item_id)
-	   AND 
-	   	EXISTS
-		(select 1
-		   from acs_object_party_privilege_map p
-		  where p.object_id = i.ims_item_id 
-		    and p.party_id = :user_id
-		    and p.privilege = 'read')
-
-        ORDER BY 
-               i.sort_order, o.object_id, cr.tree_sortkey
-  </querytext>
-</fullquery>
-
 <fullquery name="get_org_id">
   <querytext>
 	select