Index: openacs-4/packages/assessment/www/assessment.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/assessment.xql,v
diff -u -N -r1.15 -r1.16
--- openacs-4/packages/assessment/www/assessment.xql	6 Feb 2006 20:08:30 -0000	1.15
+++ openacs-4/packages/assessment/www/assessment.xql	7 Feb 2006 10:44:57 -0000	1.16
@@ -93,12 +93,10 @@
 	<querytext>
 
 	select count(*) as total_tries, max(session_id) as last_session_id
-	from as_sessions s, cr_revisions r, cr_revisions r2
+	from as_sessions s
 	where s.subject_id = :user_id
 	and s.completed_datetime is not null
-	and s.assessment_id = r.revision_id
-	and r.item_id = r2.item_id
-	and r2.revision_id = :assessment_id
+	and s.assessment_id = :assessment_rev_id
 
 	</querytext>
 </fullquery>