Warning: ocierror() expects parameter 1 to be resource, boolean given in /home/incheon/lib/dbclass.lib.php on line 139 SQL Error:
SELECT COUNT(*) FROM (
SELECT m.courseid, m.course_code, m.course_name, m.t_name, TO_CHAR(m.course_start, 'YYYY.MM.DD') course_start, TO_CHAR(m.course_end, 'YYYY.MM.DD') course_end, m.course_price, m.capacity, m.cstate, m.sortno, COUNT(s.courseid) people
FROM lms_course m LEFT OUTER JOIN lms_coursetake s ON m.courseid = s.courseid
WHERE m.branch_idx = 13 AND m.cstate IN (3, 5, 7)
GROUP BY m.courseid, m.course_code, m.course_name, m.t_name, m.course_start, m.course_end, m.course_price, m.capacity, m.cstate, m.sortno
)
