$sql = 'INSERT INTO ' . $this->ecs->table('order_goods') . '( ' . 'user_id, order_id, goods_id, goods_name, goods_sn, goods_brief, product_id,is_reality,is_return,is_fast, goods_number, market_price, goods_price, commission_rate, ' . 'goods_attr, is_real, extension_code, parent_id, is_gift,freight, tid,shipping_fee, model_attr, goods_attr_id, ru_id, shopping_fee, warehouse_id, area_id, is_distribution, drp_money) ' . (' SELECT \'' . $user_id . '\', \'' . $new_order_id . '\', ca.goods_id, ca.goods_name, ca.goods_sn, ca.goods_brief, ca.product_id,(SELECT is_reality FROM ') . $GLOBALS['ecs']->table('goods_extend') . ' AS ge WHERE ge.goods_id = ca.goods_id limit 1),(SELECT is_return FROM ' . $GLOBALS['ecs']->table('goods_extend') . ' AS ge WHERE ge.goods_id = ca.goods_id limit 1),(SELECT is_fast FROM ' . $GLOBALS['ecs']->table('goods_extend') . ' AS ge WHERE ge.goods_id = ca.goods_id limit 1), ca.goods_number, ca.market_price, ca.goods_price, ca.commission_rate, ca.goods_attr, ' . 'ca.is_real, ca.extension_code, ca.parent_id, ca.is_gift,ca.freight, ca.tid,ca.shipping_fee,ca.model_attr, ca.goods_attr_id, ca.ru_id, ca.shopping_fee, ca.warehouse_id,ca.area_id,' . ('g.is_distribution*\'' . $is_distribution . '\' as is_distribution, ') . ('g.dis_commission*g.is_distribution*ca.goods_price*ca.goods_number/100*\'' . $is_distribution . '\' as drp_money') . ' FROM ' . $this->ecs->table('cart') . ' ca' . ' LEFT JOIN {pre}goods as g ON ca.goods_id = g.goods_id' . ' WHERE ca.' . $this->sess_id . (' AND ca.is_checked = 1 AND ca.rec_type = \'' . $flow_type . '\'') . $goodsIn;

提示1054:Unknown column 'ca.goods_brief' in 'field list'