Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml
===================================================================
diff -u -re5c9d6208cedb95477b449363a244ded3efb753c -r2a288a1e70f599e32e981552f761b8771e8d1d72
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml (.../Lesson.hbm.xml) (revision e5c9d6208cedb95477b449363a244ded3efb753c)
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml (.../Lesson.hbm.xml) (revision 2a288a1e70f599e32e981552f761b8771e8d1d72)
@@ -55,9 +55,12 @@
+
+
-
+
@@ -265,19 +268,5 @@
AND gi.grouping_id = g.grouping_id
AND g.group_id = gi.staff_group_id
-
-
-
- SELECT DISTINCT {lesson.*}
- FROM (lams_lesson {lesson}, lams_learning_design ld, lams_group g, lams_user_group ug, lams_organisation lo)
- WHERE {lesson}.learning_design_id = ld.learning_design_id
- AND ld.copy_type_id != 3
- AND ({lesson}.organisation_id = lo.organisation_id)
- AND (lo.organisation_id = :orgId or lo.parent_organisation_id = :orgId)
- AND {lesson}.class_grouping_id = g.grouping_id
- AND {lesson}.lesson_state_id != 7
- AND ug.group_id = g.group_id
- AND ug.user_id = :userId
-