Subquery join in Entity (with TOP 1)

gistfile1.cs

var inquery = from en in Course_Enrollments
	from t in (
		(from enr in Course_Enrollments
			join usr in User_Users on enr.UserID equals usr.UserID
			join offr in Course_CourseOfferings on enr.CourseOfferingID equals offr.CourseOfferingID
		
			where offr.CourseOfferingID == 92 && enr.UserID == en.UserID
		
			orderby enr.ModifiedDate
		
			select new {enr.EnrollmentID,enr.UserID}
		).Take(1)
	)
where en.EnrollmentID == t.EnrollmentID
orderby en.UserID
select new {en.EnrollmentID,t.UserID};