Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/acs-subsite/tcl/approval-expiration-procs-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/acs-subsite/tcl/approval-expiration-procs-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/acs-subsite/tcl/approval-expiration-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/approval-expiration-procs.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/tcl/approval-expiration-procs.xql	20 Nov 2017 13:54:34 -0000	1.1
@@ -0,0 +1,16 @@
+<?xml version="1.0"?>
+<queryset>
+
+  <fullquery name="subsite::sweep_expired_approvals.select_expired_user_ids">
+    <querytext>
+        select u.user_id
+        from   cc_users u,
+               acs_objects relo
+        where  relo.object_id = u.rel_id
+        and    u.last_visit < current_timestamp - interval :days day
+        and    relo.last_modified < current_timestamp - interval :days day
+        and    u.member_state = 'approved'
+    </querytext>
+  </fullquery>
+
+</queryset>