We're having the same problem:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT * FROM uc_orders o WHERE order_id IN () in XXXXXX\includes\database.mysql.inc on line 172.When I try and select orders by status I get nothing. Then when I click "export" I get this error.