자유게시판
- 커뮤니티 > 자유게시판
와
[투혼]아머°
QUERY: SELECT a.r_no, a.subject, a.content, a.comment_cnt, a.access_cnt, a.like_cnt, a.selected, a.hate_cnt, a.user_name, a.USER_NO, a.reg_date, a.upd_date, a.deleted_yn, IFNULL(b.grade_level, \'0\') as grade_level, IFNULL(b.grade_dragon_icon, \'god\') as grade_dragon_icon, b.grade_dragon_no FROM board_fboard_new a LEFT OUTER JOIN TB_USER_GRADE b ON a.USER_NO = b.USER_NO AND a.USER_NO>0 WHERE 1 AND a.deleted_yn=\'N\' AND a.hidden_yn=\'N\' AND a.like_cnt>5 AND a.reg_date>=DATE_ADD( NOW(), interval -3 day ) AND a.hate_cnt<20 ORDER BY (a.like_cnt-a.hate_cnt) DESC, a.r_no DESC LIMIT 5
ERROR: Unknown column \'a.selected\' in \'field list\'
