SELECT count(distinct a1.aptitude_no) CNT FROM recommend_std_t a1 inner join member_std_t a2 on a1.mem_no = a2.mem_no left outer join uv_company a3 on a1.nCom_scd = a3.company_no WHERE a1.aptitude_gb = 1 AND a1.view_check = 'Y' and a1.aptitude_no not in (5688,5773) SELECT a1.aptitude_no, a1.content, a1.opt_bno,a1.title,a1.visit,date_format(a1.date_input,'%Y.%m.%d') as date_input ,a2.mem_id, a2.mem_no,a3.company_no,a3.company_nm ,date_add(a1.date_input, INTERVAL 7 DAY) new_chk FROM recommend_std_t a1 inner join member_std_t a2 on a1.mem_no = a2.mem_no left outer join uv_company a3 on a1.nCom_scd = a3.company_no WHERE a1.aptitude_gb = 1 AND a1.view_check = 'Y' and a1.aptitude_no not in (5688,5773) ORDER BY a1.notice_view, a1.date_input desc LIMIT 890, 10
한국인터넷진흥원
한국수력원자력
한국전력공사
한국원자력통제기술원
한국수력원자력
한국남동발전
한국MSD
한국수력원자력
한국전력공사