From surenkid, 3 Months ago, written in MySQL.
Embed
  1. SELECT o.vipname 收货姓名,o.vipmobile 收货手机,FROM_UNIXTIME(o.paytime) 支付时间,o.totalprice 订单总额
  2. FROM wfx_shop_order o
  3. WHERE o.ispay = 1 AND o.id>9642
  4. ORDER BY o.totalprice DESC