revise order with raw sql test