In src>app>(consumer)>courses>page.tsx>getCourses
const courses = await db
.select({
id: CourseTable.id,
name: CourseTable.name,
description: CourseTable.description,
sectionsCount: countDistinct(CourseSectionTable.id),
lessonsCount: countDistinct(LessonTable.id),
lessonsComplete: countDistinct(UserLessonCompleteTable.lessonId),
})
.from(CourseTable)
.leftJoin(
UserCourseAccessTable,
and(
eq(UserCourseAccessTable.courseId, CourseTable.id),
eq(UserCourseAccessTable.userId, userId)
)
)
........
the leftJoin should be an innerJoin