摘要:
#查询自2010-12-1 到 2011-2-28延期三天以上没有发货SELECT DISTINCT user_idFROM order_infoWHERE order_id IN ( SELECT order_id FROM shipping_package WHERE add_time < shipping_time OR shipping_status = 0 )AND add_time >= (UNIX_TIMESTAMP('2010-12-01 00:00:00')-28800)AND add_time <= (UNIX_TIMESTAMP( 阅读全文