MySQL Error[1054]: Unknown column 'g.goods_cnname' in 'field list'
MySQL Query:SELECT g.virtual_seles,s.praise_rate,s.im_qq,s.im_ww,g.goods_id, g.store_id, g.type, g.goods_name, g.goods_subname, g.goods_cnname, g.goods_kw, g.goods_rl,g.cate_id, g.cate_name, g.brand, g.spec_qty, g.spec_name_1, g.spec_name_2, g.if_show, g.closed, g.add_time, g.recommended, g.default_image,g.mall_recommended,g.mall_sort_order, gs.spec_id, gs.spec_1, gs.spec_2, gs.color_rgb, gs.price, gs.stock, s.store_name, s.region_id, s.region_name, s.credit_value, s.sgrade, gp.pvs, gst.views, gst.sales, gst.comments FROM ecm_goods g LEFT JOIN ecm_goods_spec gs ON g.default_spec = gs.spec_id LEFT JOIN ecm_store s ON g.store_id = s.store_id LEFT JOIN ecm_goods_pvs gp ON g.goods_id=gp.goods_id LEFT JOIN ecm_goods_statistics gst ON g.goods_id = gst.goods_id WHERE g.if_show = 1 AND g.closed = 0 AND s.state = 1 AND g.cate_id_3 = '329' AND gs.spec_id IS NOT NULL AND s.store_id IS NOT NULL ORDER BY add_time desc, s.sort_order LIMIT 0,20
Wrong File: /eccore/model/mysql.php[526]
Error File: /eccore/model/mysql.php at 278 line. >> 前のページに戻る