select * from orders where ActionID<>0 and (actiondate between #2006-5-15 0:00:00# and #2006-5-15 23:59:59#) and state<10 order by actionid desc