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 270, 10
포스코
동우화인켐
매일유업
한국IBM
금호건설
코웨이
충남대학교병원
iM증권
상미당홀딩스