Index: openacs-4/packages/acs-subsite/www/pvt/alerts-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/alerts-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/pvt/alerts-oracle.xql	1 May 2001 19:00:18 -0000	1.1
+++ openacs-4/packages/acs-subsite/www/pvt/alerts-oracle.xql	15 May 2001 16:59:01 -0000	1.2
@@ -3,6 +3,18 @@
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+<fullquery name="alerts_list">      
+      <querytext>
+      
+    select bea.valid_p, bea.frequency, bea.keywords, bt.topic, bea.rowid
+    from bboard_email_alerts bea, bboard_topics bt
+    where bea.user_id = :user_id
+    and bea.topic_id = bt.topic_id
+    order by bea.frequency
+      </querytext>
+</fullquery>
+
+ 
 <fullquery name="alerts_list_2">      
       <querytext>