Invalid query: SELECT distinct ItemID FROM `OrdersItems` WHERE OrderID in(SELECT OrderID FROM OrdersItems WHERE ItemID in())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
SELECT distinct ItemID FROM `OrdersItems` WHERE OrderID in(SELECT OrderID FROM OrdersItems WHERE ItemID in())