From surenkid, 4 Months ago, written in MySQL.
Embed
  1. SELECT vv.`name` 种子姓名,vv.mobile 种子手机,v.`name` 顾客姓名,v.mobile 顾客手机,FROM_UNIXTIME(o.paytime) 支付时间,o.totalprice 订单总额,o.vipname 收货姓名,o.vipmobile 收货手机,o.vipaddress 收货地址,o.items 订单
  2. FROM wfx_shop_order o
  3. LEFT JOIN wfx_vip v ON o.vipid = v.id
  4. LEFT JOIN wfx_vip vv ON SUBSTRING(SUBSTRING_INDEX(v.path,"-",2),3) = vv.id
  5. WHERE o.ispay = 1 AND o.id>9642
  6. ORDER BY vv.id
  7.  
  8. -- 订单一栏内容复制到这里解码(需要勾选base64 decode) https://blog.tanist.co.uk/files/unserialize/index.php

Replies to 初灵所有种子代理商下属订单明细列表 rss

Title Name Language When
Re: 初灵导出所有种子代理商下属订单明细列表 周洪攀 mysql 4 Months ago.