[Koha] Reversing "Ordered" indicator on books

Please assist me with an SQL code that can automatically remove "ordered" indicator from hundreds of books to normal status to allow them for checking in/out. This is urgent as we try to commission the system. There was a mistake when manually cataloging the books. Thanks in anticipation. Raphael