mysql 语句练习
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
PHP程序员
人在北京
如有需要,可以站内联系我!!!