SELECT top 25 A.idx,(select name from teach_mast where id=B.teacher_id),studyday_num,edu_explain,edu_target,date2,date3,(select count(*) from study_mast where datediff(DD,getdate(),startday)<='0' and datediff(DD,getdate(),endday)>='0' and kisu_idx=B.kisu_idx),time1,time2,A.maximum_num,sugang_pay,A.state,B.siteid,(select count(*) from sugang_list where kisu_idx=A.idx),lecture_time,Mon_stime,Mon_etime,Tue_stime,Tue_etime,Wed_stime,Wed_etime,Thu_stime,Thu_etime,Fri_stime,Fri_etime,Sat_stime,Sat_etime,Sun_stime,Sun_etime,subject_name,B.state from kisu_mast A Inner Join sugang_list B on A.idx=B.kisu_idx where B.userid='' and A.idx not in (select top 0 A.idx from kisu_mast A Inner Join sugang_list B on A.idx=B.kisu_idx where B.userid='' order by A.idx desc) order by A.idx desc

수강신청교육과정목록

수강신청 수 강 료 교사명 강좌명 수강 요일/시간 강의시간 정원