SELECT productnote, orderid, productname, productcode, quantity 
FROM products.receiving_archive
WHERE orderid IN 
(SELECT orderid 
FROM products.receiving_archive
WHERE batchnumber = (SELECT MAX(batchnumber) FROM orders))
AND qtyonhold > 0
ORDER BY productnote DESC