From surenkid, 8 Months ago, written in MySQL.
  1. SELECT o.wechatorderid, o.`name` product, o.num, total,  o.transaction_id, o.pay_time, m.`name` member, m.nickname,, s.storename, s.esid
  2. FROM smwx_order o
  3. LEFT JOIN smwx_member m ON o.memberid =
  4. LEFT JOIN smwx_store s ON o.storeid =
  5. WHERE o.order_type = 'MASK_DAY' AND o.pay_time IS NOT NULL

Replies to vini查询订单详细信息 rss

Title Name Language When
Re: vini查询订单详细信息(按门店排序) surenkid mysql 8 Months ago.