Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml
===================================================================
diff -u -r7bf7065d902a3645561f57c779b86721eedc27a5 -r232501e43e69aae1d0c06aace09a057750e41300
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml	(.../Lesson.hbm.xml)	(revision 7bf7065d902a3645561f57c779b86721eedc27a5)
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/lesson/Lesson.hbm.xml	(.../Lesson.hbm.xml)	(revision 232501e43e69aae1d0c06aace09a057750e41300)
@@ -96,6 +96,14 @@
 		    AND (lams_user_group.user_id = :userId)
 		    AND ({lesson}.learning_design_id = lams_learning_design.learning_design_id)
 		    AND (lams_learning_design.copy_type_id=2)
+		    
+		UNION
+		
+		SELECT DISTINCT {lesson.*}
+		  FROM lams_lesson {lesson}
+		  WHERE ({lesson}.user_id = :userId)
+		    AND ({lesson}.class_grouping_id IS NULL)
+		    AND NOT ({lesson}.lesson_state_id = 7)		    
 	</sql-query>
 
 	<sql-query name="activeLessons">