SELECT count(*) as cnt FROM sp_lecture_student as s
WHERE is_del='N' AND wm_member_id='' AND s.wm_status IN ('Y','R') AND (wm_unlimited='Y' OR (date_format(wm_lec_start,'%Y-%m-%d')<='2022-06-29' AND date_format(wm_lec_end,'%Y-%m-%d')>='2022-06-29'))
SELECT count(*) as cnt FROM sp_bc_round_student AS s
LEFT JOIN sp_bc_round AS br ON s.wm_round_code=br.wm_code AND br.is_del='N'
LEFT JOIN sp_bc_course c ON br.wm_course_code = c.wm_code
WHERE s.is_del='N' AND s.wm_member_id='' AND s.wm_status IN ('Y','R')
AND (br.wm_start_date<='2022-06-29' AND DATE_FORMAT(DATE_ADD(br.wm_start_date, INTERVAL ((c.wm_study_week*7)-1) DAY), '%Y-%m-%d')>='2022-06-29')
02-525-0180
180camp@careergate.co.kr
로그인
![[윙배너] 1 안드로이드 앱 개발](/imgurl?type=main&file=20220617165518165545251840076570.png)
블로그 
언론뉴스 
