Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml
===================================================================
diff -u -r488701987d2200568421ecdb409bd25b3aca4d8e -r2dd3318416071b4b80f46dc7c00a95825287099a
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml	(.../Lesson.hbm.xml)	(revision 488701987d2200568421ecdb409bd25b3aca4d8e)
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml	(.../Lesson.hbm.xml)	(revision 2dd3318416071b4b80f46dc7c00a95825287099a)
@@ -93,7 +93,14 @@
 		    AND (lams_group.group_id = lams_user_group.group_id)
 		    AND ({lesson}.lesson_state_id IN (3,4,5))		    
 		    AND (lams_user_group.user_id = :userId)
-
 	</sql-query>
 	
+	<sql-query name="activeLearners">
+		<return alias="learner" class="org.lamsfoundation.lams.usermanagement.User" />
+		SELECT DISTINCT {learner.*}
+		  FROM lams_user {learner},
+		       lams_learner_progress
+		  WHERE ({learner}.user_id = lams_learner_progress.user_id)
+		  AND   (lams_learner_progress.lesson_id  = :lessonId)
+	</sql-query>
 </hibernate-mapping>