[2026-03-21 04:27:02] [DB_QUERY_ERROR] MSG: Column 'del_yn' in where clause is ambiguous | SQL: SELECT COUNT(*) as cnt FROM lms_enrollment e LEFT JOIN lms_class c ON e.class_id = c.class_id LEFT JOIN lms_course co ON e.course_id = co.course_id LEFT JOIN lms_member m ON e.member_id = m.member_id WHERE del_yn = 'N' | IP: 127.0.0.1
[2026-03-21 04:27:02] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 13 | SQL: SELECT e.enroll_id, e.class_id, e.member_id, e.course_id, e.emp_ins_flag, e.enroll_status, e.progress_rate, e.final_score, e.pass_yn, e.pass_date, e.enroll_date, e.created_at, m.user_name, m.user_id, m.email, co.course_title, co.course_code, c.class_year, c.class_seq, c.learn_start_date, c.learn_end_date FROM lms_enrollment e LEFT JOIN lms_class c ON e.class_id = c.class_id LEFT JOIN lms_course co ON e.course_id = co.course_id LEFT JOIN lms_member m ON e.member_id = m.member_id WHERE del_yn = 'N' ORDER BY e.created_at DESC LIMIT -20, 20 | IP: 127.0.0.1
[2026-03-21 04:27:55] [DB_QUERY_ERROR] MSG: Column 'del_yn' in where clause is ambiguous | SQL: SELECT COUNT(*) as cnt FROM lms_enrollment e LEFT JOIN lms_class c ON e.class_id = c.class_id LEFT JOIN lms_course co ON e.course_id = co.course_id LEFT JOIN lms_member m ON e.member_id = m.member_id WHERE del_yn = 'N' | IP: 127.0.0.1
[2026-03-21 04:27:55] [DB_QUERY_ERROR] MSG: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 13 | SQL: SELECT e.enroll_id, e.class_id, e.member_id, e.course_id, e.emp_ins_flag, e.enroll_status, e.progress_rate, e.final_score, e.pass_yn, e.pass_date, e.enroll_date, e.created_at, m.user_name, m.user_id, m.email, co.course_title, co.course_code, c.class_year, c.class_seq, c.learn_start_date, c.learn_end_date FROM lms_enrollment e LEFT JOIN lms_class c ON e.class_id = c.class_id LEFT JOIN lms_course co ON e.course_id = co.course_id LEFT JOIN lms_member m ON e.member_id = m.member_id WHERE del_yn = 'N' ORDER BY e.created_at DESC LIMIT -20, 20 | IP: 127.0.0.1
[2026-03-21 04:28:09] [DB_QUERY_ERROR] MSG: Unknown column 'use_yn' in 'where clause' | SQL: SELECT course_id, course_title FROM lms_course WHERE use_yn='Y' ORDER BY course_title | IP: 127.0.0.1
[2026-03-21 18:35:07] [DB_QUERY_ERROR] MSG: Unknown column 'co.use_yn' in 'where clause' | SQL:  SELECT COUNT(DISTINCT co.course_id) AS c FROM lms_course co LEFT JOIN lms_category ca ON co.category_id = ca.category_id WHERE co.use_yn='Y' AND co.del_yn='N' | IP: 161.0.8.130
[2026-03-21 18:35:07] [DB_QUERY_ERROR] MSG: Unknown column 'co.course_type' in 'field list' | SQL:  SELECT co.course_id, co.course_title, co.course_summary, co.thumb_image, co.course_type, co.price_sale, co.total_time, co.content_count, co.pass_min_progress, co.created_at, ca.category_name, COUNT(DISTINCT e.enroll_id) AS enroll_cnt FROM lms_course co LEFT JOIN lms_category ca ON co.category_id = ca.category_id LEFT JOIN lms_class cl ON cl.course_id = co.course_id AND cl.del_yn='N' LEFT JOIN lms_enrollment e ON e.class_id = cl.class_id AND e.del_yn='N' WHERE co.use_yn='Y' AND co.del_yn='N' GROUP BY co.course_id ORDER BY enroll_cnt DESC, co.created_at DESC LIMIT 0, 12 | IP: 161.0.8.130