SELECT
  o.order_sn AS ‘订单单号‘,
  o.order_amount AS ‘订单支付金额‘,
  o.shipping_fee AS ‘邮费‘,
  o.buyer_id AS ‘购买人ID‘,
    bm.member_mobile as ‘购买人手机号‘,
    o.order_state as ‘订单状态‘,
  bm.member_level as ‘会员等级‘,
  a.true_name AS ‘收货人‘,
  a.mob_phone AS ‘收货人手机号‘,
  o.store_name AS ‘店铺名称‘,
  DATE_FORMAT( FROM_UNIXTIME( o.add_time ), ‘%m月%d日%H:%i:%s‘ ) AS ‘订单生成时间‘,
  DATE_FORMAT( FROM_UNIXTIME( o.payment_time ), ‘%m月%d日%H:%i:%s‘ ) AS ‘订单支付时间‘,
  a.area_info AS ‘地区‘,
  a.address AS ‘地址‘,
  c.reciver_info as ‘客服修改的地址‘,
  m.manufacturer_name AS ‘厂家‘,
    o.trade_no,
  g.goods_name AS ‘商品规格‘,
    d.goods_spec as ‘属性‘,
  g.goods_num AS ‘商品数量‘,
  g.goods_price AS ‘商品价格‘,
  g.goods_pay_price AS ‘商品实际支付价格‘ ,
    c.order_message as ‘订单留言‘,
  c.deliver_explain as ‘发货备注‘,
    o.gift_type as ‘礼包等级‘,
    i.consignee_name as ‘真实姓名‘,
    i.audit_code as ‘身份证‘,
  d.goods_serial as ‘商家编码‘,
    g.gid,
    d.goods_jingle as ‘简介‘
FROM
  bbc_order AS o
  LEFT JOIN bbc_order_goods AS g ON o.order_id = g.order_id
  LEFT JOIN bbc_order_common AS c ON c.order_id = o.order_id
  LEFT JOIN bbc_address AS a ON c.address_id = a.address_id
  LEFT JOIN bbc_goods AS d ON g.gid = d.gid
  LEFT JOIN bbc_manufacturer AS m ON m.id = g.manufacturer_id
  LEFT JOIN bbc_member as bm on o.buyer_id = bm.member_id
left join bbc_order_import_consignee i on o.order_id = i.order_id
WHERE
  o.order_state in ("20") 
 and lock_state = 0;