Query Error
Query	select cnst_id, cnst_type, cate1, cate2, cate3, reg_type, title, title2, content, content2, comment, acc_sdate, acc_edate, vote_sdate, vote_edate, real_view_cnt, view_cnt, attend_modify_member_yn, attend_modify_member_yn, attend_cnt, attend_amt, op_amt, vote_cnt, vote_avail_cnt, attend_sum_use_yn, attend_sum, exURL, cfn_uid, cfn_yn, date_format(cfn_date,'%Y%m%d') cfn_date, cfn_rsn_cd, cfn_rsn_etc, init_amt, win_item, attend_point, vote_point, win_amt, win_cnt, win_uid, win_name, win_date, del_yn, show_yn, secret_yn, status, main_show_yn, cate_all_show_yn, cate_show_yn, mfname, rfname, cfname, bfname, bfname_link, ref_bnr_L, ref_bnr_M, ref_bnr_S, ref_keyword, free_yn, orderno, reg_uid, reg_name, view_text, reg_ip, date_format(reg_date,'%Y%m%d') reg_date, bannerL_bgcolor, mod_date, refer_to, contract_notice, contract_notice2, attend_list_show_yn, attend_btn_show_yn, attend_btn_link , attend_btn_link_mobile_iphone, attend_btn_link_mobile_android, attend_btn_link_iphone, payment_total_value, attend_btn_link_android, attend_file_attach, attend_file_attach_required, creative_point, logical_point, practical_point, sensual_point, vote_benefits_yn, target, placeholder_title, placeholder_contents, meta_contents, meta_term, meta_entryperiod, meta_invitationschedule, meta_subject, meta_activities, awards_date, meta_subjectivity, meta_topic, meta_who, meta_attend, meta_how, meta_participate, meta_announced, meta_specification, meta_venue, meta_place, meta_awards, meta_special, meta_benefits, meta_audit, meta_notice, meta_contact, ref_ex_coni_id, reAttend_yn, acc_stime, acc_etime, ad_link_for_type, ad_link_for_W_L, ad_link_for_M_L, max_people, location, fees, bank_account, (select cate_name from tb_cate_code b where b.cate_code = a.cate1) as cate1_name, (select cate_name from tb_cate_code b where b.cate_code = a.cate2) as cate2_name, (select name from tb_code b where b.code = a.cfn_rsn_cd) as cfn_rsn_name, (case when status = '2' and acc_sdate <= date_format(now(),'%Y%m%d%H%i%s') and acc_edate >= date_format(now(),'%Y%m%d%H%i%s') then '1' when status = '2' and vote_sdate < date_format(now(),'%Y%m%d%H%i%s') and vote_edate >= date_format(now(),'%Y%m%d%H%i%s') then '2' when status = '2' and acc_sdate >= date_format(now(),'%Y%m%d%H%i%s') then '3' when status = '2' and vote_edate < date_format(now(),'%Y%m%d%H%i%s') then '4' when status = '3' then '5' end) stat from tb_contest a where cnst_id = 818)
Error Message	ERROR CODE 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \')\' at line 1
Page	/contest/contest_view.php