Index: openacs-4/contrib/packages/events/www/admin/send-mail.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/www/admin/Attic/send-mail.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/events/www/admin/send-mail.xql	9 Mar 2003 12:08:23 -0000	1.1
+++ openacs-4/contrib/packages/events/www/admin/send-mail.xql	13 Mar 2003 10:05:27 -0000	1.2
@@ -27,10 +27,9 @@
     <fullquery name="select_event_from_addr_count">
         <querytext>
         select count(*) as from_addr_count 
-          from parties pa,
-               events_events ee
+          from (select contact_user_id from events_events where event_id = :event_id) ee,
+               parties pa
          where ee.contact_user_id = pa.party_id
-           and ee.event_id = :event_id
             or pa.party_id = :user_id
         </querytext>
     </fullquery>
@@ -39,10 +38,9 @@
         <querytext>
         select CASE WHEN ee.contact_user_id = pa.party_id AND ee.contact_user_id <> :user_id THEN pa.email || ' (the default contact for this event)'
                ELSE pa.email END as from_addr, pa.email 
-          from parties pa,
-               events_events ee
+          from (select contact_user_id from events_events where event_id = :event_id) ee,
+               parties pa
          where ee.contact_user_id = pa.party_id
-           and ee.event_id = :event_id
             or pa.party_id = :user_id
         </querytext>
     </fullquery>