SELECT od.orderid,
od.orderdetailid,
od.productnote,
od.qtyonpackingslip
FROM orderdetails od
JOIN orders o ON o.orderid = od.orderid 
WHERE od.productnote LIKE '% | %' 
AND od.qtyonpackingslip IS NULL 
AND o.orderstatus = 'Shipped'