SELECT * FROM (

SELECT bb.* FROM (SELECT dt.action_id, dt.order_id, oa2.shipping_status FROM (

SELECT oa.* FROM t_order_action oa WHERE
oa.log_time >= UNIX_TIMESTAMP('2012-01-09 00:00:00') - (3600 * 8)
AND oa.log_time < UNIX_TIMESTAMP('2012-01-10 00:00:00')- (3600 * 8)
AND action_note LIKE '%分配给1110%'
GROUP BY oa.order_id ) AS dt

JOIN t_order_action oa2 ON oa2.order_id = dt.order_id ORDER BY oa2.action_id DESC ) AS bb
GROUP BY bb.order_id ) AS cc
WHERE cc.shipping_status = 13

优质内容筛选与推荐>>
1、<转>水平权限漏洞的防护功能实现
2、浙大研究生复试上机考试2005——畅通工程
3、A call to PInvoke function 'TestFunction!TestFunction.Program::xvid_global' has unbalanced the stack
4、差分法
5、Word Search

赞赏

长按二维码向我转账

受苹果公司新规定影响，微信 iOS 版的赞赏功能被关闭，可通过二维码转账支持公众号。

阅读

已发送

发送中