SELECT a.chuchun,b.* FROM lms_course_co a LEFT JOIN lms_course b ON a.course_id = b.course_id WHERE a.chuchun = 'Y' AND b.del_yn_course = 'N' AND b.view_yn = 'Y' AND a.site_id = '' ORDER BY a.course_id DESC