SELECT o.OrderID, o.OrderDate, od.OrderDetailID, od.ProductCode, od.ProductName, od.Quantity, od.QtyOnHold, od.QtyShipped, od.ProductNote, od.QtyOnPackingSlip FROM orders o JOIN orderdetails od ON o.OrderID = od.OrderID WHERE o.Order_Entry_System = 'MARKETPLACE' AND od.QtyOnHold > 0 AND o.OrderID > 4000000 ORDER BY o.OrderDate