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 920, 10
한국교육학술정보원
NH농협
NH농협
KT
휴비스
기아
쌍용건설
한국수자원공사
한국문화예술위원회
KT