 |
|
|
|
평일 :10:00 - 19:00
토 / 일 / 공휴일 휴무
> 인재정보| 쿼리에서 에러가 났습니다. | |
| 쿼리문 | select count(*) from netk_member_adultjob_se as nm left join netk_adultjob_resume as nar on nm.`mid`=nar.`mid` where 1 and (nar.`area1` like '%TC%' or nar.`subject` like '%TC%' or nar.`content` like '%TC%' or nm.`name` like '%TC%') and `basic`='Y' and `view`='Y' and (CASE WHEN `open_date`='1 month' THEN DATE_SUB(now(), INTERVAL 1 month) WHEN `open_date`='3 month' THEN DATE_SUB(now(), INTERVAL 3 month) WHEN `open_date`='6 month' THEN DATE_SUB(now(), INTERVAL 6 month) ELSE DATE_SUB(now(), INTERVAL 12 month) END)<=nar.`rdate` |
| 에러메세지 | ERROR CODE 1054 : Unknown column \'nm.name\' in \'where clause\' |
| 페이지 | /resume/list.php |
