****** Start Running CronDailyCreateCourse.php **********

No need to regenerate Course:N

Lesson Remind Date:3

Monthly Remind Date:10

16

Proceed to create Monthly Record --1

select s.stid, course, csid from hb_course_std cs join hb_course c on concat(c.coursecode,'|cou') = cs.course join student s on s.stid = cs.stid where date_format(cs.coursedt,'%Y%m') = date_format('2025-06-16','%Y%m') and (coursetype = 'regularM' or coursetype = 'varied') group by s.stid, course --1

Get SQL:select stid, sum(cnt) as cnt, course from hb_course_std cs join hb_course c on concat(c.coursecode,'|cou') = cs.course join (select count(*) as cnt, csid from hb_lesson_std where lessondt > '2025-06-16' group by csid) ls on ls.csid = cs.csid where enddt > '2025-06-16' and coursetype = 'regularL' group by stid, course

****** End of Running CronDailyCreateCourse.php **********