| 1234567891011121314151617181920212223242526272829303132333435363738 |
- SELECT
- O.USER_NAME AS 会员编号,
- 'Q94839185' AS 报单中心,
- O.SN AS 订单号,
- O.`STATUS` AS 订单状态,
- G.SKU_CODE AS 存货编码,
- G.GOODS_TITLE AS 存货名称,
- G.BUY_NUMS AS 数量,
- O.CONSIGNEE AS 收货人,
- O.MOBILE AS 联系方式1,
- O.TEL AS 联系方式2,
- R.REGION_NAME AS 省,
- R2.REGION_NAME AS 市,
- R3.REGION_NAME AS 区,
- O.ADDRESS AS 详细地址,
- O.PERIOD_NUM AS 期数,
- O.ORDER_TYPE AS 订单类型,
- O.WAREHOUSE AS 发货仓,
- O.CREATED_AT AS 创建时间,
- O.PAY_AT AS 支付时间,
- O.DELIVERY_AT AS 发货时间,
- G.REAL_PRICE AS 商品单价,
- (G.REAL_PRICE * G.BUY_NUMS) AS 商品金额,
- G.REAL_PV AS 商品PV,
- (G.REAL_PV * G.BUY_NUMS) AS PV合计,
- O.PAY_FREIGHT AS 运费,
- O.EXPRESS_COMPANY AS 快递公司,
- O.ORDER_TRACK_NO AS 快递单号,
- O.EXPRESS_TYPE AS 发货方式,
- O.REMARK AS 会员备注,
- O.DELIVERY_STATUS AS 发货状态
- FROM
- AR_ORDER O
- LEFT JOIN AR_ORDER_GOODS G ON G.ORDER_SN = O.SN
- LEFT JOIN AR_REGION R ON R.REGION_CODE = O.PROVINCE
- LEFT JOIN AR_REGION R2 ON R2.REGION_CODE = O.CITY
- LEFT JOIN AR_REGION R3 ON R3.REGION_CODE = O.COUNTY
- WHERE O.PERIOD_NUM = 159
|
