Index: openacs-4/packages/assessment/lib/session-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/session-oracle.xql,v
diff -u -r1.4 -r1.4.8.1
--- openacs-4/packages/assessment/lib/session-oracle.xql	2 Sep 2008 17:39:57 -0000	1.4
+++ openacs-4/packages/assessment/lib/session-oracle.xql	4 Oct 2021 15:53:41 -0000	1.4.8.1
@@ -13,20 +13,4 @@
       </querytext>
 </fullquery>
 
-<fullquery name="get_latest_session">
-     <querytext>
-	select * from (select max(o.creation_date), s.session_id 
-        from as_sessions s, 
-        acs_objects o,
-        cr_revisions cr
-	where s.subject_id=:user_id
-        and s.assessment_id in (select revision_id from cr_revisions where item_id= :assessment_id)
-	and o.object_id = cr.item_id
-        and s.session_id = cr.revision_id
-	group by assessment_id, subject_id, session_id)
-	order by o.creation_date desc
-	where rownum=1
-    </querytext>
-</fullquery>
-
 </queryset>
Index: openacs-4/packages/assessment/lib/session-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/session-postgresql.xql,v
diff -u -r1.4 -r1.4.8.1
--- openacs-4/packages/assessment/lib/session-postgresql.xql	2 Sep 2008 17:39:57 -0000	1.4
+++ openacs-4/packages/assessment/lib/session-postgresql.xql	4 Oct 2021 15:53:41 -0000	1.4.8.1
@@ -12,20 +12,4 @@
       </querytext>
 </fullquery>
 
-<fullquery name="get_latest_session">
-     <querytext>
-	select max(o.creation_date), s.session_id 
-        from as_sessions s, 
-        acs_objects o,
-        cr_revisions cr
-	where s.subject_id=:user_id
-        and s.assessment_id in (select revision_id from cr_revisions where item_id= :assessment_id)
-	and o.object_id = cr.item_id
-        and s.session_id = cr.revision_id
-	group by assessment_id, subject_id, session_id, o.creation_date
-	order by o.creation_date desc
-	limit 1
-    </querytext>
-</fullquery>
-
 </queryset>