FROM_UNIXTIME(sk_order.createTime,’%Y-%m-%d- %H:%m:%s’ ) as “下单时间”,

SELECT
sk_order.`id`,
sk_order.`No` as “订单号”,
sk_member.nickname as “微信昵称”,
sk_member_wanren.MemberName as “姓名”,
sk_order_receiver.`name` as “收货人”,
sk_order_goods.title as “品名”,
sk_order_goods.count as “数量”,
sk_order_goods.price*0.01 as “单价”,
sk_order_goods.count*sk_order_goods.price*0.01 as “产品金额(元)”,
— sk_order.expressPrice*0.01 as “快递费用”,
— sk_order.totalPrice*0.01 + sk_order.expressPrice*0.01 as “订单金额”,
FROM_UNIXTIME(sk_order.createTime,’%Y-%m-%d- %H:%m:%s’ ) as “下单时间”,
FROM_UNIXTIME(sk_order.payTime,’%Y-%m-%d- %H:%m:%s’ ) as “付款时间时间”,
sk_order.payStatus
FROM
sk_order
LEFT JOIN sk_order_receiver on sk_order_receiver.`No` = sk_order.`No`
LEFT JOIN sk_order_goods on sk_order_goods.`No` = sk_order.`No`
LEFT JOIN sk_member on sk_member.id = sk_order.memberID
LEFT JOIN sk_member_wanren on sk_member_wanren.MID = sk_member.id
WHERE
sk_order.payStatus = 2
AND
sk_order_goods.title LIKE “%万果%”
AND
sk_order.createTime >= 1580486400
AND
sk_order.createTime <= 1582905600