2022-03-22 15:12:06 manageCourse.php (19) checking tablename : semester 2022-03-22 15:14:32 manageCourse.php (19) checking tablename : semester 2022-03-22 15:14:32 manageCourse.php (53) checking tablename : course & offer 2022-03-22 15:14:32 manageCourse.php (19) checking tablename : semester 2022-03-22 15:14:32 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:14:32 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:14:32 manageCourse.php (102) filter Dep : 2022-03-22 15:14:32 manageCourse.php (104) checking session type : student 2022-03-22 15:14:32 manageCourse.php (107) stdId : 1000020 2022-03-22 15:14:32 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:14:41 manageUser.php (14) Received 'POST' parameters: [action] = GET_PROFILE 2022-03-22 15:15:06 manageCourse.php (19) checking tablename : semester 2022-03-22 15:15:11 manageCourse.php (19) checking tablename : semester 2022-03-22 15:15:11 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:15:11 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:15:11 manageCourse.php (102) filter Dep : 2022-03-22 15:15:11 manageCourse.php (104) checking session type : student 2022-03-22 15:15:11 manageCourse.php (107) stdId : 1000020 2022-03-22 15:15:11 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:15:27 manageCourse.php (19) checking tablename : semester 2022-03-22 15:15:27 manageCourse.php (220) checking tablename : course 2022-03-22 15:15:27 manageCourse.php (221) checking course Id : 1000004 2022-03-22 15:15:40 manageCourse.php (19) checking tablename : semester 2022-03-22 15:15:40 manageCourse.php (53) checking tablename : course & offer 2022-03-22 15:15:40 manageCourse.php (19) checking tablename : semester 2022-03-22 15:15:40 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:15:40 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:15:40 manageCourse.php (102) filter Dep : 2022-03-22 15:15:40 manageCourse.php (104) checking session type : student 2022-03-22 15:15:40 manageCourse.php (107) stdId : 1000020 2022-03-22 15:15:40 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:15:46 manageUser.php (14) Received 'POST' parameters: [action] = GET_PROFILE 2022-03-22 15:17:35 manageCourse.php (19) checking tablename : semester 2022-03-22 15:17:35 manageCourse.php (53) checking tablename : course & offer 2022-03-22 15:17:35 manageCourse.php (19) checking tablename : semester 2022-03-22 15:17:35 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:17:35 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:17:35 manageCourse.php (102) filter Dep : 2022-03-22 15:17:35 manageCourse.php (104) checking session type : student 2022-03-22 15:17:35 manageCourse.php (107) stdId : 1000020 2022-03-22 15:17:35 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:17:54 manageCourse.php (19) checking tablename : semester 2022-03-22 15:18:16 manageCourse.php (19) checking tablename : semester 2022-03-22 15:18:16 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:18:16 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:18:16 manageCourse.php (102) filter Dep : 2022-03-22 15:18:16 manageCourse.php (104) checking session type : student 2022-03-22 15:18:16 manageCourse.php (107) stdId : 1000020 2022-03-22 15:18:16 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:18:27 manageCourse.php (19) checking tablename : semester 2022-03-22 15:18:27 manageCourse.php (53) checking tablename : course & offer 2022-03-22 15:18:27 manageCourse.php (19) checking tablename : semester 2022-03-22 15:18:27 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:18:27 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:18:27 manageCourse.php (102) filter Dep : 2022-03-22 15:18:27 manageCourse.php (104) checking session type : student 2022-03-22 15:18:27 manageCourse.php (107) stdId : 1000020 2022-03-22 15:18:27 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:18:32 manageUser.php (14) Received 'POST' parameters: [action] = GET_PROFILE 2022-03-22 15:19:38 manageUser.php (14) Received 'POST' parameters: [action] = UP_STU [pf] = น.ส. [fn] = กัลยกร [ln] = สารโท [fne] = Kanyakorn [lne] = Kanyakorn [idCrd] = 1305300009755 [add] = 1099/150ซอย7หมู่4 [sDis] = หัวทะเล [dis] = เมืองนครราชสีมา [prov] = นครราชสีมา [zip] = 30000 [edu] = มัธยมศึกษาตอนปลาย [occ] = นักเรียน [spec] = undefined [ph] = 0650911244 [em] = 53578@srn.ac.th [pwd] = KS050948 [id] = 1mL7/yZp3JUEI+KeWrNOVw== [isPF] = true 2022-03-22 15:19:38 manageUser.php->upload.php (10) ไม่มีไฟล์รูปใหม่ให้อัพเดต 2022-03-22 15:19:38 manageUser.php (545) Update table student 2022-03-22 15:19:38 manageUser.php (548) using profile page 2022-03-22 15:19:38 manageUser.php (14) Received 'POST' parameters: [action] = GET_PROFILE 2022-03-22 15:21:24 manageUser.php (14) Received 'POST' parameters: [action] = UP_STU [pf] = น.ส. [fn] = กัลยกร [ln] = สารโท [fne] = Kanyakorn [lne] = Kanyakorn [idCrd] = 1305300009755 [add] = 1099/150ซอย7หมู่4 [sDis] = หัวทะเล [dis] = เมืองนครราชสีมา [prov] = นครราชสีมา [zip] = 30000 [edu] = มัธยมศึกษาตอนปลาย [occ] = นักเรียน [spec] = undefined [ph] = 0650911244 [em] = 53578@srn.ac.th [pwd] = KS050948 [id] = 1mL7/yZp3JUEI+KeWrNOVw== [isPF] = true 2022-03-22 15:21:24 manageUser.php (536) Original File Name: AFCA07BA-E3C9-45CC-89C0-BFEA7C0B7707.png 2022-03-22 15:21:24 manageUser.php (537) New File Name: AFCA07BA-E3C9-45CC-89C0-BFEA7C0B7707.png 2022-03-22 15:21:24 manageUser.php (538) Target File: /img/stu/1647937285.png 2022-03-22 15:21:24 manageUser.php (539) Upload Image Profile 2022-03-22 15:21:24 manageUser.php->upload.php (46) สามารถนำ /AFCA07BA-E3C9-45CC-89C0-BFEA7C0B7707.png ไปใส่ได้สำเร็จ 2022-03-22 15:21:24 manageUser.php (545) Update table student 2022-03-22 15:21:24 manageUser.php (548) using profile page 2022-03-22 15:21:24 manageUser.php (14) Received 'POST' parameters: [action] = GET_PROFILE 2022-03-22 15:27:22 manageCourse.php (19) checking tablename : semester 2022-03-22 15:27:22 manageCourse.php (53) checking tablename : course & offer 2022-03-22 15:27:22 manageCourse.php (19) checking tablename : semester 2022-03-22 15:27:22 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:27:22 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:27:22 manageCourse.php (102) filter Dep : 2022-03-22 15:27:22 manageCourse.php (104) checking session type : student 2022-03-22 15:27:22 manageCourse.php (107) stdId : 1000020 2022-03-22 15:27:22 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:27:26 manageCourse.php (19) checking tablename : semester 2022-03-22 15:28:30 manageCourse.php (19) checking tablename : semester 2022-03-22 15:28:30 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:28:30 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:28:30 manageCourse.php (102) filter Dep : 2022-03-22 15:28:30 manageCourse.php (104) checking session type : student 2022-03-22 15:28:30 manageCourse.php (107) stdId : 1000020 2022-03-22 15:28:30 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:30:10 manageCourse.php (19) checking tablename : semester 2022-03-22 15:30:10 manageCourse.php (53) checking tablename : course & offer 2022-03-22 15:30:10 manageCourse.php (19) checking tablename : semester 2022-03-22 15:30:10 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:30:10 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:30:10 manageCourse.php (102) filter Dep : 2022-03-22 15:30:10 manageCourse.php (104) checking session type : student 2022-03-22 15:30:10 manageCourse.php (107) stdId : 1000020 2022-03-22 15:30:10 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:30:14 manageCourse.php (19) checking tablename : semester 2022-03-22 15:30:14 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:30:14 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:30:14 manageCourse.php (102) filter Dep : 2022-03-22 15:30:14 manageCourse.php (104) checking session type : student 2022-03-22 15:30:14 manageCourse.php (107) stdId : 1000020 2022-03-22 15:30:14 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:30:20 manageCourse.php (19) checking tablename : semester 2022-03-22 15:30:20 manageCourse.php (220) checking tablename : course 2022-03-22 15:30:20 manageCourse.php (221) checking course Id : 1000004 2022-03-22 15:30:33 manageCourse.php (19) checking tablename : semester 2022-03-22 15:30:33 manageCourse.php (220) checking tablename : course 2022-03-22 15:30:33 manageCourse.php (221) checking course Id : 1000004 2022-03-22 15:32:00 manageCourse.php (19) checking tablename : semester 2022-03-22 15:32:00 manageCourse.php (53) checking tablename : course & offer 2022-03-22 15:32:01 manageCourse.php (19) checking tablename : semester 2022-03-22 15:32:01 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:32:01 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:32:01 manageCourse.php (102) filter Dep : 2022-03-22 15:32:01 manageCourse.php (104) checking session type : student 2022-03-22 15:32:01 manageCourse.php (107) stdId : 1000020 2022-03-22 15:32:01 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:32:07 manageCourse.php (19) checking tablename : semester 2022-03-22 15:32:07 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:32:07 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:32:07 manageCourse.php (102) filter Dep : 2022-03-22 15:32:07 manageCourse.php (104) checking session type : student 2022-03-22 15:32:07 manageCourse.php (107) stdId : 1000020 2022-03-22 15:32:07 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:32:10 manageCourse.php (19) checking tablename : semester 2022-03-22 15:32:10 manageCourse.php (220) checking tablename : course 2022-03-22 15:32:10 manageCourse.php (221) checking course Id : 1000004 2022-03-22 15:32:26 manageCourse.php (19) checking tablename : semester 2022-03-22 15:32:26 manageCourse.php (53) checking tablename : course & offer 2022-03-22 15:32:27 manageCourse.php (19) checking tablename : semester 2022-03-22 15:32:27 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:32:27 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:32:27 manageCourse.php (102) filter Dep : 2022-03-22 15:32:27 manageCourse.php (104) checking session type : student 2022-03-22 15:32:27 manageCourse.php (107) stdId : 1000020 2022-03-22 15:32:27 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:32:34 manageCourse.php (19) checking tablename : semester 2022-03-22 15:32:47 manageCourse.php (19) checking tablename : semester 2022-03-22 15:32:47 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:32:47 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:32:47 manageCourse.php (102) filter Dep : 2022-03-22 15:32:47 manageCourse.php (104) checking session type : student 2022-03-22 15:32:47 manageCourse.php (107) stdId : 1000020 2022-03-22 15:32:47 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:32:48 manageCourse.php (19) checking tablename : semester 2022-03-22 15:32:48 manageCourse.php (220) checking tablename : course 2022-03-22 15:32:48 manageCourse.php (221) checking course Id : 1000004 2022-03-22 15:34:19 manageCourse.php (19) checking tablename : semester 2022-03-22 15:34:19 manageCourse.php (53) checking tablename : course & offer 2022-03-22 15:34:20 manageCourse.php (19) checking tablename : semester 2022-03-22 15:34:20 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:34:20 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:34:20 manageCourse.php (102) filter Dep : 2022-03-22 15:34:20 manageCourse.php (104) checking session type : student 2022-03-22 15:34:20 manageCourse.php (107) stdId : 1000020 2022-03-22 15:34:20 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:34:25 manageCourse.php (19) checking tablename : semester 2022-03-22 15:34:25 manageCourse.php (99) checking tablename : course & offer 2022-03-22 15:34:25 manageCourse.php (101) checking semester : 1000003 2022-03-22 15:34:25 manageCourse.php (102) filter Dep : 2022-03-22 15:34:25 manageCourse.php (104) checking session type : student 2022-03-22 15:34:25 manageCourse.php (107) stdId : 1000020 2022-03-22 15:34:25 manageCourse.php (167) sql : SELECT distinct c.courseId as cid, c.offerId as offId, c.courseImgPath, c.courseTitleTh, c.detail, en.enrollmentStatus as enStatus FROM (SELECT c.courseId, o.offerId, c.courseImgPath, c.courseTitleTh, c.detail FROM course as c, offer as o WHERE o.courseId = c.courseId AND c.courseStatus = 1 AND o.offerStatus = 1 AND o.semesterId = ? ) as c LEFT JOIN (SELECT e.courseId, e.offerId, e.enrollmentStatus FROM enrollment as e, offer as o2 WHERE o2.offerId = e.offerId AND o2.semesterId = ? AND e.studentId = ? ) as en ON en.courseId = c.courseId; 2022-03-22 15:34:31 manageCourse.php (19) checking tablename : semester 2022-03-22 15:34:31 manageCourse.php (220) checking tablename : course 2022-03-22 15:34:31 manageCourse.php (221) checking course Id : 1000004 2022-03-22 19:47:06 manageCourse.php (19) checking tablename : semester