Severity: User Error
Message: mysqlt error: [1054: Unknown column 'a.use_cat_cd' in 'on clause'] in EXECUTE(" select a.goods_nm, a.goods_nm_eng, a.sale_stat_cl, a.goods_cont , a.goods_sh, a.normal_price, a.sale_type,a.sale_yn, a.sale_dt_yn , a.sale_s_dt, a.sale_e_dt, a.sale_e_dt as sale_e_dt_ori , a.price, a.goods_sh, a.style_no, b.brand_nm, a.brand, b.brand_nm_eng, b.memo as brand_memo, b.brand_logo , a.rep_cat_cd, a.is_unlimited, a.option_kind, a.special_yn, a.opt_kind_cd , date_format(a.reg_dm, '%Y%m%d') as reg_dm, c.p_d_cat_cd, c.d_cat_nm , u.p_d_cat_cd as p_u_cat_cd, u.d_cat_nm as u_cat_nm, a.ad_desc, a.head_desc , a.bae_yn, a.baesong_price , if(m.dlv_policy = 'C',m.free_dlv_amt_limit,'50000') as free_dlv_amt_limit , if(m.dlv_policy = 'C',m.dlv_amt,'2500') as basic_dlv_amt , a.point_yn, a.point_cfg, a.point_unit, a.point , a.org_nm, a.baesong_info, a.goods_type, a.opinion, a.make, a.baesong_desc, a.spec_desc , ifnull(( select sum(good_qty) from goods_summary where goods_no = a.goods_no and goods_sub = a.goods_sub and good_qty > 0 ), 0) as good_qty , a.size_info , round(ifnull((a.goods_est/a.est_cnt), 0),1) as avg_est,a.est_cnt as estimate_cnt , a.com_id , ifnull(i.img,a.img) as img,if( ifnull(i.img_no,'') = '','a','') as img_type , if(datediff(now(),a.reg_dm) <= '14','Y','N') as n_goods_yn , ifnull(a.b_goods_yn, '') as b_goods_yn , a.related_cfg , a.restock_yn , a.dlv_fee_cfg , ifnull(gc.coupon_price, 0) as coupon_price, ifnull(gc.coupon_dc_price, 0) as coupon_dc_price , if( 'N' = 'Y' and '0' > 0, ifnull(( select price from goods_price where goods_no = a.goods_no and goods_sub = a.goods_sub and group_no = '0' ),a.price),0) as wholesale , ifnull(m.dlv_policy, 'S') as dlv_policy, ifnull(m.dlv_amt, 0) as com_dlv_amt, ifnull(m.free_dlv_amt_limit, 0) as com_free_dlv_amt_limit , a.material, a.size, a.import_yn, a.caution, a.qa_basis, a.pack_date, a.kind , m.as_name, m.as_tel , m.com_type, m.com_nm, m.r_zip_code, m.r_addr1, m.r_addr2, m.cs_phone, m.baesong_kind, m.dlv_day, m.memo as com_memo , date_format(a.img_update,'%Y%m%d') as img_update, a.dlv_due_type,a.dlv_due_day, a.dlv_due_period, a.dlv_due_memo , a.limited_qty_yn, a.limited_min_qty, a.limited_max_qty, a.limited_total_qty_yn, a.member_buy_yn, ifnull(a.similar_no, '') as similar_no, a.like_cnt, a.baesong_info, ifnull(cd.code_val, '') as baesong_kind_nm, ifnull(co.code_val, '') as baesong_info_nm, w.no as wish_no, ifnull(a.ask_yn,'N') as ask_yn, ifnull(a.price_display_yn, 'N') as price_display_yn from goods a inner join company m on a.com_id = m.com_id left outer join wishlist as w on ( w.goods_no = a.goods_no and w.goods_sub = a.goods_sub and w.user_id = '' ) left outer join code cd on cd.code_kind_cd = 'G_BAESONG_KIND' and m.baesong_kind = cd.code_id left outer join code co on co.code_kind_cd = 'G_BAESONG_INFO' and a.baesong_info = co.code_id left outer join brand b on ( a.brand = b.brand and b.brand_type = 'S') left outer join category c on ( a.rep_cat_cd = c.d_cat_cd and c.cat_type = 'DISPLAY' ) left outer join category u on ( a.use_cat_cd = u.d_cat_cd and u.cat_type = 'ITEM' ) left outer join goods_coupon gc on a.goods_no = gc.goods_no and a.goods_sub = gc.goods_sub left outer join goods_image i on a.goods_no = i.goods_no and a.goods_sub = i.goods_sub and i.type = '' where a.goods_no = '125246' and a.goods_sub = '0' ")
Filename: adodb5/adodb-errorhandler.inc.php
Line Number: 77